Issue
User creates a lookup table that pulls ALL results for a specific entity but not all of them are populating in the lookup column
Environment
Lookup Tables / Columns, Results
Cause
The dropdown type only gets pulled into the lookup columns once with no duplicates. Lookup columns won't show you how many times a dropdown option was recorded but only whether the option was recorded or not. E.g. if you recorded Yes 2 times and No 1 time, it will still be pulled as "Yes, No" in the lookup column and not "Yes, Yes, No".
Resolution steps
Change the dropdown type to text or number. If the dropdown was yes/no, a boolean type will work as well.