How to Lookup two companies data in single form??

kishi_g · 2007-12-26

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 · 2007-12-26

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

you can use CHANGECOMPANY function.

kishi_g · 2007-12-26

Thanks for ur reply. Can u explian in detail.

Thanks & Regards,
Kishore.

ara3n · 2007-12-26

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.

How to Lookup two companies data in single form??

Comments

Categories