Tell me more ×
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.
up vote 1 down vote favorite

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
1  
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 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 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 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 at 18:09

closed as too localized by JNK♦ Mar 7 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, see the FAQ.

Browse other questions tagged or ask your own question.