Show Related Record Information

[andres]

Hi Eugenio

I have an employee database and an events database. An event is performed by a single employee, and therefore there is one field in the events database that is the employee unique key. There is a relationship defined, and with this relationship I am able to see the list of events assigned to an employe on the employee details page.

How can I do the following?....

Show information from the employee on the event details page. I would like to show the name of the employee, not only the unique key.

Thank you
Andres

 

[eugenio]

Hello,
if id_employee is a select_single field in events (as it should be), you can just add as linked fields all the fields you need, including the name.

Best,

 

[andres]

Thank you Eugenio

How do I add linked fields?

Andres

 

[andres]

Found it.

In the forms configurator. Not only you need to select the Field Type as Select Single. You need to select the right option from Lookup table name, Lookup table primary key field and Lookup table linked fields as well.

Thank you Eugenio. It works as expected.

Andres

 

[eugenio]

Perfect.
Yes when I answered I assumed you had already set up the field as select_single lookup.

Best,