UPDATE TableB Thru TableA

  • Thread starter Thread starter Diem Dang
  • Start date Start date
D

Diem Dang

Hello,

I have a db in MS Access 2002 with 2 tables: TableA &
TableB. Both tables have the same number of fields &
datatypes & UID. I would like to use the UPDATE SQL
statement to update the existing records in TableB
whenever the existing records in TableA are updated WHERE
TableA.Branch=TableB.Branch AND TableA.UID=TableB.UID.

I appreciate in advance for your time and effort.

V/r,

Diem
 
I have a db in MS Access 2002 with 2 tables: TableA &
TableB. Both tables have the same number of fields &
datatypes & UID.
Click to expand...

Why? Surely they ought to be the same table then...
I would like to use the UPDATE SQL
statement to update the existing records in TableB
whenever the existing records in TableA are updated WHERE
TableA.Branch=TableB.Branch AND TableA.UID=TableB.UID.
Click to expand...

Sorry, this just does not make sense: there is no reason to be keeping the
same stuff in two tables at the same time. That is why there is no
mechanism for doing it.

I suggest you read some basic texts on database design and relational
theory: this will explain why what you are suggesting is a Bad Idea.

Best wishes


Tim F
 
Back
Top