Frank S
|
| Posted: 03/25/2005, 12:40 PM |
|
Hi folks,
I have a grid that displays data that needs to be bound from another table. The only way I have found to do this is by changing the format of the fiels to a List Box. Can anyone explain how to join a label field to another table??
Thanks,
Frank
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 03/28/2005, 1:13 AM |
|
Frank,
You can join two (or more) tables in Visual Query builder in CCS and use that joined tables as data source for your form.
Open Data Source dialog of a grid, click on Build Query button. In the opened Visual Query Builder create a query you need. Then change Control Source and may be Type of a Label control to force it to output a field you need.
_________________
Regards,
Nicole |
 |
|
FrankS
|
| Posted: 03/28/2005, 11:09 AM |
|
Hi Nicole,
How do you create the query? New to this -"In the opened Visual Query Builder create a query you need."
And then:
"Then change Control Source "
to what? SQL or expression.
Is there a tutorial that goes over this?
Thanks,
Frank
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/28/2005, 11:24 AM |
|
The tutorials in CodeCharge Studio show how to use VQB (Visual Query Builder). For example at:
http://docs.codecharge.com/studio/html/QuickStart/Creat...eryBuilder.html
http://docs.codecharge.com/studio/html/QuickStart/Creat...eryBuilder.html
I'd recommend spending 15 minutes with that tutorial.
The documentation for the Data Source that includes VQB is at:
http://docs.codecharge.com/studio/html/UserGuide/Forms/FormDataSource.html
"Data Source" is one of properties of grids and record forms. Once you open that property dialog you will be able to create a query for your form.
The goal for you would be to use a query (multiple tables) instead of single table for your grid.
This is also explained in the main CCS tutorial at http://docs.codecharge.com/studio/html/QuickStart/Creat...citRelship.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
