I'm very new to database design so there may be a very simple solution that i just cant see.
I am trying to build a simple referral tracking system
I am using filemaker
The challenge i have is how to link the referrer to the referree. As i understand it, it is a one (referrer) to many (referrees) relationship. but both the referree and the referrer are customers in the same table.
what i want is in the customer table, to be able to select the referring customer and for the referring customers record to have a list of all the other customers that they referred.