B
Brook
I am setting up a billing/invoicing database based on a
client table and an inventory table. When I pull up my
form (clienttable)/subform (inventory), I choose the items
that I want on the invoice from the inventory subform.
What I would like to do is set up an invoice/report to
pull the data from the form/subform and once the report is
closed the form/subform reset, and the client is added to
my invoice table and inventory table (as a sold item).
Does anyone have any tips or suggestions on how to
accomplish this? or know of any sample databases I could
take a look at?
Brook
client table and an inventory table. When I pull up my
form (clienttable)/subform (inventory), I choose the items
that I want on the invoice from the inventory subform.
What I would like to do is set up an invoice/report to
pull the data from the form/subform and once the report is
closed the form/subform reset, and the client is added to
my invoice table and inventory table (as a sold item).
Does anyone have any tips or suggestions on how to
accomplish this? or know of any sample databases I could
take a look at?
Brook