C
CalNativeKid
Not sure how to properly configure queries so I can 1) View/Delete existing
Activites for a selected Vessel and 2) View/Add activity list items not yet
associated with a selected vessel. (filtered by VesselID). For this example I
am using a single form with the Vessel selection on top and a subform with
Activities on the bottowm but am open to other solutions.
Note I had a tabbed subform with 9 tabs and would like to eventually get it
working this way since I have 8 other tables like activities to deal with.
Design:
tblVessels:
vesselID, Autonumber, primary key
Name, text
....
tblActivities:
activityID, Autonumber, primary key
activity, text
....
tblVesselActivities:
activityID, number, primary key
vesselID, number, primary key
tblVessels have a (1 to Many) relationship with tblVesselActivities
tblActivities have a (1 to Many) relationship with tblVesselActivities
tblVesselActivities is a linking table between tblVessels and tblActivities
Not sure what is wrong or direction. Any help is appreciated.
Activites for a selected Vessel and 2) View/Add activity list items not yet
associated with a selected vessel. (filtered by VesselID). For this example I
am using a single form with the Vessel selection on top and a subform with
Activities on the bottowm but am open to other solutions.
Note I had a tabbed subform with 9 tabs and would like to eventually get it
working this way since I have 8 other tables like activities to deal with.
Design:
tblVessels:
vesselID, Autonumber, primary key
Name, text
....
tblActivities:
activityID, Autonumber, primary key
activity, text
....
tblVesselActivities:
activityID, number, primary key
vesselID, number, primary key
tblVessels have a (1 to Many) relationship with tblVesselActivities
tblActivities have a (1 to Many) relationship with tblVesselActivities
tblVesselActivities is a linking table between tblVessels and tblActivities
Not sure what is wrong or direction. Any help is appreciated.