Create another key field by calculation:
AcctFromOrTo = acct FROm & "<insert Pilcrow, return character here>" & acct TO
and use that to relate to.
Sorbsbuster, that worked perfectly!
This solution worked well but now when I create a Layout which shows the AcctTo field it just shows the key number and not the AcctName. How do I get the name to show?
We'd need to know how your database is designed to answer that.
The following is a guess:
Is the AcctName field a field from a related table? Perhaps AcctTo is formatted as a pop up menu in it's original layout so that its value list enters the key number, but displays the name? If there is a valid relationship based on this field to the table where you have the name, just include the name field from that related table on your layout.
An easy way is to create the account name in the same table as you are dragging the AcctTo field from. Just make it = AccountName by the realationship it has back to the Accounts Table or wherever the name is stored.