He everyone,
I am new to Access and trying to learn by reading, watching and practice.
I have a question regarding relationships between tables.
Lets say I am providing service delivering Items from one location to another.
I have created 4 tables: tblCities, tblStates both linked to tblLocations and tblFromTo.
In the tblFromTo table I have FromLocationID and ToLocationID fields which I want to link to the tblLocation.
Could you advise what would be the best way and practice to do that?
I am new to Access and trying to learn by reading, watching and practice.
I have a question regarding relationships between tables.
Lets say I am providing service delivering Items from one location to another.
I have created 4 tables: tblCities, tblStates both linked to tblLocations and tblFromTo.
In the tblFromTo table I have FromLocationID and ToLocationID fields which I want to link to the tblLocation.
Could you advise what would be the best way and practice to do that?