problem with building prompt using 3 tables

[DWB]

Hi all,

i have 3 tables. i have to build a prompt based on these 3 tables.

Attendance_register(code,no_of_days_worked),
employee(emp_code, emp_name),
trainee(trainee_code, trainee_name)

'code' field of Attendance_register table is a combination of codes from both employee and trainee tables

usevalue of the prompt must be from attendance_register table(namely code)Ã,  and display value of the prompt must be the corresponding value from either of the tables.

can anyone one help me to solve this...

Thanks in advance.

[anoop_ind2]

Am assuming that you want to display either the employee name or the trainee name as display field.

Build a tabular set with two tabular models.
First tabular model would have the code field from Attendance_register and the name from the employee table and the filter to join the code and emp_code.
The second tabular model would do the same and instead of the employee table would use the trainee table. The resultant query would haveÃ,  code and name as the two fields. You can use the code as the use value and the name as display value from this Query.
Lemme know if this helped....

[DWB]

Hi,

thats correct, i have to display either emp_name or trainee_name coressponding to usevalue in the prompt...

But am new to reportnet, i have no idea how to create tabular set and tabular model for prompt. can u elaborate the procedure to slove this...

Thanks in advance