Layout With Relationships (Lookup?)
I have my tables setup but having problems with the layout connecting to the tables. What I would like to happen is to create a layout with Items and Location. In both tables I have a Tag field. I want to enter a Tag number and add the rest of the information into the fields, but only enter tag number once. When the data is saved it puts the tag number in the field in both tables.
I have been told that I need to create a button for location because you can not have more then one table in the layout. So if that is correct I would need to click the location button but would like the tag number then to be placed in the tag field in the Location layout table. How can I accomplish this. I have been trying for about 2 weeks but have had no success.