Order Details

marystewart78

Registered User.
Local time
Today, 08:39
Joined
Aug 16, 2005
Messages
30
Hi Folks,

I'm working on an order management database for a small company and have an order details form which I hoped to list each product of the order. As each customer has a different price per product I have a combo (based on a query) to choose the product and display the unit price (working fine) - the quantity and product ID are also input on the form and stored in the order details table (un-tested). My problem is on the first line of the order you choose the product and it and relevant details are shown, however, on line two, three etc when you choose the product - the other lines change to this too. How do I fix this???

Many Thanks in advance for help given!!

Mary
 
I presume you have a form/subform with the order data in the form and a continuous form for the order details. If your combo is in the main form, it will affect all the detail lines. If the combo is in the detail ine, it will apply only to that line.

Does this help?
 
Very Confused!!!

I'm new to a lot of this and just "feeling around in the dark" making changes to an access template!

I've attached a copy of my (access 2003) database - (some information removed for confidentiality purposes) - can someone take a look and point me to where i'm going wrong!

Above problem (Order Trial form) and also how do I get Product ID populated from combo to go into the Order Detail table.

Eternally grateful,

Mary
 

Attachments

OK had a quick look. I think you've gone about this the wrong way in that you've got a fair bit of code in there without having the basic design correct, run before you walk sort of situation. Is this a lift from Northwind, perhaps?

I'll have a look and get back, but I'm expected to do some work today!
 
It's not from NorthWind - it's either from Office website or Access installed templates - I can't quite remember! But I've done so many changes to it anyway! I thought it would be easier that way - guess I was wrong!! :(

All help appreciated!

Thanks,

Mary
 
I've taken a look at your database and there are a number if things I don't follow.

I gather that you have different prices for each customer for each product. Do you really what to do that? Wouldn't it be easier to have a base price and then have a discount or increment percentage apply to each customer?


What is Invoice description in your Products table?

You don't need a Paid and a paid Date field. If paidDate is null, then the order hasn't been paid.

You really should have a separate Address table. And then link to it from Orders.

You also should store the UnitPrice in OrderDetails unless you plain on maintaining a history of price changes.

You should be able to have an order form with an orderdetails subform linked on OrderID.

You also need to understand bound controls and bound forms. That's what's causing your problems.
 
Thanks for looking!

The person whom I'm doing the database for has no set way of discounting the prices so although it would be easier to do it the way you suggest it wouldn't fit in with how the company work!

Each product has a name, packaging and discription, however, this is too much information to appear on the invoice - therefore Invoice Discription is a shortened version of this information for use on the invoice.

Regarding Paid and Paid Date - point taken - I will change this - Thanks!!

Regarding a separate Address table - I assume you are refering to the Delivery Addresses - again I see where your coming from and will change this too!! Thanks!!

Re; Forms linked by Order ID - I've already got that - have I not??

I'll track down some tutorials on bound controls and bound forms and see if that helps!

All help appreciated,

Mary
 

Users who are viewing this thread

Back
Top Bottom