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

[JulienMoulis]

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)

 

 

[Jan]

Hi jules,

 

Welcome to Caspio forum!

 

As far as I know, you can use a View.

You can create a View that uses both tables, and in your Report DataPage display the Name of an employee from the second table.

 

I hope, it helps.