I want to update a price field in database B whenever new data is entered or recalculated in the price field of database A.
Can this be automatic? Database B has a lookup function in its formula which calculates when I recalculate the field. I tried adding a procedure to recalculate the field which works when I run it in database B.
When I farcall it from the database A Price fields code section, I get the error that the field in Database B doesn’t exist in database A.
What’s the simplest way to set this up?