I have a piece of code that relates 3 tables and depending on what the user types in does a conditional browse of various fields picked from these 3 different table. That is 16-bit code.

In 32-bit this code has been converted. Now uses a searchaeble custome combobox. Except this time the code builds the cursor / view first that bound to the combo. Trouble the sql has 2 joins, and when the tables are really big it takes ages to excute, users arent happy about this delay.

I have toyed with the idea of using browse again and it's instant but not as pretty. Any good ideas of how it could still use browse but make it look nice and pretty someway?

Then I thought, oh GRIDS! But they only ever display data from a single table. I know grids have those relationship properties but have i missed something here?

Please help

Thanks

Mathias