Jump to content
  • 0

Tabular Report Dropdown Look Up Show Up Display Field Instead Of Value


JulienMoulis
 Share

Question

Hi,

Context:

I have two tables:

First: T_EMPLOYEE - PRIMARY KEY: Employee_ID

Second: T_TASK - Primary key: ID_TASK, and Foreign Key: EMPLOYEE_ID_FK

There is a Relationship on-to-many between those two (an employee can receive some task)

 

I build a datapage tabular report based on T_TASK. I inserted in result page fields EMPLOYEE_ID_FK as a dropdown look up field as following:

  • Table or view: T_EMPLOYEE
  • Field for display: EMPLOYEE_FIRST_NAME
  • Field for value: Employee_ID

When I test the report I only see the first name when editing but I only see the number value when only display. see attached screenshot.

 

Is there a way for displaying the right field for display in a no editing mode in a tabular report dropdown lookup field?

 

Thanks for your help

(I'm with the free version of caspio)

 

 

post-18852-0-54791100-1440864591_thumb.p

post-18852-0-00880900-1440864643_thumb.p

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...