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.