Unlimited Field Entries

[Avian]

I am trying to create an Access database to track Invoices and
Inventory. I want to tie all of my invoices that the user creates to
the products in our inventory. My goal is for there to be a field in
which a user selects from a list of items we have for sale. The
problem with this is that with this system, I can only sell one item
per invoice. How can I create a table (or maybe it's a form) that
will give the user the ability to enter as many products as they would
like, each time being able to select from a list of items that is tied
to an Inventory table. I hope my question makes sense. I look
forward to whatever response anybody can give me on this issue.

TIA

Avian

[Allen Browne]

You need an InvoiceDetail table, containing the line items for the invoice.
It will be related to your Invoice table, so that one invoice can have many
line items.

Open the Northwind sample database.
Choose Relationships from the Tools menu.
Look at the Orders and Order Details table.
That's essentially what you need to emulate.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Avian" <av*********@gmx.net> wrote in message
news:f8*************************@posting.google.co m...

I am trying to create an Access database to track Invoices and
Inventory. I want to tie all of my invoices that the user creates to
the products in our inventory. My goal is for there to be a field in
which a user selects from a list of items we have for sale. The
problem with this is that with this system, I can only sell one item
per invoice. How can I create a table (or maybe it's a form) that
will give the user the ability to enter as many products as they would
like, each time being able to select from a list of items that is tied
to an Inventory table. I hope my question makes sense. I look
forward to whatever response anybody can give me on this issue.