A family of Microsoft relational database management systems designed for ease of use.
That's pretty much the case. The key word when defining a relationship type is 'each':
1. If each row in TableA can reference one or more rows in TableB and each row in TableB can reference only one row in TableA then the relationship type is one-to-many, with TableA being the referenced table, and TableB being the referencing Table. The primary key in the referenced table is referenced by a foreign key in the referencing table.
2 If each row in TableA can reference only one row in TableB and eachrow in TableB can reference only one row in TableA then the relationship type is one-to-one , with TableA being the referenced table, and TableB being the referencing Table. The primary key in the referenced table is referenced by a foreign key in the referencing table. The foreign key is also the primary key of TableB.
- If each row in TableA can reference one or more rows in TableB and each row in TableB can reference one or more rows in TableA then the relationship type is many-to-many. This is modelled by a third table which resolves the many-to-many relationship type into two one-to-many relationship types, i.e. it has two foreign keys referencing the primary key of the TableA and TableB respectively.
You might like to take a look at DatabaseBasics.zip in my public databases folder at:
https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169
Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to amend the form design accordingly.
If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.
This little demo file illustrates, amongst other things, the various relationship types and how they are modelled.