Invoice Entry Database

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Thank you in advance for any help.

I'm trying to create a database in Access for entering
invoices for an Accounts Payable department. Is there any
way to dynamically add lines to a database in Access?

For example some invoices only contain three distribution
lines but other might have six or seven. I'm trying to
create a form but I don't want there to be a fixed number
of distribution lines if people won't always use all of
them. I would like to have a button that can add a line
when people need it. I'm using Access 2000.

Any help is greatly appreciated.

MIKE
 
You would use a separate table for the items associated to an invoice. This
table should be the many side of a one-to-many relationship with the table
that holds the invoice's primary data. Then on your form you would use a
subform to display/edit/add records to that table.
 
Thanks Ken -

Quick follow up - eventually I wanted to be able to export
all the data to Excel. Would having multiple tables make
this more difficult?

Also, do you know of any freeware on the web where someone
might have been working on the same thing as me? I
thought if I could look at another database I might be
able to modify it for my use instead of starting from
scratch. Thanks again.

Mike
 
Check out the Northwind sample database that is included with your ACCESS
software. It has Orders and other types of examples.

As for separate tables, that is how you use a relational database. You then
use queries to join tables together for exporting data.
 
Back
Top