RE: Generating Schemas from one parent table and 2 child table


Hi, are you talking about the SQL Adapter with updategrams? You need to use
at-identity to copy the parent id to the child/children. Have a look at the
"Insert New Order" section of this page:
http://technet.microsoft.com/en-us/library/ms935658.aspx
Or here for another example:
http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx

These examples have only one child table but you can repeat it for two if
the parent is the same, let us know how it goes.
Also, if you weren't talking about the SQL Adapter with updategram please
give us a bit more info.

Thiago Almeida
http://connectedthoughts.wordpress.com

"babu.dhinakar@xxxxxxxxx" wrote:

I am trying to generate schemas using ADD generated items wizard. I
need a query to generate a schema which contains one parent and 2
child from 3 different table. They have PK and GK relation between
them. I tried writing query using joins and was not successfull.

.

Loading