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
