hi folks,
i am creating a database in access 97. I have designed 5 different forms which are all linked to the same table. the forms share some of the same fields but not all, except for the admin form which sees them all. my forms are made up of textboxes and i need to create rows in my table when a value over 1 is enetered in one of these textboxes, (number_of_panels.text). for example if the number 4 is entered into this textbox, 4 rows should be added to the table, using the same primary key but adding a file extension to the primary key to keep it primary. Eg. if primary key = myname and the user enters 4 as the number of panels the primary keys should now be myname_1, myname_2, myname_3, myname_4. so basically a multiple INSERT INTO statement is needed. i need help!!!!!
any help would be greatly appreciated!! :-|