DaveRexel
|
| Posted: 04/26/2002, 7:57 PM |
|
CCS - Howto lookup values in another table and show them as a label on my grid?
this was possible quite easily in CC-2x
|
|
|
 |
Bill Heaton
|
| Posted: 04/27/2002, 3:23 AM |
|
This one had me stumped for while too. However, with some digging around I was able to figure it out. Let's assume that you have a grid on your page.
1) Click on the Grid's begining tag so that it's properties show up in the Properties window.
2) Click on the "Data Source" field
3) Click on the "..." button that appears on the end of the line
4) On the Data Source Dialog, click "Select Query". Hint: Move the dialog so that you can see your grid!
5) Click on the "Select Query" button. Hint: Move this one so that you can see your grid!
6)You'll See the fields in your 1st table. Click on the Icon with the plus symbol and select the table(s) that your linking to.
7) Arrange the tables in a pleasing order. Then click the "field name" of the 1st table that links you to the other and Drag it to the field that your linking to.
8) Now click all checkboxes for the fields that you want returned. Hint: You can double-click fields and table names to set aliases for them.
9) Relax your most of the way there. Click "OK" to return to the Data source dialog.
10) click "OK" to go back to the Properties.
Now comes the fun part, using it!
11) Select the starting tag of the field you are changing to get to the properties.
12) Change the "Control Source" to the one of the names that was generated by 1-10 above.
Sound complicated, but once you get the hang of it...Is fast and easy!
Regards, Bill
12)
5)
|
|
|
|
Petr
|
| Posted: 04/27/2002, 9:23 AM |
|
... you guys should be first reading the 50+ page PDF introductory tutorial on CCStudio. IT IS ALL THERE, black on white.
|
|
|
|
DaveRexel
|
| Posted: 04/27/2002, 1:06 PM |
|
Thank you Bill, it worked like a charm. I'm too tired to look at the newly released docs so thanks to Petr as well.
The Query builder looks very tasty. Hats off to the codechargers!
|
|
|
|
|
