Best way to deisgn the tables

[debraj007]

Morning! I have a Invoice and an Invoice Details table. At the moment I have
a services table, and you choose from a drop down which item to bill for, it
autofills the price for that item.

My problem is this, we would like to be able to choose a service, say,
basket weaving, and put in a description, which will change with every
invoice, (every service must have a description that tells the customer
exaclty what we did, like 27 ft. of straw, hand weaved, etc.) that will print
on the invoice. I'm not sure the best way to do this as if I put a
description field in my services table, then that description will change,
and I need to be able to go back and reference old invoices.

In the invoice details table should I just create LiteItem1, LineItem2, etc.
and then type in each service and descrition each time?

Any ideas? Thanks for the help in advance

 

[Duane Hookom]

Your table structure should look similar to the Order and OrderDetails in
Northwind.mdb. Don't create fields like LiteItem1...x

If your description changes from invoice to invoice for the same service you
can use a default from the service table and modify in eacn invoice detail
record.