I submitted a question about my issue relating my work order table and schedule table.  I thought a visual might help.
Job Form  Job Table I get a Purchase Order with a list of things to complete - some are tower and some are Civil(ground) and I have an "other" category.  I have to assign each of the items (there could be 20 or more items on the list).  So I enter what type of work each one is.  Then i go to my schedule table to schedule the worker.      
JobID PO ID Service Code Service Description Unit Price UOM QTY Line Total  Work Type ScheduleID
111 57 AN03 GPS/BCCH Antenna Install 149.63 EA 1 149.63 Civil 10
112 57 AN12 Downtilt/Azimuth Change 731.5 EA 1 731.5 Tower 9
        
   I come to this Form and assign a time frame for the job and a subcontractor to the work type.        
Schedule Form        
JobID ScheduledID Scheduled Date PO ID Job Number Subcontractor ID start date end date WorkTypeID
112 9 1-May 57 IL12345 Johny Subcontractor 15-May 20-May Tower
111 10 1-May 57 IL12345 In House 10-May 17-May Civil
        
        
The problem I am having is relating these tables together so that I can give each sub a work order only for their portion of the job and then a Purchase Order with their pricing. The JobID will only come over to the Schedule Table for the first JobID.   Right now i am opening the ScheduleF from my main PurchaseOrder page so it pulls all of the job items over and puts the POID on each item.  But I cant get the JobID onto the Schedule Form and/or the ScheduleID onto the Job Form.   And then....  i am not sure if i will be able to keep everyone separate for giving out work orders and for sending Purchase Orders and paying out each part of the job properly.          

---

Reply from Alex Hedley:

You have the 'SubcontractorID' base your Reports on that, you could group them by JobID/ScheduledID etc