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)

if you delete a record -- you should delete the related child records -- or at least remove the reference!

You can do this with an Update query

Keep RI ON -- run the Update Query first on the child records, THEN DoEvents* , THEN delete the record you want

*
DoEvents is used to make VBA pay attention to what is currently happening and look to see if the OS (Operating System) has any requests.

ie: if you have a loop and want to be able to BREAK it with CTRL-BREAK, put DoEvents into the loop

DoEvents will also update values written to a form by a general procedure

A DoEvents is done when you use MsgBox, or are stepping through code (since it has to pay attention to the keyboard)

It is a good way to say, "Wake Up!"