aussieolie
Australian
- Local time
- Today, 04:30
- Joined
- Apr 3, 2002
- Messages
- 47
I have this major head ache with this problem.
What I am trying to do is make automatic invoices from a query. What I want to happen is when my stock gets below a level a invoice is created.
So far I have got a query to get all the records that are under there stock level. (this is all working so far) This query then needs to create a report with fields from two seperate tables, (the inventory and purchase order tables) then a report needs to be created, and I have worked out how to seperate each indivdual invoice using the page breaks. The problem is trying to get the query to make the report from two tables, which have two autonumbers (i need both ID's) but only the table purchase order ID needs to be automatic (created at the same time the report is), so every time i have a new invoice a new ID is created. The method I am using is a make table query and that will make a report. Please suggest how I should go about this, I am only a begineer really at MS Access.
Thanks for your help,
Olie
What I am trying to do is make automatic invoices from a query. What I want to happen is when my stock gets below a level a invoice is created.
So far I have got a query to get all the records that are under there stock level. (this is all working so far) This query then needs to create a report with fields from two seperate tables, (the inventory and purchase order tables) then a report needs to be created, and I have worked out how to seperate each indivdual invoice using the page breaks. The problem is trying to get the query to make the report from two tables, which have two autonumbers (i need both ID's) but only the table purchase order ID needs to be automatic (created at the same time the report is), so every time i have a new invoice a new ID is created. The method I am using is a make table query and that will make a report. Please suggest how I should go about this, I am only a begineer really at MS Access.
Thanks for your help,
Olie
