pianoprodigy
Registered User.
- Local time
- Today, 12:06
- Joined
- Apr 22, 2003
- Messages
- 42
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!