JulienMoulis Posted August 29, 2015 Report Share Posted August 29, 2015 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) Quote Link to comment Share on other sites More sharing options...
0 Jan Posted September 15, 2015 Report Share Posted September 15, 2015 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. JulienMoulis 1 Quote Link to comment Share on other sites More sharing options...
Question
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:
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)
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.