[jezmathers]

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.

[amosbatto]

I see the same problem using PM 3.2.1. Please file a bug report about this at http://bugs.processmaker.com

If you don't have a dependency field, then you can work around this problem by doing your query in a trigger with executeQuery() and then assigning the result to a variable to be used as the array variable of the suggest box. See the second trigger example in:
http://wiki.processmaker.com/3.2/DynaFo ... y_Variable