Mike Krailo
Well-known member
- Local time
- Yesterday, 20:09
- Joined
- Mar 28, 2020
- Messages
- 1,044
Have a client that has three different tax categories on his PO subform. The original problem was just getting the Vendor and ShipTo addresses to print out on the POReport. That's working now but I had to switch from text to number type for both of those fields to get it to work. If there is a way to preserve the text fields for Vendor and ShipTo addresses I would like to know how to do that. The larger issue is getting the proper tax category total to print out on the POReport.
I will attach a demo database and if someone can look at it, that would be great. I was thinking a temp table or using TempVars to store the final calculated tax and fill in the text box on the POReport.
When the database is opened, you select a customer. Then click OPEN JOB to go to the JobForm2. There will be a continuous view of items (in a subform). Each item has a PO button to launch the Purchase Order report.
I can't seem to get the file size down to a reasonable size. I'll try again later.
I will attach a demo database and if someone can look at it, that would be great. I was thinking a temp table or using TempVars to store the final calculated tax and fill in the text box on the POReport.
When the database is opened, you select a customer. Then click OPEN JOB to go to the JobForm2. There will be a continuous view of items (in a subform). Each item has a PO button to launch the Purchase Order report.
I can't seem to get the file size down to a reasonable size. I'll try again later.