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?
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |