saving 8 rows as one

  • Thread starter Thread starter Guest
  • Start date Start date
my only suggestion is: don't.

if a customer submits an order, requesting 8 products, then you should have
one record in an Orders table, to store the order; and 8 records in an
OrderDetails table, to store each product that was requested. this is a
standard parent/child table setup that follows data normalization rules.

hth
 
Since this is the whole purpose of the sample database, Northwinds, that
comes with Access, you should take a look at it. If you have not written
much of your application, you might even scrap it and use the Northwinds
database as your template.

Rick B
 
Back
Top