zookeeperbobbie
Board Regular
- Joined
- Feb 9, 2005
- Messages
- 117
Hello- I need some help/advice with a subform that I am trying to create.
I have a main form already that has subforms with product information specific to the customer selected.There is a main tab with the customer information such as address, contact info etc. The next tab pulls from a product information table and is specific to the customer. I would like to create another subform that will list each job and the total records for that job that was for the customer selected. Each customer may have several jobs and within that job there are batches. Within those batches there are ther following columns. Total records, duplicates, rejects, redemptions, and amount of rebate. I need to be able to have a count of each of these columns per job.
I knwo this sounds difficult without screenshots, but i have seen somthing similar done before but can not remember where. If you would like the database or screenshots please let me know.. Thanks!
Thanks~!
I have a main form already that has subforms with product information specific to the customer selected.There is a main tab with the customer information such as address, contact info etc. The next tab pulls from a product information table and is specific to the customer. I would like to create another subform that will list each job and the total records for that job that was for the customer selected. Each customer may have several jobs and within that job there are batches. Within those batches there are ther following columns. Total records, duplicates, rejects, redemptions, and amount of rebate. I need to be able to have a count of each of these columns per job.
I knwo this sounds difficult without screenshots, but i have seen somthing similar done before but can not remember where. If you would like the database or screenshots please let me know.. Thanks!
Thanks~!