Hi, all!
I'm new here, and I'd like to thank you in advance for your help.
I've got what, for me, is a bear of a request for assistance. The main concept around all is that I'm trying to match young professionals with organizations based upon interests. The interests table (InterestsT) includes things such as "Art," "Entrepreneurship," etc. Both the Organizations table (OrganizationsT) and the young professionals table (YPT) will access InterestsT.
It's in 3 parts:
PART 1 - Live updating of InterestsT
On the YP form (YPF), where YP data will be entered, there will be a combo box that will access the InterestsT. InterestsT will (1) NOT limit to the list (so people can add interests "on the fly and as new organizations/YPs are added) and (2) be a multi-select field. I would like these added interests to append to the InterestsT. Ditto for teh OrganizationsT. Any thoughts on how to do this?
Part 2 - Matching YPs to Organizations and vice/versa
So, now that I've got YPs, each with one or more interest and Organizations all with one or more interests, I want to match them up on a new Form -- MatchingF. I would like people to be able to have the choice of selecting either an Organization or a YP. Then I would like this to happen:
1. The choices their selection made in InterestsT will be displayed. Also, the data from the memo field in the selection's record (OrgMemo/YPMemo) will be displayed.
2. They will press "Go" or something.
3. A list of YPs/Organizations (respectively) that have at least one InterestT in common with the selected YP/Organization will be displayed, along with each of their InterestsT selections. Also, the data from the memo field in each of the potential match's Memo field will be displayed.
Part 3 - Making the Match
1. Ideally, they could select one of these possible matches, which would then populate a Match field in each of the corresponding Org/YP records, but that might be asking too much, if I'm not asking too much already.
I surely appreciate any help you can give me.
I'm rather new to both Access and VP Script, but I seem to have a tiny breakthrough each day. I just wouldn't even know how to search for this one!!!
--ak