I'm working on an inventory database. I have two tables...Equipment and Deployed.
Equipment has two fields: Serial Number (text field) and Deployment Status (lookup field).
Deployed has one field: Serial Number (text field)
I want to be able to select "Deployed" in the lookup field on the Equipment table and have it automatically update the Deployed table with the Serial Number from the Equipment table.
Does this make sense, and is it possible?