AnsweredAssumed Answered

replacing field contents with calculation (matching contents)

Question asked by AdamReed on Dec 9, 2011
Latest reply on Dec 9, 2011 by philmodjunk

Title

replacing field contents with calculation (matching contents)

Post

I have two databases (db1 and db2), each with two fields:

Book Title

Book ID

The titles match in both databases, but one is missing the ids.  I've made a relationship between the databases (title = title), and then have tried to replace field contents with a calculated result db1:book id = db2:book id.

All I seem to get are all zeros or all ones (depending on changing things around a bit).  Any ideas?

Outcomes