HP_Design

I know how to make an insert statement but thank you for your help. I am wondering if the best way to accomplish my task is filter my customer #'s put them in an array and loop through the array with the insert statement.

I am programming a booking system that will allow a user to enter 1 Item # and then choose several customer #'s to book that item for. Should I do the following or is there a better way? 1. Start the page with a list of all customers (Currently 11,725 Customers) 2. Then filter by Route, Store Type, State, etc. 3. Then store Customer #'s that are left in an array. 4. Loop through each Customer # in the array and add the same 1 Item # to each of the different Customer #'s Insert Item # and Customer # into the table. (Each row would contain Booked Date, Customer Number, Item Number and Item Description) - "The Customer # would be the only value that changed" For example I need to be able to book an Item to each of our customers in Florida. I might have 500 customers that are going to get Item 43543. I do not want to have to put in individual customer numbers. The Item Number will always be the same for each booking. Thank you for your Help and Ideas.