Trev - yes it is possible by tweaking the party.customerperson archetype to add a new field 'Referred by Customer'.  Since we want to be a bit sexy and enable the 'referred by customer' to be looked up, we want more than a simple text field.

Here is my test customer with the new field added and set:

To achieve this we need to do two things:

a) add a new archetype to define the customer-to-customer link - I have called this entityLink.customerCustomer.adl (and the file is attached)

b) modify the party.customerperson.adl to include the new field (and the modified version of the standard party.customerperson.adl is attached)

So download the two files and put them where you keep your modified archetypes (so that when you upgrade to the next release of OpenVPMS you know which archetypes you can to check, and if necessary adjust).

Then use Administration|Archetypes|import to import them - import entityLink.customerCustomer.adl first, then the modified party.customerperson.

Log out, and back in again and away you go.

Now I don't really want to build to report you want, but the underlying SQL is as follows:

I must admit that I was somewhat surprised how easy this was. I knew that adding a text field was a piece of cake, but I did not think that adding a linked customer field would be either easy or possible. In fact it also turned out to be a piece of cake also. You must admit that it is impressive that all one does is tweak the archetype and magically it works.

Regards, Tim G