navigating between forms

hallo,
i have 2 tables in my mysql database with structure Table 1(id,fgnr,made,type,color,year) and Table 2 (id,fgnr,made,type,name,vorname).for each of these tables i have a corresponding form. i can insert a new row in Table 1 and pass the three variables (fgnr,made,type) in hidden fields to Table 2 which i then insert with the remaining fields.
My Problem:
Say i open form 1 and do any changes to any fields and want to correct the same row in form 2 table 2.how do i go from form 1 to form 2 and display all fields where (fgnr) in form1 equals (fgnr) in form 2. i do not use the id field because there can be 20 rows in table 1 and only 10 in table 2. instead i use it when searching my db. hope anyone can help.
in the attachment file i have code which searches,edits and inserts a new row

Adipat,

I'm not sure what you're trying to do... Would it be possible to post a snippet of code you have.

It will help determine the problem.


Thanks,

There is no problem - just put in 1st form Primary Keys row to array, send it to form2 and get data with same numbers

Sincerely,
Sergey Booyny
AlarIT programmer
http://www.AlarIT.com

Sergey,

Thanks for the assistance... I wasn't sure what was trying to be done!