Sure!

Here's a good example: say you want some want to select a make and model of a vehicle on a form. You could create a field called "Make", with Ford, Honda, Toyota, etc. as options. Then create a field called "Model" and create one set of alternate options with models of Ford cards, one set with models of Honda cars, one set with models of Toyota.

Then, once your alternate options are setup, you specify rules to say "if user selects Honda, show the Honda options; if user selects Toyota, show the Toyota options."

Make sense?

Excellent! I thought that was the intent but I could not figure out how to write the rules.

Thank you.

Justin,

I do apologize for this, but could you please give me a more detailed description on this. I had it working when you first responded to me but didn't have the need to use it until now (I may sell more than a few versions of Advanced Forms & Data Display if I can figure it out) and now I'm having trouble. I build the forms, (for my purposes using Departments and Employees, but when I try to set the rules for pulling employees by department I am seeing no "alternative options" and don't remember how to get it working.

Many thanks,

Russell

I suspect AF now does this scenario a bit differently than when the question was originally posted. In the current version it can be done with the Rules tool.

If Fields (can be dropdowns, checkboxes, etc.) are defined as:

Field: Department
Option: Repair
Option: Sales

Field: Repair Employees
Option: Adam
Option: Amy
Option: Arvis

Field: Sales Employees
Option: Betty
Option: Bibi
Option: Bob

In Rules ("Rules allow you to display certain fields based on values specified in other fields"), you'd add rules like...

If [Select: Department][Select: is equal to]
[Type: Repair] show [Select: Repair Employees]

and...

If [Select: Department][Select: is equal to]
[Type: Sales] show [Select: Sales Employees]

Then, on the frontend, you'll get:

Department
X Repair
_ Sales

--- Hidden unless "Repair" selected ---

Repair Employees
_ Adam
_ Amy
_ Arvis

--- Hidden unless "Sales" selected ---

Repair Employees
_ Betty
_ Bibi
_ Bob

Is it possible to do the scenario below with data from database?


pulldown from formentry-->
values would be
Make:
Ford
Chevy

from that answer display information about the makers?

Make: Place of Origin: Founder:
Ford Detroit Henry Ford

All values being pulled from database based on Pulldown Make: ??

Not without some customization. The purpose of alternate options would be to do something more like, you select the Make, and then the "Model" field populates with models of that specific make.