Hi Adam,

It seems like a strange requirement, that information contained solely

> in TableA is enough to correctly populate TableB. Are you sure TableB
> should not simply be a view?
>

My exact scenario is:
Table A (contains income money transactions)
FIeldID Field1 Field2 Field3

Table B (contain contability, income money transactions + others income
money transactions - outcome money transactions)
FieldID Field1 Field3 FieldID_TableA
Field1 and Field3 of Table B store the same kind of data of the same field
of table A
Field1_TableA need to me to mantain a link to data of Table A

So, what do you think is the best and correct solution for that scenario ?

Thanks
Adriano


[Non-text portions of this message have been removed]