ashley0578
Registered User.
- Local time
- Today, 08:24
- Joined
- Oct 14, 2005
- Messages
- 16
I am trying to create a reference tree. Basically, when we get a customer, we will usually get at least 5 references. Sometimes, one of those references becomes a customer or was a former customer. What I need to do is make some sort of sense out of what I have available to me.
Basically, I have two tables from my software... TRReference and TRCredit. Both use the account number as the key so joining the Buyer with their references into a query is easily done. Now, what I need to do is figure out if those references ever became a customer. I really have no idea how to do this. If somebody has done something similar, I would love to know. Thanks!
Basically, I have two tables from my software... TRReference and TRCredit. Both use the account number as the key so joining the Buyer with their references into a query is easily done. Now, what I need to do is figure out if those references ever became a customer. I really have no idea how to do this. If somebody has done something similar, I would love to know. Thanks!
