What are One-To-Many Relationships in Access 2007? A One-To-Many Relationship is a relation or connection of a Primary Key in one Table to a Foreign Key in another. A Foreign Key is a field in the other table, that the Primary Key is linked to, and holds the same Data Type. Where one record in the main table will be linked to many records in another. Or put another way you may have many customers, but each customer is unique and would be counted as one. However, if you make many sales to the one customer then you would have One customer to Many sales or Orders, and so a One-To-Many relationship. See this in action for yourself and watch our Certified Trained Access Videos!

Purchase the training video and you can see this in action for yourself!