Hi,
in a scenario with a table "Customers" residing on db # 1 and a table "Dossiers" residing on db # 2, I can't directly search related fields (in my case, I need to search in the company name of Customers from within Dossiers, using the relation dossiers_to_customers).
If the relation is multi server, when in find mode Servoy considers all the field of dossiers_to_customers relation as Undefined and, when trying to set them a value for searching, I get an error like:
ReferenceError: "dossiers_to_customers" is not defined.
So I'm asking, how can I let the user to search in those related fields (without creating a stored calc in dossiers that replicates the company_name, of course)?
Thanks