Help needed with relational database

[jksdua]

Hey, I am trying to create a database for my dad's business. He imports various products in a container every month. The database organises what has been ordered, how much and the price. It also calculates total charges of the container.

I have created all the tables needed. If you see a need to normalise the tables, let me know. I have also written descriptions in the tables so you can understand what I am trying to do.

I would like to know where should I do all the calculations. Should I create a new query and use that as the record source or perform it in the form?

Any other help would also be appreciated. I am a beginner and kinda stuck. Thanks and merry Christmas.

 

[Guus2005]

Look at the sample orders.mdb provided by Microsoft.
An order consists of Orderitems and an orderitem consists of products. In your case the products are containers, carton boxes, ...
You shouldn't make a table which describes containers but describe products.

More on normalisation: Wikipedia

HTH

 

[The_Doc_Man]

There is a general rule about where to do things...

Do things where they are needed - but minimize repetition.

So for example, if there is a computation that you need for a form and a report and as a partial contributor to some update query, you do the computation in a query and base the other items off the query rather than the original table.

On the other hand, assuming you know for an absolute and irrefutable fact that you will never ever in a bazillion years need a particular computation any place but on a report, you can put the computation in the report. Notice, of course, that this is a rather stringent rule as to frequency of occurrence. Which is why I usually hedge the bet and keep computations in queries where possible.

The exception is that you can also make a VBA module and build a public function to do a computation, then use it almost anytime, anywhere. Which also makes sense.