I am using the Caspio RELS sample for Inquiries: Trying to pass a logged-in member's personal info stored in our member's database along with the property inquiry form instead of having to fill in manual data, plus I receive other valuable stats (age, sex, marital status, etc)
I have managed to modify and test the Inquiry table to receive the parameter values from the Property_Listings Search and Report and Property Inquiry form including member's personal info. But that works when I force the addition of Member's Table (member.active=agent.active) to the combined RELSAgent+RELSListing View but I get a bunch of duplicate listings in the search form so that is not working completely.
Does anyone have an idea on how to incorporate the member's data? Somehow in a view or pulling in directly from member's database? Otherwise? And writing it back into the Inquiry table with the property inquiry.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
normindr
I am using the Caspio RELS sample for Inquiries: Trying to pass a logged-in member's personal info stored in our member's database along with the property inquiry form instead of having to fill in manual data, plus I receive other valuable stats (age, sex, marital status, etc)
I have managed to modify and test the Inquiry table to receive the parameter values from the Property_Listings Search and Report and Property Inquiry form including member's personal info. But that works when I force the addition of Member's Table (member.active=agent.active) to the combined RELSAgent+RELSListing View but I get a bunch of duplicate listings in the search form so that is not working completely.
Does anyone have an idea on how to incorporate the member's data? Somehow in a view or pulling in directly from member's database? Otherwise? And writing it back into the Inquiry table with the property inquiry.
Could use a hand.
Thanks
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.