look up in 2nd tbl for text and look up in 1st tbl

look up in 2nd tbl for text and look up in 1st tbl

Hi there

how do i automatically get all other fields (including look up fields) related to one record from a particular table in to another table after selecting (by using look up) one of the non look up field of the first table.

I hope i am clear. I tried a lot to post the lengthy query detailing the entire scenario with a link of my zoho document which contains all the structures of all the tables. somehow my query is not getting posted. I hope this works.

Further, can i create multiple forms in relation to different fields of same table.

regards!

Anand