CiviCRM Community Forums (archive)

Hello. I have a quirky problem - was wondering if there was any hope for me. It requires a bit of an explanation, so please bear with me...

I was hoping to create a custom data set that would have a pull down menu of dance styles (ballet, tap, jazz, hip-hop, etc) and another pull down that would be related to the first that would contain various levels (novice, intermediate, professional, etc.). As well, there would be a related check box to indicate whether or not the dancer is certified through our program. The data would be collected in pairs (or triplets, rather) like so:


Option 1     Option 2       Certified
jazz         intermediate   checked
ballet       novice         unchecked
Irish step   advanced       checked


I attached a picture of how imagine the interface might look...
 
I have created a custom data set that has the options set up like I want. I have checked the "Does this Custom Field Set allow multiple records?" yes - and tried to choose the inline option. Evidently, however the multiple records choice limits me to only choosing the tab option.

I can live with that if that's the way things work, but when I try to create a CiviCRM profile for a member directory search, the custom data doesn't appear in any of the options (individual, contact, etc.). The idea of having these sets of data is to create a search function that would allow someone to search by picking from each column and searching for a match. Something like this:

SEARCH Option 1 [pulldown]     -     SEARCH Option 2 [pulldown]

...where I could choose "jazz" from the pulldown on the left and "advanced" from the pulldown on the right - and the search return would show me only those folks in the database who had jazz/advanced as a pair (and the search results would also show yes or no under a column labeled certified).

So.

In a nut shell:

1. Can I create "paired" data sets in the way I have described?
2. Can I get the interface to exist inline (even if it means having a predetermined number of sets - like the attached image shows)?
3. If not, how can I get the data stored in the "tabbed" area to show in a profile search?
3. Is it possible to have a complex search function like the one I described?

Your time is most appreciated - CiviCRM is such a wonderful tool for us!

Thank you in advance,
Mark

p.s. if the attached image doesn't show, I have posted it at hxxp://www.fineminddesign.com/civi_wish.png

Hi Donald,

Thank you for the response and clarification. If I manage to work out a solution, I will be sure to share it here. Thanks again for all the hard work it takes to keep CiviCRM so great!

Cheers,
Mark