How do I find Error in my Database Design

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • judithtyler
    New Member
    • Oct 2011
    • 2
    #1

    How do I find Error in my Database Design

    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
    Tags: None
    • jimatqsi
      Moderator Top Contributor
      • Oct 2006
      • 1293
      #2
      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

        Comment

        • judithtyler
          New Member
          • Oct 2011
          • 2
          #3
          Thanks, information beside box charge is #Name?

            Comment

            • jimatqsi
              Moderator Top Contributor
              • Oct 2006
              • 1293
              #4
              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.

                Comment

                • NeoPa
                  Recognized Expert Moderator MVP
                  • Oct 2006
                  • 32663
                  #5
                  @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.

                    Comment

                    Previous template Next
                    Working...