Insert multiple records at one time
Thank you for your time and help in advance. I am trying to create a data base for a material order form. This form has 15 columns and 20 rows. The first issue I run into is the fields in each column get populated by whatever was entered last in that column. What I am trying to do is create the ability to fill out the rows with information and then create a different record in the same table for each row of data that is filled in. Not all of the rows will be filled in and I will only want to recordize the ones that are. Any thoughts or ideas on how to do this are greatly appreciated.