Hi there,
I’m having an issue where the referenced column is not populating information from the correct table.
I have an Invoice ID reference to the Invoices table on my Small Parts Line Item table. It is part of the Invoice table using the checked box. I have an identical reference in my Equipment table to the Invoice table to created 2 line items that can be added to an invoice. The problem is common to both line items, so thats a little puzzling.
When I add new line item to an invoice, the reference that is carried to the line item form is actually the Client Name which is from another table called Clients.
When I change the referenced table to Clients instead of Invoices, the actual Invoice ID is populated in the dropdown box. When I change it back to the Invoices table, it again repopulates from my Client table.
So for some reason the association is switched. I tried regenerating every single table I have an it did not fix it. I changed the references back and forth, which rebuilt the Related Small Parts Line Items virtual columns so I know that the change in referencing worked.
This is a new problem, it has always worked properly before so I’m thinking as I type this that some part of my setup is incorrect.
Has anyone seen anything similar?
