I have established a database table that contains many records that are grouped by a  specific code. There may be many records with the same code.

example:

code      ident
BRL-01  120986
BRL-01  118358
BRL-01  127077

I want to join this table with another table using the ident field.

example:

name                 ident
John Doe            120986
Jane Doe            118358
Betty Boop          127077

Then I want to be able to store the joined records with other fields entered by the user.

example:

name                 ident         code          data1      data2      data3
John Doe            120986      BRL-01      3            390         130
Jane Doe            118358      BRL-01      3            375         125
Betty Boop          127077     BRL-01      3            420          140

I can't seem to figure out how to select the data from the two files join them together and then allow the user to input the additional data thru a form which will insert the data into a third table. I'm able to find and insert one record but I can't seem to figure out how to loop thru the data using forms.

Any guidance that would point me in the right direction would be greatly appreciated.

Hi

Here your solution.

You can get the form posted data before fetch record or after fetch record from table; thats depends on your requirement.

Example:
You fetched the records and showing in multiple row update form page or which way you need.

you have keep the all form posted records in array.

This is query as your need, you can customize as per your need with posted form data.

select table2.name, table2.ident, table1.code, '' as data1, '' as data2, '' as data3 from table2, table1 where table2.ident=table1.ident


_________________
Thanks,
Muthukumar Selvarasu,
Project Manager,
Webmasters Ltd.