Hello all,

I have a table called membersand another table called settings. Every time I add a new user to members is it possible to have the ID of that user added, be added to the settings table automatically?

I am hoping there is something equivalent to the "ON DELETE" and "ON UPDATE", is there a "ON INSERT"! (it seems fanicful)

Thanks all

no, there isn't

this sounds like a one-to-one relationship -- any reason why you couldn't combine the tables? at least then you wouldn't be asking this question

:P lol - Actually there is no reason not to combine them. I really have problems with db design. I like breaking things up even if they have one-to-one relationship!

Thanks for getting me to see the light r937