Hello,
I've imported an image of a paper form we use in our office. It has five sections that represents assets an employee may have. If an employee has many assets, I want them to be listed on the same report.
I've put textboxes in the appropriate location over the image: txtIDCard, txtProxCard, txtLaptopID, etc...
An employee has an ID number, EmpID that is associated to each asset in the table tblAssets (ID[pk], AssetTypeID, EmpID) and the asset is described in tblAssetType (ID[pk], AssetDescription).
An example of tblAssets:
ID AssetTypeID EmpID 1 1 sk1 2 2 sk1 3 3 sk1
An example of tblAssetType:
ID AssetDescription 1 Laptop 2 Prox Card 3 ID Card
In the report, I want one page per employee that will populate the appropriate text box. So far, all I've got is that the report should be grouped by EmpID, but after that I'm not sure where to evaluate the asset and place it in the appropriate box. I only have one detail section that shows the image of the document I want to print.
I'm not 100% sure what event to put the code in.
Thanks for any help and I hope that makes sense!
Scott