[bladecs2002]

Hi,
I have started may own bussines some time ago...
Since then I have been able to make a Access database in wich I introduce my custumers...
1st question:
My company sells energy so what I cant figure out how to link the custumers table to another table that stores the information about monthly energy consumption for each custumer.
Here are the column that I think I need...
CustumerID SerialNumber(for the energy counter) Energy ... and I realy dont know how should I cont each month energy consumpltion. I need to store each month because I need to make a "consumers profile" every year...

If you can help me, guys, I would apreciate very much an maybe I can contribute too.

P.S. I wrote SQL server because in the future I hope the database I make now will help me create one in SQL server with a front end and all...

[OBP]

bladecs, welcome to the Forum.
Can you post a Printscreen copy of your table Relationships please, or better still a zipped Copy of the database in Access 2000-2003 format. Just ensure that there is no Personal Data in the tables.
Perhaps you would like to read this article I wrote on Tables and Relationships and attached here
http://forums.techguy.org/tech-tips-...se-basics.html

[bladecs2002]

The database is not in english... and is not normalized...
I am working to normalize it. In the end it will have about 10 related tables.
The thing that is bugging me it that I have no idea how i should do the monthly energy consumption. That table is called Consum.

[OBP]

It is a simple enough error, you have used the Client_ID as the key field for the Consum Table, wheras it should have it's own Key field which I have called ConsumID.
I have set the Relationship as a One (Customer) to Many (Consum) so that you can have as many Consum readings as you like.
I think that you should also have a Reading Date Or Reading Month field in the Consum table.

[bladecs2002]

Thank you for your answer, OBP!
As I am normalizing the tables, i'll do as you say and make a column for the date of the reading.
I'll post the DB to show the result as I finish the tables.
I can't think of all the things I have to take into account at once but as i progress I'll probabaly have more questions.
BTW, thanks for the article, it was helpfull

[OBP]

Just let me know if you need any more help.