Update a table with values from another

[gcor71]

After hours of struggle - I throw myself on the experience and knowledge of the community.

When a new row is added to Table 2 QEV_RESPONSE, I want to copy the value of [Stay on...] to Table 1 OSM_DATA_TRACKER[QEV Response].  FYI the new row is a Form response.  The source and target row can be identified by the [member_id] and [Unique Member ID] columns.

Table 1: OSM_DATA_TRACKER
[member_id] ,number, *key*
[QEV Response], Yes/No
[QEV_response_received], DateTime

Table 2: QEV_RESPONSE
[Unique Member ID], number
[Stay on the Waiting List to join Scouts?], Yes/No
[Timestamp], DateTime, *key*

I've tried a number of solutions, the latest of many being:

ANY( SELECT( QEV Responses[Unique Member ID], ( [_RowNumber] = SELECT( QEV Responses[_RowNumber], ([Unique Member ID] = [_THISROW].[member_id]) ) ) ) )

Can no longer see the wood for the trees.  Thanks in advance.

[Vincent_P · Accepted solution]

Hi

If I understand, QevResponse =

ANY(SELECT(QEV responses[Stay on the Waiting List to join Scouts ?],

  [TimeStamp]=MAXROW("QEV responses", "TimeStamp",([Unique Member ID]=[_THISROW].[member_id]))))

So OSM Data Tracker[Qev response] could be calculated column with this formula or used it as default value.

this formula looking for the greater (so the last) timestamp for this user.

[gcor71]

Perfect!  Thank you.