I created a data base to allow people to input equipment problems the form has combo boxes for date, person reporting, building location, room, and item. I got this working just fine with them selection item by serial number. I created tables for each one of these. In the item table I have additional information about each item Rebuilt date, size ect. and a tag number.
In the combo box of the item only list the items in the room selected and only shows the serial numbers available. It has worked fine but when adding the record it doesn't include the tag number. I want to change so that only the tag number is needed in the form but will record both the tag number and the serial number in the record?
I managed to switch the combo box to the tag number instead of the serial number and added a text box that then shows the serial number also but when I try to save the record I get this error message ( you can not add or change a record because a related record is required in table "RackIdt" ) this is the table that has the rack information SN, tag number ect.