I would like to adjust my table relationships so that the following happens:
Tool List is the Master Table
All other tables are slaves.
I have inherited this from someone else so I am working through this.
The ID’s in the other tables are from the “Tool List” ID but were just named “ID” in that table. Should I change that? To “Instrument ID”??
Also the “Tool List” table has a “Type of Device” field which identifies what each instrument it via a description.
I want to put that field as it related to the slave tables such as Temperature, Deflection, Dimension so that respective table will only see or accept data from the Master table that is related to itself.
Can someone give me an example of how to do this. I then will make Forms that relate to each slave table that will accept data related to itself.