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?
db1:book id = db2:book id
Is a boolean expression. It evaluates to either true (number value 1) if the book id values are equal or to false (number value 0) if they are not equal.
If db1 is the table without the ID numbers, Use db2::book id as your expression.
If db2 is the table without the ID numbers, use db1::book id as your expression.