@Dblookup help

[Djbell]

Hi All

I have the following ODBC lookup on a Dialog Box in the
use formula for choices box.

@DbLookup("ODBC"; "SWAN"; "DOUGIE"; "****"; "STOCK_CONTROL_FILE"; "ITEM_DESCRIPTION_1"; "ITEM_NUMBER";"CS-ENG001")

This works great and displays the record for CS-ENG001.
On the same form I have a ComboBox with the following info.

CS-ENG
CS-SPARES
CS-ACC

What I would like is for my Dialogbox to display the records that begin with whatever is chosen in the Combobox so just instead of displaying the entry for CS-ENG001 I want it to display all entries that has CS-ENG.

I have tried different things but dont get the results I am looking for.

Any help is appreciated

Regards

Douglas Bell

 

[pmonett]

In your dialog box you need another lookup formula that uses the combobox choice as key.
Your combobox needs to refresh document when changed, and your dialog box needs to refresh keywords on document refresh.

Oh, and make sure your dialog box is located AFTER your combobox, else you'll get inconsistent results.

Pascal.