I’ve created two databases. (1) RMD dd test and (2) RMD client test.
Each has only ONE field: “RMD”
I’ve gone to: File > Database Options > Relations (tab) > and clicked matching fields “RMD” in both current database (RMD dd test) and source (RMD client test) and the “key” icon appears on both sides.
At the top of Relations menu it says “Join” “RMD dd test” with data from
“RMD client test”.
I want to replace Existing Data in current database. I’ve read through the instructions in “Specifying Data Transfer Connections” several times.
I’ve tried dragging the source field over to current.
When I double click Source to “Select formula for <> in database - > RMD test” the formula that pops up is simply “RMD”.
Should I edit this formula that pops up? If so, what do I edit it with? I should not use “yolk” as that appends rather than replaces and I wish to replace. Both field in current and source are “floating”.
The manual states: “For most relations you don’t need to set up data transfer for key fields.”
The following procedure in the current database does not populate the field “RMD” in the current database with the data in the source: join “RMD client test”
“Replace Existing Data” is checked in the Relations window.
All I want to do is populate all the data in the RMD field in the current database with all the data in the source.
Help anyone? Thanks