Lookup Value in other Dataset?!
Hi there ...
we currently try to figure out how we can lookup a value in a diffrent dataset.
e.g. We are having a "ProjectContact_Address_ID" and wanna lookup the "FullName"-Column in the Address-Dataset ?! ...
is there a simple way to do this for a Textfield ?!
dunno something like:
Lookup(<PrjTbl."Contact_ID">,<Address>."ID",'FullName');
?!
(Changin the underlaying queries is no option ... *g*)
Greetz Andy
we currently try to figure out how we can lookup a value in a diffrent dataset.
e.g. We are having a "ProjectContact_Address_ID" and wanna lookup the "FullName"-Column in the Address-Dataset ?! ...
is there a simple way to do this for a Textfield ?!
dunno something like:
Lookup(<PrjTbl."Contact_ID">,<Address>."ID",'FullName');
?!
(Changin the underlaying queries is no option ... *g*)
Greetz Andy
Comments