I want to create 3 tables. One with the customers purchase order, another one with the job or jobs associated with the purchase order. Another table with exceptions/issues related to each job. FIrst, I want to be able to show my customer their PO list. Included in list, I want to show a count of how many jobs are associated with PO. For example, PO # 12345 can have JOB1, JOB2 and JOB3. The customer will only see the number 3 and if you click on it, it would take you to another report listing the individual jobs. Same thing for exceptions. Each job may have multiple issues, for example "MISSING PRODUCT", "WRONG SIZES", etc. I want the customer to look at the job, see an exception count and be able to click on it to see a detail table. Help! BTW, I understand the concept of building table relationships. What I need are the actual steps/code to take it happen.
"here I click on number 3 and see the following report:
Here, I click on number 2 for JOB1