Gymsmoke
Posts: 3
|
Posted: 04/27/2004, 10:18 AM |
|
I'm working on a search box with 4 search parameters. 3 are text boxes, 1 is a lookup (listbox). I have the display and bound columns setup in the listbox on the search. I need to 'wire' this search box to a grid, but I want to know which of the search parameters were used. Further, if the parameter used was the value in the listbox, I need to utilize a lookup so that I display the text value on the grid instead of the numbered code stored in the row. I'd also like to use this same lookup logic when the grid is in insert/edit mode. Any input is quite appreciated.
_________________
Losers always whine about their best...
Winners go home with the prom queen. |
|
|
Don Safar
|
Posted: 04/27/2004, 10:36 AM |
|
IN the query builder for the grid, join the table used for lookup. In the
grid, change the column to use the text field from the lookup table instead
of the integer(number) field. Make sure you change the type to text and also
change any sorters to point to the text field.
"Gymsmoke" <Gymsmoke@forum.codecharge> wrote in message
news:5408e95df4561c@news.codecharge.com...
> I'm working on a search box with 4 search parameters. 3 are text boxes, 1
is a
> lookup (listbox). I have the display and bound columns setup in the
listbox on
> the search. I need to 'wire' this search box to a grid, but I want to
know
> which of the search parameters were used. Further, if the parameter used
was
> the value in the listbox, I need to utilize a lookup so that I display the
text
> value on the grid instead of the numbered code stored in the row. I'd
also
> like to use this same lookup logic when the grid is in insert/edit mode.
Any
> input is quite appreciated.
> _________________
> Losers always whine about their best...
> Winners go home with the prom queen.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|