Trying the Separation Model

[faada]

Ok, I've decided to try the separation model for the new multi-location inventory system I'm putting together, basically my data will be separated into 3 main tables, Location Master, Item Master, and Item/Location (which will house the actual quantities).

These are the fields I have in each table

Item Master: Item#, Description

Location Master: Loc Code, Description

Item/Location: LocCode, ItemCode, Quantity, UID (an auto-enter field which is the LocCode & ItemCode, there is a not equal self-join based on this field to ensure uniqueness based on both location code and item code at the same time).

Now, using the separation model I should have the layouts and scripts etc in a new file correct? Could someone give me a run-down of how the relationships etc should look?

Thanks in advance