I thought I had this figured out but I am starting to doubt myself on something that should be simple. I have a table of Group, and a table for Activity. Each Group has one Activity. Different groups can have the same Activity.
Right now I have the foreign key in the Group table connected to the primary key in the Activity table. I started to doubt myself when I started entering data into the Access database table Group.
When I got to the foreign key field to enter the data for Activity ID in the Group table, I did not get the (+) symbol to allow a drop down choice.
Should the table Group have a foreign key for Activity table (the way I have it now), or should the Activity table have a foreign key for Group ID?
I am having a rough week, with stomach flu, and I am just not on my game