Question

Show Table and Trigger Lookup with Checkbox

Forms Version 11

Updated March 31

asked on March 27

Modern Forms

Each row in the "General Information" table has corresponding set of "HFACS - A - Management Condition" records in a separate SQL table. All tables used in this process share a common "Item #" field.

I would like the user to have the ability to select the "HFACS Info" checkbox in a particular row (or other field type, if needed) to show the associated "HFACS - A - Management Condition" info. There are also additional SQL tables with "HFACS - B...", "HFACS - C..." and "HFACS - D...".

Can a lookup be triggered using a checkbox (or other field type, if needed) to accomplish this?

0 0

Replies

replied on March 27 • Show version history

Is your original table populated by a lookup? If so:

Just add the additional info to that query and use field rules to show/hide the extra info

If it is not, you have to:

populate a hidden field when the checkbox is checked
use that hidden field to run your lookup
use the checkbox and field rules to show/hide the extra info

- OR -

Trigger the lookup with whatever information does the search query automatically when it is input
use the checkbox and field rules to show/hide the extra info

2 0

replied on March 31

My original table is populated by a lookup. The information in the second table could have multiple rows with the same "Item #" from a single row in the original table.

I've changed the checkbox in the original table to a Yes/No dropdown. Goal is still the same. If the user selected "Yes" in a row from the first table, I'd like to trigger a lookup and display the related row(s) in the second table.

0 0

You are not allowed to follow up in this post.

Question

Question

Show Table and Trigger Lookup with Checkbox

Replies

Sign in to reply to this post.