Match and copy IDs from the other table

[carobernachea]

I have an access and exit control application.
In the INCOME database I have all the user information, with the ENTRY TIME.
In the DEPARTURES database, only the document number and the DEPARTURE TIME.

The idea is that when they fill out the departure form, search the entry form, and if the ID matches, record the departure time in the entry database.
Is this possible?

Thanks in advance

[Aurelien]

Hi @carobernachea

Yes it’ possible.

Can you please change the category of your post to Q&A instead? Tips & Tricks are for sharing tips to the Community. Thanks

To answer your question:

I suggest you use a dereference expression to catch the departure time. It will look like this:

[entryIDcolumnName].[departureTime]

For reference:

Dereference expressions - AppSheet Help