hi all i hope everyone is well, I was asked a good question today that I wasn't sure about, my client asked me about a combi box he has on the new order form, the box at the moment has his customer list as the record source for the combi box drop-down in last name order, working great so I thought, the bound field is a customer account number made up of UCN-AB-XXXX , where ab is the account holder intials and xxxx is the customer id number from the table.
anyway, he told me it takes too long to scroll through the nearly 450 records to find the customer he wants. he then explained he's worried that in a year's time, the volume of customer details saved would soon be overwhelming as this 450 is from a month or two, so he asked me if he could filter the drop-down list.
For example, is he wanted to select a customer with first name jody he can type jo and the list filters it, i explained if he types "ucn-j" the list does jump to the closest account number but he wanted to take this idea further. I'm wondering what the option might be. has anyone got similar issues I've seen this before but said it cannot be done.
anyway, he told me it takes too long to scroll through the nearly 450 records to find the customer he wants. he then explained he's worried that in a year's time, the volume of customer details saved would soon be overwhelming as this 450 is from a month or two, so he asked me if he could filter the drop-down list.
For example, is he wanted to select a customer with first name jody he can type jo and the list filters it, i explained if he types "ucn-j" the list does jump to the closest account number but he wanted to take this idea further. I'm wondering what the option might be. has anyone got similar issues I've seen this before but said it cannot be done.