Automatic update

  • Thread starter Syed Zeeshan Haider
  • Start date
S

Syed Zeeshan Haider

Hello Everybody,
I am trying to share same column in two different tables in a way that if I
update one column, second column updates itself automatically. What would be
the best way to do so?

Thank you,
 
S

storrboy

Hello,
A relationship that enforces integrity, plus a query or some other
data input method that adds new records to both tables at the same
time. Or at least in the proper order to satisfy the relationship. If
the two records are actually not related, then duplicating this info
in this fashion may not really the best way to design your tables.
 
Top