Possible to simulate supertypes and subtypes ?

Is there a way you can simulate subtypes in SQL Server ?
In Oracle Designer, you have the possibility to make
subtypes, but in SQL Server I can't find the way you do
this...
I would like to have a situation where you can make a
record of a subtype and SQL Server automatically creates
the records of the supertype(s)
ThanksCan you explain what you mean by subtype/supertype?
If you mean can you create a parent row automatically when a row is inserted
into a child table then the answer is yes. You can do this with a trigger on
the child table.
--
David Portas
--
Please reply only to the newsgroup
--
"Koen" <nospam@.nospam.com> wrote in message
news:0a7001c34214$c363e9b0$a101280a@.phx.gbl...
> Is there a way you can simulate subtypes in SQL Server ?
> In Oracle Designer, you have the possibility to make
> subtypes, but in SQL Server I can't find the way you do
> this...
> I would like to have a situation where you can make a
> record of a subtype and SQL Server automatically creates
> the records of the supertype(s)
> Thanks|||I jsut worked with a subtype/supertype design issue but
your post isn't clear, you want to make child records that
automatically create the parent records?
Ray Higdon MCSE, MCDBA, CCNA
>--Original Message--
>Is there a way you can simulate subtypes in SQL Server ?
>In Oracle Designer, you have the possibility to make
>subtypes, but in SQL Server I can't find the way you do
>this...
>I would like to have a situation where you can make a
>record of a subtype and SQL Server automatically creates
>the records of the supertype(s)
>Thanks
>.
>