Combo-box not working

[thero]

I'm searching an external database using @DbCommand and ODBC. The SQL command in @DbCommand returns a string of possible matches, separated by commas which I have in a field called results. I want these possible matches to be presented to the user in a combo-box so I'm using the "Use formula for choices" option. I've been trying for to get the search matches to display in the combo-box so that the user can select the correct one. I've tried it with the @Explode function and without.


Can anyone help??

Many Thanks

 

[gamesman]

try the following with your formula, create a keyword field and set it to computed using a formula and insert your formula.

 

[Replicator]

Go into Results Field Properties.
Have you set your results field so that it can have multiple entries?
You may also need to set the multi-value options on the third tab to 'Seperate Values when user enters a comma'.

That should sort you out!