I am new to Access and have been creating a databse for a few weeks. Your forum has been an endless supply of help for the novice.
I have managed to achieve everything so far and now I've hit a stumbling block.
I am creating a Purchase Order database. I have a table which I fill in and this table contains a sub table of the item details, quantity and price. After enetering all the data required I want to print the order.
I have created a reprot and using the Dlookup function I have got all the supplier, references and addresses ect on the report based on the data from the order form.
The problem I have is that when I enter the item descrition, quantity and price in the detail section of the report, it is entering the data for every single order. I want to filter it so that it only enters the data for the particular order that the report header has successfully done.
I have set my form / tables up so I have one order ID. Each item of the order then gets an individual detail ID which links to the Order ID... thus one order ID could have many detail ID's
The report header prints details or the required order ID but the reprot detail is printing every orde detail ID and I can't filter it to print based on the order ID.
Hope this makes sense.
Thanks
Steve
I have managed to achieve everything so far and now I've hit a stumbling block.
I am creating a Purchase Order database. I have a table which I fill in and this table contains a sub table of the item details, quantity and price. After enetering all the data required I want to print the order.
I have created a reprot and using the Dlookup function I have got all the supplier, references and addresses ect on the report based on the data from the order form.
The problem I have is that when I enter the item descrition, quantity and price in the detail section of the report, it is entering the data for every single order. I want to filter it so that it only enters the data for the particular order that the report header has successfully done.
I have set my form / tables up so I have one order ID. Each item of the order then gets an individual detail ID which links to the Order ID... thus one order ID could have many detail ID's
The report header prints details or the required order ID but the reprot detail is printing every orde detail ID and I can't filter it to print based on the order ID.
Hope this makes sense.
Thanks
Steve