You are viewing limited content. For full access, please sign in.

Question

Question

Forms SQL Lookup To Table With Multiple Duplicates

asked on May 4, 2018

Hello,

I have a bit of a problem determining the best way of performing this lookup. I have some job titles that I am populating to a drop down. After they select one, it populates a hidden field with a position id that is unique to find the rest of the data regarding that position. The problem is, there is time where we have duplicate job titles. I was able to get around it by concatenating the unique id and the job title together, which doesn't look great, but performs exactly how I would want it to.

 

Anyone have any ideas regarding this? Forms only lists the duplicate once in a drop down. For instance: if you have 3 copies of one job title, it will only show the job title once.

0 0

Replies

replied on May 7, 2018

Hi Keith,

I'm not sure of the data source you're working with, but do you have the option of creating a SQL view wherein you SELECT DISTINCT...? If so, this is probably your best bet since there are no ways to de-duplicate data sources within Forms (AFAIK).

~Rob

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.