Multiple Table LookUp

Hi All,

I write a look up for a form using two tables For salesId i will get from sales table and Itemid , item Name will selected from sales line did any one help me

Thanks

Kalai selvan

Hi,

If u want a look in the form ,u just go the perticular tables and use relations. what fields if u want to get in the lookup.there are two ways to get the lookups.from the EDT level and table level relations .u just observe the standard relations.then u will get an idea.

all the best

In the form level i want to look up But i want this look up in a single field(Ppap order) the salesid , itemid & item name should lookup

hi selvan,

you have a Field Group option in table …where you can drag and drop the field that you want lookup in the AUTOLOOKUP option…