I've created a custom entity called Event which has its own table. It is related to Customers via drop down. I recently linked the Invoice Table so I can associate an event to a specific invoice. On the related screen, I added a drop down field for the Invoice to select the invoice ID to create the association. It worked fine for a few days.
Recently I added a tab to the Event
screen to show the line items of the invoice. I used the selected Invoice to drive the contents of the Grid. While setting up, i noticed that the Invoice was not considered a linked table I don't know if this is relevant, but since the change the Invoice drop down is no longet showing the invoices related to the customer. I've changed the filter from the Customer name to the customer record ID but still getting the same incorrect content in the drop down.