I have two tables, Devices and Cables.
On a form in Cables I need a drop down list of all the record ID's in Devices.
Once a particular record ID is chosen from the list I need 5 fields associated with that ID to fill on the Cables form.
Essentially I need Device information to auto populate on the Cables form when a record ID is selected.
Is this even possible?
Just make a Relationships between the two tables. Here is some help on Relationships.
Post back if you get stuck anywhere.
One Device has many Cables.
But I will bet'ya that a Cable can be used for more than 1 Device.
So you will need to have a new middle join table called Device Cable Assignments.
1 Device has Many Device cable Assignments
1 cable has many Device cable Assignments.
So just delete your existing relationship and start over