Help needed with a subform

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

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,057
Messages
5,599,550
Members
414,316
Latest member
ExcelLee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top