copy text & lookup fields from 1tbl to 2nd tbl

copy text & lookup fields from 1tbl to 2nd tbl

Hi there,


Thank you for such a wonderful software and such lively forum. I am new to any programming or scripting.

I have a difficulty.


In one form I have got several text fields (where the user enters the data by actually typing it) as well as look up fields (where the user enters the data by selecting the options available from drop down options generated with look up from another table).


In the second form I am interested in putting one look up field based on the abovementioned first form, which will automatically fetch all the fields associated to that record in the first form and will also give me the facility to add further text fields and additional lookup fields not based on abovementioned first form but on completely different forms.


For your convenience I have shared a document detailing the structure and relationships of my table. the link is

<script
src="http://export.writer.zoho.com/public/moreanand/Zoho-creator-query1/script"
></script>


I have one more query,

Can I create multiple forms for different parts of same table?
With warm regards!