Searching on related fields of different db

Questions, tips and tricks and techniques for scripting in Servoy

Searching on related fields of different db

Postby Riccardino » Wed Jun 03, 2009 11:33 am

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)? :wink:

Thanks
ciao, ric
User avatar
Riccardino
 
Posts: 911
Joined: Thu Apr 24, 2003 11:42 am
Location: Ferrara, Italy

Return to Methods

Who is online

Users browsing this forum: No registered users and 48 guests