Search results

  1. S

    Update a table with a value field in ANOTHER table, but selecting unique value

    Hi, I have two tables (MatMast and ChangeLog) in an Access Database, where the common key is MatCode. The tables look like this: MatMast MatCode (PK), CurrentStatus 10001, ACTIVE 10002, INACTIVE 10003, ACTIVE ChangeLog ChangeInstance (PK), MatCode, Status, TimeStamp 25452, 10001, ACTIVE...
Back
Top Bottom