Populate

[abandres]

Hello guys,

I am new using SMO and I have a problem writting two related records in diferents tables:

Table1:
Field-A_id.
Field-B
Field-C
Field-D
Field-E
Field-F
Field-G
Field-H


Table2
Field-A_id
Field-B
Field-C
Field-X

Field-X1
Field-X2
Field-X3

I have a sviewer related to a sdo for the first table (table1) when the user adds or update a record I need to create the record for Table2 with the same Field-A_id (primary key for both tables).

My question is how can I populate the fields in Table2 (and create the record) with Table1 fields (Field-A_id , Field-B and Field-C).

how is the best way to do this.

 

[fuehrera]

Foreign Fields

Hi,
try Foreign Fields.
one Question: why do you need some fields with the same values in TWO tables ????
I think, that it is only necesarry for sorting purposes - but otherwise not good doing.
greetings andi