1 Reply Latest reply on Dec 9, 2011 3:04 PM by philmodjunk

    replacing field contents with calculation (matching contents)

    AdamReed

      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?