cringwall
Posts: 11
|
| Posted: 11/04/2010, 7:14 AM |
|
Hi all,
I like to display the 'text' values of my foreign keys that are in axillary 'lookup' tables in my grid.
So what I have been doing is, using list boxes to pull the values from the lookup tables into the grid and then just disabling the list box so it's grayed out. This way I can see what the real human value of the foreign key in the grid.
Is there a more elegant way to do this using a label instead? I can't figure it out.
Best,
Carl
|
 |
 |
datadoit
|
| Posted: 11/04/2010, 6:43 AM |
|
Sure. Use a label, and in the label's BeforeShow use the DLookup action.
|
|
|
|
cringwall
Posts: 11
|
| Posted: 11/04/2010, 7:49 AM |
|
Wow, that was easy.
Thanks.
|
|
|
|
dragoon
Posts: 173
|
| Posted: 11/06/2010, 3:20 PM |
|
structure your t-sql query and make use of a view.
a dlookup action will fire "n" additional queries on your sql box, where "n" is the number of rows in the grid.
|
|
|
|
|
