Title
Nested Fields
Post
Hello,
I am working wit a database that requires certain fields to be filled out based on certain criteria.
For example:
If the event fees box is checked to yes or radio button yes is selected then I would like it to display the fields to
take credit card information. If the box is checked to no then I do not want to display the credit card information fields.
Any ideas?
I can't give you precise details without knowing more about your tables and their relationships but here's a general outline:
Put the credit card info in a separate table. (you may already have this.)
Define a relationship that links to this table. Define it so that is valid if the checkbox or radiobutton field contains a specific value and is invalid if it does not. (Valid: there's a matching record(s). Invalid: There's no matching record(s).)
Now you can either place the credit card fields directly on a layout or display them in a portal. When you click on a radio button or check box to make the relationship valid, the info will appear, if you click the check box a second time or choose a different radio button value so that the relationship is invalid, the data will disappear from the layout.
If you'd like to get a more detailed description, describe your fields/tables in more detail, and I'll take a swing at it.