Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Forums > Developers
Back to Access Developer Forum    Comments List
Combining Data from 2 tables Upload Images   Link   Email  
Jerry Addleston       
2 months ago
I have a program which manages service and sales.  I'd like to show in a single form, the combined sales info from my service detail table and my sales detail table linked by a produceID.  For example, if I look up an item from inventory, I'd like to be able to see all the sales of that item. Sometimes they are from sales orders and sometimes they are from service orders.
Kevin Robertson            
2 months ago
Thomas Gonder       
2 months ago
I realize you might not be able to answer this if you didn't develop the db, or if you inherited it. I'm curious why you have a different order system for service and sales. What is in the service order that couldn't be handled as a regular sales order? In all the systems I've worked in, some service is just another "item" being sold.
Jerry Addleston       
2 months ago
Hi Thomas,
In my program, service came first, and the service order form links all services to a piece of equipment, which has many additional links along with mandatory entries.  In addition, I track labor as an entity of the Service Order and not another line item in the detail sub form. While it would be possible to combine into a single form, this just seemed more logical to me.  I did consider it, but ultimately thought this would be less work than having to deal with all the relationships and code that would need to be modified to accept an order without a customer's piece of equipment, labor, contracts and several other linked tables.  The suggestion of the Union Query worked perfectly, Thanks for that, Kevin
Thomas Gonder       
2 months ago
@ Jerry A. Thanks for your answer. I guess the service order coming first sort of muddied the waters. I've usually seen a work order document/system handle the preliminary data gathering process for service. And then the work order is added to the sales order as an optional field. It would be a process flow, kind of like a bid request>bid response>purchase order>shipping confirmation>warehouse receipt>invoice>voucher>payment for purchasing and accounts payable.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.


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: 4/15/2024 7:23:09 AM. PLT: 1s