Hi UA,

heeeelllllppp!!

Im working on a databse for funded/charity based company that I work for

The company collect and recycle IT waste.

We need a system that will allow us to have one company/many address(collection address 1,2 and 3 etc billing, mail etc) each address needs many contacts, each contact has many phones and emails. I have this set up and working no prob. I have a form that allows me to enter and retrive data just as I have said. The problem is I need to intregrate all of the possible company/address combos in a collection form, based on a collection table. This table/form should store Company collected from, company address used (from the list of possible endless collection address each company may have) then contact name info.

I have attatched a screeny of my relationships so far. If u c any major probs please let me know.

many thanks UA.

si (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)

thx crystal,

A wealth of info indeed, and more of it is sinking in having read it a good few times!

Ive found a number of redudant fields, and have also changed some field names. I have also now turned RI on for all relationships! I am also going to add a price history table as due the nature of our business prices to customers change very often.

Once Ive got to a stage where I feel I am nearer my goal of normalization I shall Repost my relationship screen, hopefully you wont mind having another look then.

BTW I have read some books, but most are very lite on normalization can u recommend any?

thx again

si (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)