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)

Hi si

Crystal's treatise on normalization is a masterpiece. As far as books , I do not know of any that have been suggested here dedicated to the topic. GroverParkGeorge's book does dedicate more than most to the subject. However this link Normalization Links will lead you to an enormous collection of references. Granted some links are redundant, ironically,lol. If you want more or want to see what is in the broken links in my threads, let me know.
Enjoy
HTH

Charlie