I have an application for organizing people into focus groups. When a Study is created, the user names 1-n possible focus groups (e.g., "group 1" "group 2"). People are recruited to a study and must be assigned to focus groups.
To assign a Person to a focus group, the user needs to look at a variety of background information on each person. Thus, I'd like the interface to look like: (for a given Study)
Person 1's name Gender Experience etc... <lookup drop down with possible focus group names>
Person 2's name Gender Experience etc... <lookup drop down with possible focus group names>
Person 3's name Gender Experience etc... <lookup drop down with possible focus group names>
in other words, I do not want the user to have to bring up each Person's editing form to select the focus group name (too many mouse clicks).
Here's the problem: I cannot use a View because the focus group names are specific to a Study. Although I could use an HTML view (dynamically creating a table of Persons with the appropriate drop-down menu on each row, then use a POST to update the records of each Person), I was hoping for a simpler solution.
Any suggestions?