newB question: related tables question

[Blue man]

hello
i have a data base with 10 tables, i want to automaticaly creat a row in all
of the tables wehen i create in the first one.
normal table relation didn't work for me , so what are they? what is these
relations functionality? i have creted relation between my tables, but when
i add a row nothing happems to other tables.
shall i user stored procedures for this?
thanks in advance

[oj]

You could create a trigger on the primary table and then propagate to all
the secondary tables. You could also use DRI for this if you are on sql2k.

[url]http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_7eeq.asp?frame=true[/url]
[url]http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_8g9x.asp?frame=true[/url]

--
-oj
RAC v2.2 & QALite!
[url]http://www.rac4sql.net[/url]



"Blue man" <famebluerain@yahoo.co.uk> wrote in message
news:uJY7JprPDHA.2476@TK2MSFTNGP10.phx.gbl...

> hello
> i have a data base with 10 tables, i want to automaticaly creat a row in

all

> of the tables wehen i create in the first one.
> normal table relation didn't work for me , so what are they? what is these
> relations functionality? i have creted relation between my tables, but

when

> i add a row nothing happems to other tables.
> shall i user stored procedures for this?
> thanks in advance
>
>