Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
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.
 

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

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/15/2024 7:23:09 AM. PLT: 1s
xxx