saving 8 rows as one

[Guest]

any suggestion of how to save a bill order of 8 products as one record???

 

[tina]

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

 

[Rick B]

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