Why do you not have the LocationAddresses 1-10 in a separate table, related to the Movements Table, just as you have Locations related to the Movements Table?
I'm not sure what you mean by having LocationAddresses 1-10 in a separate table.
I need a table (tblMovements) which amongst other things has a list of all the locations he visited during one day. It lists 10 locations (LocnID1 to LocnID10) & the 10 associated addresses (LocnAdd1 to LocnAdd10). The Location information is stored in tblLocn and it contains one entry for each of the possible 500+ locations the driver could visit. The two fields this info would be picked up from are LocationID & LocationAddress. I created 10 relationships between the two tables, linking LocID1 with LocationID, LocnID2 with LocationID etc. Referring each of the 10 LocnAdd entries with the relevant relationship. I'm new to Filemaker but have used Access before and I guess I haven't got the hang of the differences between the two.
I hope the above makes things a bit clearer about what I'm trying to achieve.