want to display value

I

Irfan

Guest
Hi,

Can anyone help to solve this type of problem:-

I want to display foreign key VALUE in place of foreign key ID in Result page of Dadabik?

e.g. I have a table USERS(USER_ID, USER_NAME, USER_TYPE). The column USER_TYPE referencs another table USER_TYPE (TYPE_ID, TYPE_DESCRIPTION). I want to display TYPE_DESCRIPTION not TYPE_ID in the result page of USERS Table.

Thanks

Muhmmad Irfan
 
R

Richard

Guest
I do not understand why it should not work. Make sure you are also using pkeys in your tables.
 
M

maletin

Guest
maybe he is asking about the "TWO:" patch?
That is using a description instead of the primary key with "SQL:"
 
Top