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)

aha !!!! all becomes clear

thx for that crystal will use this is a number of similar situations. Allthough is this not breaking norm rules? If so at what point would you consider this OK?

As for the tbl name yep im gonna change that tblcompanycontact !!!! lol

thx for youre patience on this one! It is appreciated. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)


best regards


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