replacing field contents with calculation (matching contents)
I have two databases (db1 and db2), each with two fields:
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?