I have values in a table like this:
S01-2000
S01-2001
R01-2000
etc....
As you can see I have two values with 2000, just prefix is different. I capture the prefix in a separate field in my form (eg: 'S01-")
When I try to implement the AutoComplete event I would like to filter the results, but it seems I cannot pass the "S01-" field to the database read. it only takes values from the dropdown field you are typing in, that's it.
Hope this makes sense
S01-2000
S01-2001
R01-2000
etc....
As you can see I have two values with 2000, just prefix is different. I capture the prefix in a separate field in my form (eg: 'S01-")
When I try to implement the AutoComplete event I would like to filter the results, but it seems I cannot pass the "S01-" field to the database read. it only takes values from the dropdown field you are typing in, that's it.
Hope this makes sense