Can this be done with Backend Queries?

There is a table "Company" and a table "Employee", each employee refers to his company
via the foreign key "id_company".

A OnTap in a ListView's row (ListView shows employees) navigates to a page (see below)
Employee number is passed as a page parameter.

The page should show the "employee number", "employee name" and the "company logo"
(Logo is only available in employee's parent table "Company")

Now the difficult part:

If I enter another Employee number in the TextField and press <Return>
the corresponding employee name should be inserted in the TextField "Employee Name"
and the logo of the related company should be shown.

How can this be done?

In the best case scenario, if no employee can be found for the number entered, the "Employee Name" field should be emptied and the image should display a default image.

2 replies