CK
|
| Posted: 05/30/2002, 6:58 AM |
|
I have a grid table that lists data from a table. 2 of the fields in the grid (which are integer) require look up value from another table.
How I can do this?
I use visual query builder to build the query but only the first field can lookup correctly. The second one is sometimes wrong.
I store up all the lookup values in a single table. I understand if I separate them into different table, the results will be correct.
In Codecharge, it is easy. The individual can look up very easy by adding JOIN. But now in CCS, I can have only one join for 2 tables I used.
|
|
|
 |
Nicole
|
| Posted: 05/31/2002, 2:36 AM |
|
Hello,
in contrast to CC you should build query using custom query or visual query builder to select fields from all tables you need.
What do you mean by "second one is sometimes wrong"? Do you get correct results when preview query results in design mode?
|
|
|
|
CK
|
| Posted: 05/31/2002, 8:23 PM |
|
In CC, once you are in the field properties, you can set the JOIN properties and lookup value from other table.
However, in CCS, there is no similar function. All you have to do are to define the field relationships in the visual query builder.
My problem is I have at 3 fields in one table that store integer only. They are related to another table which has reference to their description. I can define link for one field in table 1 to the descriptive fields in table 2. I can't create 2 links at the same time as the JOINs will restrict the result.
But if only one link is created, the descriptive value for the second field in table 1 will be incorrectly returned.
Any help is appreciate.
|
|
|
|
Nicole
|
| Posted: 06/01/2002, 2:57 AM |
|
As CCS do not have fields join feature you should buld sql query that will return all fields you need anyway. Try to create custom query in this case.
|
|
|
|
|
