Invoice Creation

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

What I am trying to accomplish is this: I have an orders
tables, and I place orders for clients at different times.
What I am wanting to do is that when I go into my form, a
popup will allow for me to choose my client. Once I choose
my client, the form will come up with outstanding orders
that have not been invoiced for. Once the form comes up, I
can check a yes/no checkbox that will create an invoice
for all the items that I have chosen. Does anyone have any
ideas/suggestions on how I can accomplish this?

Thanks,

Brook
 
Brook,

You might want to try creating the "Order Entry" database
from one of the general templates that comes with Access.
Using the wizard, this database can be created in less
than 1 minute. Although this DB may not exactly match
what you want, it may be close enough. It also has a lot
of other features that you did not mention, but may want.
 
Brook said:
What I am trying to accomplish is this: I have an orders
tables, and I place orders for clients at different times.
What I am wanting to do is that when I go into my form, a
popup will allow for me to choose my client. Once I choose
my client, the form will come up with outstanding orders
that have not been invoiced for. Once the form comes up, I
can check a yes/no checkbox that will create an invoice
for all the items that I have chosen. Does anyone have any
ideas/suggestions on how I can accomplish this?
Click to expand...
The Northwind database has sample invoices.

I'm not sure exactly what you want to do but the generic answer is to have a
"yes/no" field in the header for the invoice and base your form on a qquery
that selects for what you want.

Usually an invoice would be created at the time of the order.
If you want to pick x out of y items to add to a particular invoice the
method would be essentially the same but you might have to force the invoice
number onto each line item.
 
Back
Top