I'm building an app to keep track of assets that are shipped to customer jobs. I have a Asset Master Table that keeps the serial numbers, status and other information on the assets, a Job Table that keeps track of the customer jobs, and a Shipment table that keeps track of the Shipping transactions. The Shipment table is related to the Serial Numbers from the Asset Table to pick Assets that are available to ship. The Job Table is linked to the Shipment table to keep track of the Assets that were shipped to and from that job.
I want to have the Shipment Table displayed as a subtable on the Job entry form and be able to select the Asset serial numbers in that subtable. However, when I try to do that, quickbase gives me a message that lookup fields are not editable.
Is there a way to work around this?