DeWebDude
|
| Posted: 07/08/2003, 10:55 AM |
|
I am trying to display a project_id as well as project name on a grid form, the table being displayed contains the project_id, and we then joing it to the project info table to associate the id to the name, therby showing the name.
Something LIke this
Client Proj-ID
Bob 2233
Now we want
Client Proj-ID Proj-Name
Bob 2233 Test codecharge install
The problem is when we put the same field name it doesn't like it (with good reason) so what is the way to show BOTH the ID & it's associated description ?
Thanks!
|
|
|
 |
Alex Alexapolsky
|
| Posted: 07/10/2003, 3:01 AM |
|
In you use regular CC, you may concatenate these fields in Form Properties/SQL
/Custom SQL. In CCS the same can be done in Grid/Data source property/dialog.
|
|
|
|
glerma
|
| Posted: 07/10/2003, 11:28 AM |
|
Here's an example to throw in for good measure (I use Oracle, not sure what you use).
SELECT USER_ID, USER_LAST||','||USER_FIRST AS CONCAT_NAME
FROM ADM_USERS
Shows up like:
USER_ID CONCAT_NAME
1 Doe, John
|
|
|
|
|
