Hello I'm completely new to Access 2007. I'm having difficulty with a tutorial. This is a very common scenario. I have 3 tables:
Member
Video
Loan
I create relationships but how do you make access know the type of relationship you want?
I want members to loans to be 1 to many
I want Loans to Videos to be 1 to 1
but access decides differently, why? How can it know the relationship?
How can I get what I want?
Thanks