- Thu Dec 28, 2017 9:50 am
#812660
Trying to combine data from two tables to use in a "Suggest" field, however this is not working, The field will "suggest" the entire result table regardless of what characters are entered by the user.
As a simple test I used the following SQL in a suggest control:
select '0', 'All'
UNION
select '1', 'ABC COMPANY'
UNION
select '2', 'DEF COMPANY'
UNION
select '3', 'GHI COMPANY';
If you preview the dynafrom and start typing your will be resented with all 4 rows, regardless of what characters you type in.
As a simple test I used the following SQL in a suggest control:
select '0', 'All'
UNION
select '1', 'ABC COMPANY'
UNION
select '2', 'DEF COMPANY'
UNION
select '3', 'GHI COMPANY';
If you preview the dynafrom and start typing your will be resented with all 4 rows, regardless of what characters you type in.