text & look up from 1st tbl to 2nd

text & look up from 1st tbl to 2nd

Hi there,

thank you for wonderful software and such a lively forum

I have four difficulties

First one
in one form i have got several text fields and look up fields. in the second form i am interested in one look up field based on a text field of the form mentioned earlier, which will import all the other associated fields of the said form in realtion to such record in to my new form.

To clarify I have described the the form structure and their relationship here
<script
src="http://writer.zoho.com/public/moreanand/Zoho-creator-query1/script"
></script>

Second one
Can i create multiple forms in relation to different fields of the same table?

Third one
Why am i required to log in arbritrarily for many times when i have already checked in the keep me signed in checkbox?

Fourth one
Why my earlier post with a single sentence got posted as new topic and why my earlier post containing this query was kept pending.

Regards!
Anand