I need insert the sama value in two tables, how?

Karvalho

I everybody,

I have two tables table1 and table2, and when I insert a value in field field1 in table1 I want that value was automaticly inserted in field10in table2.

I think that's possibly but I don't know how do that. Somoene can help me?

Obs.: table1.field1 is primarykey and table2.field10 isn´t, that's metter?

Thank's in advance.

AC <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />

Stefan_Limpert

Hi,
you have many options to realize it.
1. Use a Flowfield.
If you classify Field 10 in Table2 as Flowfield, the Value is automatically the same.
2. Use the Triggers.
Field1 in Table is PrimaryKey, so use the RENAME or INSERT Triggers of the Table do modify the value in Field10.
Example:
INSERT TRIGGER
Table2.GET(...);
Table2.Field10 := Field1;
Table2.Modify;
Good Luck
Stefan
<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote