Parameter based on two different tables? 1

[piovesan]

Hi;
I would like to create a parameter that will query two different fields in two different tables and get the results....... for example:

Get ALL records where Either "PARCEL"."MAIN_CLASS" = "BUSINESS PARK" OR "MODPARCEL"."MAIN_CLASS" = "BUSINESS PARK"

Can this be done in one parameter??
Thanks!

 

[Turkbear]

Hi,
If the value of the parameter will always be the same for BOTH tables, then yes..

After joining the tables use the parameter in the record selection formula like:

"PARCEL"."MAIN_CLASS" = {?Parameter}
OR
"MODPARCEL"."MAIN_CLASS" = {?Parameter}





To Paraphrase:"The Help you get is proportional to the Help you give.."