Bring image as signature from another table

Hello, I need your help!
I have two tables, “employee” and “inspection”, In the employee table there are three columns employee id, name, signature (image jpg).
How can I make the “Inspection” form automatically bring the signature (image jpg) associated with it when choosing an employee

Thank you

You can try using

LOOKUP(Employee ID,Employee,Employee ID,Signature)

In the employee table, mark both the name and signature columns as label.

See also:

Thank you very much for your reply.
In this form I choose two employees with ENUM
To the Crew Officer with SELECT (EMPLOYEE [EMPLOYEE], TRUE) and to the crew assistant with SELECT (EMPLOYEE [EMPLOYEE],
[STAFF OFFICER] <> [_THISROW]. [STAFF ASSISTANT], TRUE)

I don’t know how to show the signatures

1 Like

Then this earlier suggestion is a good one:

See also:

1 Like

There is a correction in this:

LOOKUP([_thisrow].[Employee ID],Employee,Employee ID,Signature)

This works.

Thank you very much Rifad!
I can’t get it to work!
I need to bring the signature of the selected employee in the “crew officer” field in the “crew official signature” field

1 Like

You can set the column as signature and add intial value as above mentioned expression.

Rifad, when I enter the formula it gives me this error

You should change the Column type ENUM and set as REF column base type and select table EMPLEADO Table.

Then change the formula to-

LOOKUP([_THISROW].[OFFICIAL DE CUADRILLA],EMPLEADO,ID EMPLEADO,FIRMA ELECTRONICA])

This message appear

I find it difficult to understand the relationship between both tables

For Column OFFICIAL DE CUADRILLA
Column Type: ENUM
Base type: Ref
Source Table: Empleado

Suggested values or Valid if put this expression- EMPLEADO[ID EMPLEADO]

You should put the initial value formula

in signature column

image


Signature as image type and signature
image

employee table structure
image

What is the column type for official de cuadrilla?

Did you do like this for OFFICIAL DE CUADRILLA ?

You’re GOD!!

It looks like what I’m looking for
image

Thank you so very much Rifad!!!

1 Like