Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Inventory    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Order Details Unit Price
David Kennedy 
   
11 days ago
I am a little confused when richard populates the orderdetail sub-form in the orders form. He puts a different product price in the orderdetail to the product price in the product table ie gives a discounted price. Is the discounted price stored in the orderdetail table and overwriting the existing product unit prices and then richard creates a product table later with its own product unit price field further complicating me as this is in its own table. In the orderdetails it not simpler to tie the product unit cost from order table and product unit cost from orderdetails table both to the newly created product table putting a drop list in orderdetails unit cost field referencing unit cost in products table and adding a discount field in orderdetails form to apply the unit price reduction but maintaining the actual product unit price also. Im just confused as to what is or is not bound and if bound, bound to what.
John Williams  @Reply  
     
11 days ago
David You would want a stable/base price in the Product Table, any discounts would be applied to an individual order and stored in the OrderDetail Table for each order as one person may receive a 50% discount while another 10% or no discount. The invoice for the order would reflect the prices from the OrderDetail Table.
Matt Hall  @Reply  
          
11 days ago
If I read that correctly, you may be talking about different pieces of pricing data.  The product table will have the typical, "offered-for price" or "initial price" for any of a given item.  The order detail table has the "sold-for price" or "final price" of the particular item sold, on that order.  This may include discounts, negotiation, etc.  

If you offer a type X pocket knife for $10, that is your sale price.  
--You may sell one at 10% off to Larry because he buys a lot from you.  Larry's sold-for price is $9.00.  
--You may sell one at 50% off to Curly because a blade is broken off.  Curley's sold-for price is $5.00.
--You may sell one to Moe with no discount.  Moe's sold-for price is $10.00

Your "offered-for prices" change over time, with the market.  Your "sold-for prices" don't change once the deal is done.

Does that help?
Add a Reply Upload an Image
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: 6/13/2026 6:59:17 PM. PLT: 5s