Hi,
I have a combo that I want to populate using an SQL SELECT query. The source table records have a Customer text field together with a LiveOrder checkbox field which is unchecked if the customer has a live order.
However, if a customer has more than one LiveOrder the customer's name appears...