I have a field that needs to be updated\set in Table.B from same field from Table.A. This needs to be done with the following conditions.
I will write in kind of a pseudo code format:
Table.B.DOCO = Table.A.DOCO
Table.B.REF = "6F"
Table.B.DATE = '09/14/2010'
Table.A.Line = '1'
If the above finds records the Table.B.REF will need to be populated with Table.A.REF