using a from for multiple entries processed at once to a table

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I have created a table to store billing info from various
companies.Using the autoform generated by access I input
the invoice no(Primary Key), the customer name, the charge
amount of the bill and I select the vat amount from a
combo box for the bill and this all gets stored in the
table.
This all works fine for bills that have single charges but
alot of the bills have multiple charges.
How do I go about creating a form that will allow multiple
charges to be processed to the table but all under the
same invoice number? So that I was to run a report from
the table the invoice no would show the all the charges
for that bill one after the other so I can then total them.

any help would be great thanks
Andy
 
Andy,

You need to create a subtable to hold the line items and
set up a one-to-many relationship.

Billing Table LineItemDetail
Invoice Number 1 >>>>>>>>>>>>>>>>>>>>>Item 1
vInvoice number 3 >>>>>>>>>>>>>>>>>>>>>Item 1
Invoice Number 4 >>>>>>>>>>>>>>>>>>>>>Item 1
v
Create an Order Entry database from File>New>Templates to
get an idea about the proper structure.

JohnR
 
Back
Top