Hi all,
I've got a database with three tables; CustomerDetails, OrderDetails and OrderLines. I'll link it below.
I'm pretty sure the relationships I have thought should work in theory but when I try and implement them in Access, there's no way to change the relationships.
Just wondering if anyone can give me some guidance on how to get the following relationships in my database.
1) OrderDetails - One-to-One - OrderLines
2) OrderLines - Many-to-One - CustomerDetails

My thinking is this:
1) Each Order can relate to one OrderLine
Each OrderLine can relate to one Order
2) Each OrderLine can relate to one Customer
Each Customer can have many OrderLines

Any help would be really appreciated. I've been everywhere looking for help and no one is replying
Here's the link:
https://drive.google.com/file/d/0Byk...ew?usp=sharing