MarcieFess
Registered User.
- Local time
- Today, 09:41
- Joined
- Oct 25, 2012
- Messages
- 107
Hi.
I'm almost finished with my big project! At least, the big stuff! I'm creating the menus now, soon will be modifying the back-end data tables to match the changes I've made in my test bed, and securing it all, finishing the user manual and conducting some training.
My question at this point: we have PDF sheets with supporting information; one of each of them must be printed along with all the other reports. Not every PDF sheet is going to be for a product in a particular store, though. In one of my tables, I have a field that links to the PDF for each product.
I believe the code is going to be
SELECT Distinct MSDS
FROM Product;
So that part is easy.
My question is...can I even do this? I thought at first that I would just have to create an empty report with this code but I realize that's just the beginning. This report needs no formatting or anything. I just need the vehicle to print one, and only one, copy of each PDF (some of the PDFS attach to a couple of hundred products...only need 1 copy of each one, not hundreds - hence the Distince MSDS in the code above), but only the PDFS that apply to that particular store.
Is there a better way to do this?
I'm almost finished with my big project! At least, the big stuff! I'm creating the menus now, soon will be modifying the back-end data tables to match the changes I've made in my test bed, and securing it all, finishing the user manual and conducting some training.
My question at this point: we have PDF sheets with supporting information; one of each of them must be printed along with all the other reports. Not every PDF sheet is going to be for a product in a particular store, though. In one of my tables, I have a field that links to the PDF for each product.
I believe the code is going to be
SELECT Distinct MSDS
FROM Product;
So that part is easy.
My question is...can I even do this? I thought at first that I would just have to create an empty report with this code but I realize that's just the beginning. This report needs no formatting or anything. I just need the vehicle to print one, and only one, copy of each PDF (some of the PDFS attach to a couple of hundred products...only need 1 copy of each one, not hundreds - hence the Distince MSDS in the code above), but only the PDFS that apply to that particular store.
Is there a better way to do this?
