How do I find Error in my Database Design

[judithtyler]

I have a database we use for our plant business. It is set up so when I enter orders and add in freight and box charge. I need to change the box charge price. I have figured out how to change the number of the box charge (from $2.50 to $4.25) but when the data comes up on the invoice the only the old 2.50 charge is added into the total not the whole 4.25. There must be some other place I change or something I need to do, but I can't find it.
Thanks,
Judith

[jimatqsi]

Judith,
There's a bunch of things that could be wrong to cause this. It could be that maybe the form where you changed the amount (the order entry screen, most likely) shows the new amount but does not save the new amount. Or maybe the new amount is saved but is not picked up by the report/invoice print.

The first thing I would do is go into the table where the order/invoices are stored and find the newest record. Look at the amount for the box charge to see what is stored there. Then we'll go from there.

Jim

[judithtyler]

Thanks, information beside box charge is #Name?

[jimatqsi]

Hmmm, that's not very helpful, I'm not sure what information you are trying to give me. Do you know the names of the various tables (files) in your database? There should be a table for orders - maybe it is the same table as invoices are stored in. We need to take a look in the orders table.

If it is not very large it is possible to attach a copy of your db to your next post so I could take a look at it. If it's very large I'd have to connect to your system with remote desktop.

[NeoPa]

@Judith
There is something (possibly many more than one thing) very wrong with the design of your database. Unfortunately you tell us next to nothing about said design so helping you at this time is not practicable (We cold make some guesses but that's not a good approach).

You need to start by passing us the type of information that may help us to see what you've done wrong. At the moment your question is of the form - I have a problem. What is the solution? Less than helpful.

Give us something to work with and we'll do what we can for you.