How to Lookup two companies data in single form??

kishi_g

Hi,
Iam using Nav native database with two companies(company1,company2). In one form i have two lookups. when i press lookup1 then company1 customers will show.
when i press lokup2 field then company2 customers will show.

Is it possible????

Thanks & Regards,
Kishore.

ara3n

what do you mean you have two lookups?
You have two fields that lookup into customer table?

you can use CHANGECOMPANY function.

kishi_g

Thanks for ur reply. Can u explian in detail.





Thanks & Regards,
Kishore.

ara3n

onOpenForm trigger of customer list add the following code
CHANGECOMPANY(companyName2);

This will change the list for company2..


Hit F1 and search for changecompany, if you can't find it.