Jump to content

Contact referred by...select other contact from same file?

Lee Brock

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi all. Geez what a learning curve. Thanks for your help.

My eyes are buggin from trying to figure this out.

I need a field in my bps_Contacts.fp7/Form View that relates to another record in the same file to track my client referrals. And I need to track that on both sides.

I need to see who referred a new client and I also need to see all of the referrals any one client has given me. I guess that would require another portal in the Form View similar to the portal that lists all the invoices created for each contact, but from the same file as opposed to the Sales Orders file.

Is this too big for a fairly right-brained beginner?


Link to comment
Share on other sites

Hmmm, that makes sense, for the first part I think. Thank you. I'll tinker with it.

Using this as a model, is the "Referrals" table a self-join relationship of "Sales Rep" that you renamed Referrals?

I'm wondering if I need to create another table occurrence, perhaps calling it "Referred", for another portal in the Sales Rep Layout (or another layout) to show all the referrals any one Name has produced. Am I making any sense?

Thanks for you and anyone's thoughts on this.

Link to comment
Share on other sites

That's what I was playing with. Didn't get it to work on first blush but I think we are on the right track. I'll let you know if I have any luck. Perhaps some of the more advanced folks on the forum can see what needs to be done.

Yes, I named the first self join referrals and the other referred.


Link to comment
Share on other sites

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.