Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Thank you.

share|improve this question

closed as too localized by JNK Mar 7 '13 at 18:25

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Since 1..N groups can refer to an activity, the FK should be in GROUP and point to the PK in Activity. – JNK Mar 7 '13 at 17:58
OK, so my original design is correct. So why am I not getting the drop down in Access. It has been some time since I have used MS Access. – diek Mar 7 '13 at 18:00
The access issue is probably better on SO. We have a gray area on this site about access in particular since there are database portions and programming portions. – JNK Mar 7 '13 at 18:01
When in doubt review the Northwind Database. In similar tables it does the same as mine. I guess I needed to know that the design was correct and you confirmed it. So you need to submit your comment as the answer so I can mark it answered (as I understand).Thank you. – diek Mar 7 '13 at 18:09

Browse other questions tagged or ask your own question.