L
Lapchien
I'd like to update some of the fields in a table 'master', where some of the
data in a row already exists. For example, I'd like to add to a record in
the 'master' table -
The value of an order
The number of the engineer who carried out the work
The date the job was completed
Fields for these values already exist.
All these 'additional' records exist in another table called 'update'.
Obviously these things are not known when the original record is created in
the 'master' table.
Looked everywhere for an answer but not quite there...
Thanks
data in a row already exists. For example, I'd like to add to a record in
the 'master' table -
The value of an order
The number of the engineer who carried out the work
The date the job was completed
Fields for these values already exist.
All these 'additional' records exist in another table called 'update'.
Obviously these things are not known when the original record is created in
the 'master' table.
Looked everywhere for an answer but not quite there...
Thanks