Appearing Checkbox Fields

[etsmarines]

I have a check-box set as a list of a bunch of different options for people to choose. How can i make it so that if for example they choose faculty, when they select that check-box another check-box field will appear so they can also choose past or present. So in other words, one could click on Faculty and then once they clicked on that, a check-box field with the options to specify if they were past or present faculty members would show up. If they unchecked faculty that check-box field would go away.

Edited March 25, 2010 by Guest

[bcooney]

What you are asking for is called a conditional value list. It is my hunch that checkboxes aren't the way to go. Sounds like you're assigning types to people, and given the checkbox idea, a person can be more than one type.

That requirement is usually solved with a join table, a table that stores the combinations of that person and the types assigned. So, if I create a record in a join table for that person and assign the type Faculty, I could then have a start date and end date in that record that indicates their tenure.

[etsmarines]

Im assigning constituencies to people. I am using a checkbox set so that they can select more than one choice. For example someone could be a donor and a faculty member and also an alumni. I have attached the file so that you can see what Im talking about. The place where I want the checkbox to appear based on values selected in the constituency checkbox is under other information.

PMCA_CONTACT_MANAGEMENT.zip

[bcooney]

I understand what a checkbox set is. I am saying that you shouldn't use one. You should have another table that is related to your contact and holds their constituency data. Then you can have a field in the constituency table that is a comment (in the case of faculty member you'd enter alumni). If it's very important to be able to find all contacts that are faculty that are alumni, then you'll need value lists.

Also, your family details tab shows poor structure. You should have another table for the family members or use a self-join relationship to other Contact records.