Invoice form/subform

[brook]

I am setting up a billing database that will connect to an
invoice table and an inventory table. What I would like is
the ability to add / modify and invoice and with a
subform, add/delete items from the invoice (which the
subform will connect to the inventory table). Does anyone
have any tips/tricks or samples for me to look at?

Brook

 

[Rick B]

Have you looked at the Northwinds sample included with Access? It is an
invoicing database and should allow you to do what you need.

Rick B


I am setting up a billing database that will connect to an
invoice table and an inventory table. What I would like is
the ability to add / modify and invoice and with a
subform, add/delete items from the invoice (which the
subform will connect to the inventory table). Does anyone
have any tips/tricks or samples for me to look at?

Brook

 

[Roger Carlson]

On my website (see sig below) are many samples for you to download.
"FormSubform.mdb" shows a simple subform. "SubformReference.mdb" show many
things about referencing objects on subforms and subsubforms. Lastly,
"ImplementingM2MRelationship.mdb" shows how to implement a Many-to-Many
relationship with a subform, which (if I understand your model correctly)
you will also need to do.

 

[Brook]

Thank you for the samples... .they have really helped me!

I do have one other question.... If the subform was items
that I want to Invoice a client for, how would I create an
invoice based on the information on the form and subform?

Brook

-----Original Message-----
On my website (see sig below) are many samples for you to download.
"FormSubform.mdb" shows a simple

subform. "SubformReference.mdb" show many

 

[Roger Carlson]

You will base the report on a query where the tables are Joined. If you use
the Report Wizard, it will allow you to choose which table the main table
and will put that information in the Header and all the detail in the detail
section.

Play around with the Report Wizard. For years I never created a report
without it. It never creates it quite like you want it, but it will give
you a good start.