4 hours ago: Our file storage provider is running maintenance today. If any videos don't load, wait a minute, refresh the page, and try again. Sorry for any inconvenience.  Dismiss
Computer Learning Zone CLZ Access Excel Word Windows

All things good to know are difficult to learn.

-Greek Proverb
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Seminars > Work Order > Lessons
Back to Work Order Lessons    Comments List
Purchase Order Upload Images   Link   Email  
Shallena Ayers 
7 years ago
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

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Work Order Lessons.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/14/2024 10:02:21 AM. PLT: 1s