List Field in Table

[cbdcolga]

When you use a Yes/No field in your table and then want to have another field that will allow the user to list if yes...
_______________

Example that will be used in my form:

Are there any dependencies? Yes/No (they will choose from a drop down, yes or no)
If yes, please list dependencies: ??
_______________

How do you set up the if yes field in the table? I want it to be able to have it show as a list, not as one long text field with everything seperated by commas or semi-colons.

Is this possible?

 

[dionem]

My suggestion would be to set up another table with all the 'yes' options listed, then, in on the form you can create a combo box based on the 'yes options' table. Make sure you have a field in the original table that you can save their selection back to eg "yes_option_picked"