technicalbard
Posts: 7
|
| Posted: 04/15/2008, 8:29 PM |
|
I'm stumped. I've got a system where I want a grid to show the following information:
GRID to be displayed
JOB NUMBER
CREATOR NAME
ASSIGNEE NAME
JOB table
JOB_NUMBER
CREATOR_ID (FK_USERS_USERID)
ASSIGNEE_ID (FK_USERS_USERID)
USER table
USER_ID
USERNAME
How do I get tell the label (or other control) in the grid to give me the name associated with the ID for BOTH users?
|
 |
 |
technicalbard
Posts: 7
|
| Posted: 04/15/2008, 8:41 PM |
|
OK - I'll admit I'm no database or PHP guru. I'm realizing that the Visual Query Builder in CCS doesn't pick up the foreign key relationships from a MySQL database via ODBC.
So do I have to write my own SQL code (ick) to do what I want to do?
|
|
|
|
ReneS
Posts: 225
|
| Posted: 04/16/2008, 1:16 AM |
|
Hi,
I think you can make the relationship in the VQB yourself, drag and drop the appropriate id field on the other tables id field. I think.....
Rene
|
|
|
|
|
