Hello,

I need to create a page that displays the data from three forms based on an option selected from a list, for example:

Let's say I have 3 forms:

- One named "employee" that has 4 fields: ID, name, phone, extension.

- A second form named "department"  that has 3 fields: lookupID1 (is a lookup field from the employee form), role, officeNumber.

- And a third form named "payment" with 3 fields: lookupID2 (is a lookup field from the employee form), salary, payDay.

I need to create a page with this content: 

-One field named "Workers" that displays all the employees from the "employee" form as a list.

-Another field with the role and officeNumber from the "department" form BASED ON the option selected on the "Workers" field.

-And the last field with the salary from the "payment" form BASED ON the option selected on the "Workers" field.

Can this page be created? And How can I do it? I don't know how to fetch those records and show them into a Page.

Thank a lot!