Help needed with a subform

[zookeeperbobbie]

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~!

 

[zookeeperbobbie]

Does no one have any ideas how I can achieve this?

 

[SydneyGeek]

If I read this correctly, you have a Jobs table and a Customers table. These are related many-to-many, and you want to see all jobs for any customer -- or all customers for any job. Is that correct?

If so, you need a CustomerJobs join table with CustomerID and JobID fields, linked into the other 2 tables.

Create a subform frmo this table and drag its icon onto Customers in Design view. Access should link the two up for you, using CustomerID as the link field: you can check by going to the Properties of the subform, and looking in the Data tab at the Master and Child fields.

Entries in the subform will automatically link to the customer whose record is displayed on the main form.

Denis