Hello everyone!

I am having an issue whilst trying to search for records in a linked table.

So, I have a Product Quote table where I insert several details regarding a certain Product Quote: price given to me by suppliers, supplier name, brand, etc.

This Product Quote is linked to 3 other tables which contain "master data": brands, products, suppliers, etc.

The goal is that when my procurement team is using the Product Quote table they will only have to search the linked tables for this data, instead of having to enter it each time. With that purpose in mind I created the linked tables and in the Data Entry Form they have a popup where they can find search for the brand, product, etc.

Problem is sometimes the linked tables' entries do not appear at all and the search in the popup simply does not work.

It is very weird, since if I open, for instance, the ProductBrand table, where I have about 90k entries, and use the search inside that table view it works without any problem.

Furthermore, the global search function is not returning any results as well, which is baffling since Global Search boolean is enabled for every table.

Does anyone have any insight into this issue?

It is kind of deal breaker for our company if I cannot have "master data" lists in other tables.

Thank you for your support.

Kind regards