-1

I have a main table called person and child tables member, volunteer, sponsor which are connected to the main table as 1:0..1 in ms access. But when I am about to enter records in let's say volunteer, I get the little plus sign from which I can enter records to the main table which makes it a 1:m kind of relationship. How can I resolve this? Pics included

1: https://i.stack.imgur.com/wyyQM.jpg 2: https://i.stack.imgur.com/wyyQM.jpg

PeeHaa
  • 71,436
  • 58
  • 190
  • 262
barack o mama
  • 129
  • 1
  • 2
  • 9

1 Answers1

0

That + sign on Tables only means the table has a relationship to another table. So if set up like your pics above, you should still be maintaining a 1 to 1 link.

To see or change this, open the Main Table (with +) and in the highlighted Table Tools above the ribbon, select Table and find Relationships. In it, you will see the relationships made. These are used to inform other objects (i.e., forms, queries) of how your tables relate and to avoid orphans and maintain referential integrity.

See more info at this MS Office Guide.

Parfait
  • 104,375
  • 17
  • 94
  • 125