Firstly, sorry for the poor explanation but I am at a loss how to explain it in a few words!

I am building a transport database which will provide a delivery schedule. In order to do this the record (in table named tblSchedule) needs to show three locations, origin, intermediate point and destination. Each location has a unique record number and address. All the location data is kept in the table named tblLocation. I have created a relationship between the two tables linked bt the location number.

In tblSchedule I have created three drop down lists which reference the location number (Loc1, Loc2 & Loc3) from tblLocation and three address fields (Add1, Add2 & Add3) associated with each of the three locations. The problem is that I can't think of a way of getting three different locations to display, when I select Loc1, then Add1, Add2 & Add3 all populate with the address associated with Loc1, when I then select Loc2, Add1, Add2 & Add3 all change to the address associated with Loc2. I don't think I need to go on any more I hope you get the idea.

Can anyone tell me if there is a way of keeping the three locations independant of each other, short of creating three location tables?

Many thanks in advance.

If a record in the Schedule table has three locations, you will need (at least) three relationships between Schedule and Locations.