I phrased my question wrongly in my previous email and wished to thanks those who replied. I am trying to insert/update a table in a batch mode. The coding below is a simplified version. What I wanted to do is to INSERT/UPDATE a table (contact ) in a BATCH mode. The user will see a form listing (company) and select the option from table (person). Upon completion, the user a submit the matched listing to be inserted in another table (contact). I need some help in doing this in a BATCH mode. For e.g. if I have 10 companies with the selected persons in a batch to be inserted into contact table. Company name Person (company table) (person table) ---------------- -------- 1. company A Chan 2. company B Henry ... 10. company X Robert insert/update batch to contact table. Could someone give me some guidance? TQ Data Entry Form ============ <dtml-var standard_html_header> <h2><dtml-var title_or_id></h2> <form method="post" action="form2_action" enctype="multipart/data"> <table> <dtml-in listCompany_sql> <tr> <td>Company:</td><td><dtml-var co_name></td> <td><select name="last_name" value=""> <dtml-in listPerson_sql> <option value="&dtml-last_name;">&dtml-last_name;</option> </dtml-in listPerson> </select> </td> </tr> </dtml-in listCompany> <tr> <td><input type="submit" value="Submit" name="submit" /></td> </tr> </table> </form> <dtml-var standard_html_footer> SQL methods ========== listCompany_sql ----------------- select * from company listPerson_sql ------------- select * from person CREATE TABLE contact ( first_name char(20), last_name char(20), co_name char(20), co_phone char(20) ); CREATE TABLE person ( name_id int PRIMARY KEY, first_name char(20), last_name char(20) ); CREATE TABLE company ( co_id int PRIMARY KEY, co_name char(20), co_phone char(20) );