Rec.selection formula with select from

[ipazzo]

Is it possible to write a record selection formula checking that the value of a field is in another table ???

Ex.

zip in (select zip from country where state = 'italy'

Thanks for any suggestion ;-)




Vito M. from BARI (Italy)
---------------------------------------
When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to lose. Ross Perot

 

[synapsevampire]

Unfortunately not from within Crystal, an intentional oversight on their part.

There are 3rd party products which allow for dynamic parameters, as in

http://www.milletsoftware.com/DataLink_Viewer.htm

Or you can use external code to do this.

-k

 

[ipazzo]

GRRR

ok, thanks for the answer, i will search for another solution.


Vito M. from BARI (Italy)
---------------------------------------
When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to lose. Ross Perot