creating list

[kingsgambit]

I have been asked to build a database to cost up a building job.
i.e number of windows, doors, area of plot.
Does anybody have any ideas on how to build this, I wanted to user to select each item from a combo box and then I would get added to a list the list then would create a report

 

[Parker]

Hi

While MS templates are not good they do work as an axample of haw to do things.

I would take a look at thier orders template. I learnt a lot from looking at this also take a look at the northwind db this has many examples of the sort off opperations you will need.

Think about the table structure of your db and then read up on normalization before you start. It's easier to get this right from the start than to go back and try and sort it out later.

Remember the primary function of a db is to store information --- once you have that sorted along with a means to input that info,then you can work on retrieval and calculations.

So first you need to decide on the information that you need to store then work it into tables of associated information ---- If you need to store the same information in more than one table then look again, if you have the information once then you don't need to store the same information elsewhere.

Hope this helps

Pete