W
Wayne
I have a billing database that also creates invoice reports. 95% of
the time it runs smoothly. I enter data into the subform and an
invoice is created from the combination of the Main and Subform data
filling about one page. About 1 or 2 times a year I have to create a
one-off invoice for multiple clients. This one-off invoice requires
much more data than my Main/subform can provide so I end up creating
the 100+ row invoice in Excel and exporting it to my Billing db. I
then have a special program that reads in the one-off custom data and
creates the custom report invoice. All the custom invoices have the
same basic fields – Description and Amount fields. This works fine
but I would like to store this custom invoice data and link it to the
correct client. I would have to greatly expand my current subform to
accommodate these one-ff invoices which makes no sense. I thought
about creating a custom button on the subform that links to the custom
table but after awhile I may have many custom tables. Is there a
better way to design my Main/Subform tables and forms to accommodate
these one-off invoices? Any help would be appreciated.
the time it runs smoothly. I enter data into the subform and an
invoice is created from the combination of the Main and Subform data
filling about one page. About 1 or 2 times a year I have to create a
one-off invoice for multiple clients. This one-off invoice requires
much more data than my Main/subform can provide so I end up creating
the 100+ row invoice in Excel and exporting it to my Billing db. I
then have a special program that reads in the one-off custom data and
creates the custom report invoice. All the custom invoices have the
same basic fields – Description and Amount fields. This works fine
but I would like to store this custom invoice data and link it to the
correct client. I would have to greatly expand my current subform to
accommodate these one-ff invoices which makes no sense. I thought
about creating a custom button on the subform that links to the custom
table but after awhile I may have many custom tables. Is there a
better way to design my Main/Subform tables and forms to accommodate
these one-off invoices? Any help would be appreciated.