Question

DB lookup multiple match in Forms

Forms

Updated November 27, 2019

asked on July 16, 2017

I have a lookup that has multiple matches returned however on the form it does not give the user the option to select from these matches. In the LF repository I have the same lookup running and the user can select from the results when multiple matches are found. Below is a screenshot from the table. Is it possible to enable the same response in Forms, if yes how do I accomplish this?

0 0

Replies

replied on July 16, 2017 • Show version history

Hi Chris,

Which version of Forms are you currently running? Also, what type of field are you using? We have a form that uses this feature, which I know for certain worked at least in version 10.

With multiple matches, there are a few slightly different behaviors:

Single Line
- Shows all matches in a suggestion-type pop up below the field when it is selected
- Narrows the options based on characters typed in by the user
- Still allows custom selections/input

Drop-down
- Populates the list with all matches
- Also allows appending default options (like Other)
- Does not allow custom inputs

Table
- Adds a row for each match

If you're on a version that should support this, but you're not seeing the results you want, then I would try testing a drop-down to make sure your lookup rule is giving you the expected results.

0 0

replied on July 17, 2017

Hi Mark, thanks for the quick response. We are using version 10.2. Department name is a list and some departments are listed twice once in all CAPS and again normally. One department number is used for budget request and the other when the funds are expended. In the client if I select a department that is listed twice I have the option using a drop-down to select the appropriate value.

In forms it remains blank if I select a department with two possible values.

0 0

replied on July 17, 2017

Have you tried applying the lookup rule to a drop-down to make sure you're getting the expected results? I meant what type of field are you using on the Form.

0 0

replied on July 18, 2017

I am using a "drop-down" (list) field, however it is being populated from the database.

0 0

View 6 previous replies

replied on July 18, 2017 • Show version history

What values appear in your drop-down with this lookup?

The current rule has no "When" condition should it should be filling that drop-down with every value in the DEPARTMENT column.

If you're not seeing anything, then the data source/lookup is not working properly.

0 0

replied on July 18, 2017

I see all the values in the department list. The issue is that if the there are two matching departments the corresponding code values are not presented (in a drop down) as happens in the LF client. The user has to then lookup the value and type it in. This is what I need a fix for so that it either creates a dynamic drop down as happens in the LF client or a pop-out so the user can select the correct value. I hope this makes sense.

0 0

replied on July 18, 2017 • Show version history

Okay, and what is the Lookup for Code field/column?

0 0

replied on July 18, 2017

There is no lookup for the Code column. These are the only two lookups present. The first one populates the department values in the drop-down, the second populates the code based on the department value selected.

0 0

replied on July 18, 2017

Right, the lookup for the code is what I meant. The first thing I would suggest you test is adding a Drop-Down field with the same lookup as the Dept # field.

That way you can verify that it is actually giving you the results you're expecting.

0 0

replied on July 18, 2017

You are absolutely correct, after replacing the field with a a drop down I am now getting the option to select the appropriate value. Lesson learnt, if the lookup column has duplicate values then the field that is being populated must be a drop down field.

Jason, thanks for sticking with me through this, I appreciate.

0 0

replied on July 18, 2017

Chris,

Glad it is working for you, but there might also be a browser, version issue, or something else at play here because that shouldn't be necessary.

I have a form that uses a single line field and it works. The key difference is that it will allow free form inputs and you probably don't want that.

In that screen shot I posted earlier, I have a lookup (single line field) that returns multiple results, and creates a pop-up when you put the cursor in it.

If you're not getting the same results, you could try and test it in a different browser to see if that might be why.

0 0

replied on July 18, 2017

Before I changed the Dept # to a list field it was a number field, I am thinking that is why it did not allow me to choose from the two values found in the DB lookup. I could be wrong.

I am having other issues that I am working with support on for Web Access that maybe a browser issue but at this time I do not think this falls into that category.

On this issue I am good.

0 0

replied on November 27, 2019

is there a way to get the list from the autocomplete list to another control like a table?

0 0

You are not allowed to follow up in this post.

Question

Question

DB lookup multiple match in Forms

Replies

Sign in to reply to this post.