Hello,
This one I think should be easy when you now how but I couldn't get it
today.
I have to run a kind of double check routine.
1 database, 2 tables. No linking or referential integrity or any of that.
TableA has 2 fields that matter - [CoilNumber] [MaterialType].... [and
others]
TableB is exactly the same - [CoilNumber] [MaterialType].... [and
others]
In TableA both fields have values
In TableB only [CoilNumber] has a value.
I need two things to happen here, and here is the kind of pseudo code I'm
working from to try and explain it.
UPDATE
TableB[MaterialType] = TableA[MaterialType]
WHERE
TableB[MaterialType] = "" AND TableB[CoilNumber] =
TableA[CoilNumber]
Stage 1: Make the two tables the same
Stage 2: If the the field in TableB already has a value then pass up the
value and throw an error
Don't worry about why it is this way, and the talk about data duplication
etc. I'm just doing what I'm told.
Any help appreciated.
Ray.