Computer Learning Zone CLZ Access Excel Word Windows

Groovy!

-Ash Williams
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Visitor Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Order Entry System
George Jakes 

2 years ago
I've gone through the various videos a few times, trying to get a handle on the structure of things. And this last time I took notes of what I was doing along the way. So I feel more organized. But when I got to the inventory part of it, after building the template, creating the CRM, setting up invoicing, setting up the ordert, orderdetailT, orderdetailQ, OrderdetailF, using the IIF funct, using conditional formatting, etc.. I realized that the order system i have in place wasn't working. When new orders are created, where are the details being entered? It would seem that the details entered go into the order detailsT via the orderdetailsQ. But it's the ordersT that's opened up to look for orders for a client, not the orderdetailsT. Here's how I have things: OrderF is based on orderT. That's matched up with OrderDetailF, via the customerID field. The orderdetailF is based on the orderdetailQ, which is connected to the OrderDetailT. And when order info is entered into the orderdetailsF (subform of ordersF) the info goes into orderdetailsT, not the ordersT (which is the table queried for orders for a client). What am I getting wrong here?
Joe Holland  @Reply  
       
2 years ago
Order details are related to each order and each order is related to a customer.
Sami Shamma  @Reply  
             
2 years ago
In this video, Richard builds a simple invoicing Database. It should clear things for you.

TechHelp Free Templates
George Jakes OP  @Reply  

2 years ago
Thank you both for your help. I ended up getting it working not too long after submitting the question. What I did was two things. First, I made a paralell between what was working and what was not working. So I made a paralell between the contact system and the order system. That gave me a better understanding of the structure. And then I included customerid into the order detailQ and orderdetailT. I then put it in the orderdetailF as hidden, and made it's default value to be: =[Forms]![CustomerF]![CustomerID]
Joe Holland  @Reply  
       
2 years ago
CustomerID is usually just linked in the OrderT. OrderT then uses OrderID to link to all the OrderDetailT records using a foreign OrderID. Then you can easily bring CustomerT, OrderT and OrderDetailT all together in a query. You should watch the video Sami suggested to get a better understanding of how it all relates.
George Jakes OP  @Reply  

2 years ago
Thank you Joe. I'll use that info to find out what I did wrong. And, Sami, which video is it that you're referring to? When I click in the link within your post I just see a page for templates:

TechHelp Free Templates
By Richard Rost   Richard Rost on LinkedIn Email Richard Rost   3 years ago
Current Versions of Templates for TechHelp

*****************************
Thank you
George Jakes OP  @Reply  

2 years ago
Hi Joe, I get what you're saying about the CustomerID ->OrderT->OrderDetailT. But my question is how does the ContactT fit into this? Would that just be another relationship independent of the customerID-OrderT?
Joe Holland  @Reply  
       
2 years ago
Everything in the OrderDetailT can be related to the CustomerT through the OrderT. It may help you to watch the Relationships Video: https://599cd.com/blog/display-article.asp?ID=1724
Joe Holland  @Reply  
       
2 years ago

Joe Holland  @Reply  
       
2 years ago
I built my database 28 years ago, so the names of my tables do not follow Richard's recommendations. Certainly, name them as Richard says. It will make your life easier as you move on in programming.
Joe Holland  @Reply  
       
2 years ago

Joe Holland  @Reply  
       
2 years ago

Joe Holland  @Reply  
       
2 years ago
I posted a simple query bringing together the customer, order, and order detail info. The image after that is the datasheet showing the query results. I hope this helps.

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

Next Unseen

 
New Feature: Comment Live View
 
 

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 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/30/2026 7:09:13 AM. PLT: 1s