http://forums.asp.net/t/1020390.aspx/1?Adding+records+with+multiple+valuesThu, 24 Aug 2006 12:52:54 -040010203901379707http://forums.asp.net/p/1020390/1379707.aspx/1?Adding+records+with+multiple+values <p>Hello,</p> <p>This is my issue, I am inserting records in a Access db.&nbsp; After I insert the new record, I am retrieving the new inserted record unique ID and inserting it along with another value from the new record into a different table in the same database.&nbsp; The new record is going to have a field that contains multiple values.&nbsp; I don't know if I stated that correctly but here is an example.&nbsp; </p> <p>I have a form that a user inserts a new customers info.&nbsp; Among the pieces of information is, what products is the customer associated with.&nbsp; More than likely he will be associated with multiple products.&nbsp; <br> <br> So I am using a dropdownlist to display the products so the user can choose from the list.&nbsp; Keep in mind the products list is about 50 items.&nbsp; I am trying to give the user the ability to pick more than one product from the product dropdownlist and for those multiple items to be inserted into a table but in 2 different rows.</p> <p>I hope what I stated above makes sense. Any information is helpful.</p> 2006-08-24T12:52:54-04:00