Question

Parent/Child Fields on Forms

Forms

Updated November 20, 2015

asked on November 20, 2015

Is it possible to configure parent/child fields on forms? I would like to do a lookup to an employee list and have the user first select a department. Based on that decision, different names will be available in the employee name drop down box.

Name.JPG (10.34 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on November 20, 2015

Yes, this is very easy to do using a forms Lookup Rules.

When setting up the Lookup Rule, you need to do something like the following:

When "Department" matches with data source column "Data Source Department Column"
Fill "Name" with data source value "Data Source Name Column"

If you have a list of available departments in the database, you could even have it populate your Department dropdown as well by using the Fill option in the Lookup Rules.

0 0

Replies

replied on November 20, 2015

Thanks for your help. Do you know if there is a way to make it so the parent field has a default value and is not changeable by the user? There is a column in the database called "supervisor" and all of the values in that column are either "yes" or "no". For this form, it is for supervisors only so it would be beneficial if only the supervisor names appear in the "name" drop down box.

0 0

replied on November 20, 2015

For that you could use a single line field with a default value of yes. Then use that single line field in your Lookup Rule with the When statement.

1 0

You are not allowed to follow up in this post.

Question

Question

Parent/Child Fields on Forms

Answer

Replies

Sign in to reply to this post.