B
Brook
Hi All:
Here is what I have and what I am trying to accomplish:
I create orders for clients on a daily basis, but only
invoice the clients once a month. So what I have is an
Orders Table that has all my current orders that have been
placed by my clients.
What I am trying to accomplish to be able to possibly
have a pop-up box that I can choose what client I am
creating an invoice for, then select the orders that I
want to include on that invoice. However, I cannot figure
out how to accomplish this. I have the ideas in my head
but they are not working well when I try to get it into
the code. I have thought about using a subform, but am
unclear how to accomplish this. Would I need to create
another table that will house the invoice number and
orders associated with that invoice as well as for invoice
payments?
If anyone has any ideas, suggestions, tips they are all
greatly appreciated. Please feel free to email me if you
need more information: brook at karmaimports dot net
Thanks in advance!
Brook
Here is what I have and what I am trying to accomplish:
I create orders for clients on a daily basis, but only
invoice the clients once a month. So what I have is an
Orders Table that has all my current orders that have been
placed by my clients.
What I am trying to accomplish to be able to possibly
have a pop-up box that I can choose what client I am
creating an invoice for, then select the orders that I
want to include on that invoice. However, I cannot figure
out how to accomplish this. I have the ideas in my head
but they are not working well when I try to get it into
the code. I have thought about using a subform, but am
unclear how to accomplish this. Would I need to create
another table that will house the invoice number and
orders associated with that invoice as well as for invoice
payments?
If anyone has any ideas, suggestions, tips they are all
greatly appreciated. Please feel free to email me if you
need more information: brook at karmaimports dot net
Thanks in advance!
Brook