I have 3 tables:
- Units - a list of all our technology units whether classified as inventory or leased to a customer
- Customers - linked to the Units table
- Unit Setup - this is a form to be used by the shipping department to go through shipping checklists AND assign a Unit to a Customer.
I cannot figure out how to get the Unit Setup Form to update the Unit assigned to the Customer. I can get it to add a new linked record column… but I want it to update the main associated Customer record to the Unit.