I need advice for a Shipping and Invoice database I have created. I have tables for the shipping data, vendors, location, Purchase Orders, etc. Then it all comes together by date range (they do invoices once a week)and location/vendor in a Invoice I created in Reports.
The problem I am having now is that we need to auto generate an Invoice number for this group of records that will be put back into a table for future reference. How can I do this since the report is not actually linked together except by date range?
Thanks in advance for any help!
The problem I am having now is that we need to auto generate an Invoice number for this group of records that will be put back into a table for future reference. How can I do this since the report is not actually linked together except by date range?
Thanks in advance for any help!