Easiest way to track referrals (one client, several referrals, later count referrals)

pianoprodigy

Registered User.
Local time
Today, 12:06
Joined
Apr 22, 2003
Messages
42
:confused:

I have been messing with this far too long, and I am just having a mental block.

I am working on a referral database that would track referrals that I would send to doctors and other lawyers.

I currently have 2 tables.
1. Client (ClientID, FirstName, LastName, FromID, To1ID, To2ID)
2. Contacts (ContactID, Firm, FirstName, LastName, Address, etc.)

I have a Form created which allows you to add new clients and then drop down boxes to select the appropriate referral. This seems to work ok, but then I can't figure out how I would actually run a report to find out which clients (and how many) have a referral to a certain contact.

I hope this is making some sense. Is there a sample database that I could start with somewhere, or am I going about this all the wrong way. I'm not asking someone to work for free, but I do need some guidance here so that I'm not wasting valuable time.

Thanks so much!
 

Users who are viewing this thread

Back
Top Bottom