How to remove blanks from a dropdown or listbox?
Question:
How to prevent blank entries or lines from displaying in a dropdown form element?
Answer:
Rather than using a table as your lookup, use a View that filters out the blank entries.
See how to create a view to filter records here. Use Comparison type "Is Not Blank" for the field that has the blanks.
