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 Charlie, I have printed and read a lot of the things you have listed there allready. I shall be looking through the GP stuff in next day or two.

I have today printed out my relationships, and had it on desk all day, It is amazing how much more you can tak ein by doing this! I found some problems corrected them and shal go back tommorrow reprint and got though it all again.

A question RE referential Integrity. I have a company table that has links to collections then to collection items then to inventory. now if I turn on RI, and wish to delete a company I get errors, unless I turn on cascade delete and the whole thing drops like a deck of cards. Lovely just as you would wont in certain circumstances. But I wil probelly wont to delete a company but leave the collections and inventory info intact. The only way I can see of doing this is not use RI. Now is there something here Im missing on the 3 forms? OR is this just the way it is, and sometimes RI is not the answer?

Thx again

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