Picking matching fields in relationships

[jimb51]

I have 3 files: ACCOUNTS,DEBTORS,MERCHANTS. Each file has an auto generated serial number assigned (Debtors#, Merchant#, Account#). ACCOUNTS has many Debtors and many Merchants. To establish an efficient link between files, I thought to create Debtor_ID and Merchant_ID fields in ACCOUNTS and establish relationships on these. The general process is to create Debtors and Merchants then create Accounts. My problem is finding an automatic way to add the Debtor# to an Account when I add the Debtor name using a drop-down list. (Same for Merchant).

I had a similar problem with a 4th file named PAYMENTS in trying to automatically add Account# to each payment entry. I solved that by entering payments via a portal in Accounts. THAT took me awhile to figure out but it works well so far.

Any ideas?

 

[Schlogg]

This is a generalised approach.
FileA has fields SerialA and NameA
FileB has fields SerialB and NameB
Define Ralationship1 = SerialA::SerialB
Define Relatinoship2 = SerialB::SerialA
Define NameB as Auto-enter Relationship2::NameA
In a nutshell, when you create a record in your secondary file, you also create a backwards relationship allowing you to get anything you want from the Master.


Cheers,
Paul J.