Hello community,
I am trying to create an app that records the entry and exit of visitors in a building. At the entrance there is a tablet that scans some id of the visitor and registers the entrance, at the exit the user scans his id again and the app registers the exit.
I have three tables: buildings, visitors, entrances.
The diagram should look like this:
at the entrance:
Now, with part 1) I have no problems, but it is part 2) that puts me in crisis because I donโt know how to implement the โlook in the access table and update the record to write the exit timeโ.
Can anyone give me some idea or indication?
I think you should use the following action:
(I mean the โData: execute an action of a set of rowsโ action)
Even if you only want the action to be done on one record, this is the one to use.
The โsearchingโ for the records to act upon is done with the โReferenced Rowsโ part of the action.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |