Hello everyone,
I'm working on a project that would register workers as they come to work and go home when they are done. The output would be a simple report showing how many hours (total) has a worker spent inside the company.
I made their ID cards with unique bar codes, and made a main table and filled employees data in as follows:
FIELDS, table 1
baza_id - autonumber
sifra - text (their bar code in numbers - example: 01-000105)
ime - name
prezime - lastname
Now, I made another table which should keep track of employees date/time of entering the company and date/time when they leave.
FIELDS, table 2
ulaz_izlaz_ID - autonumber
baza_ID - number (relationship 1 to many, left is table 1, right is table 2)
datum_dolaska - arival date time
datum_odlaska - departure date time
When a worker scans his ID card via simple laser bar code reader, (the main form finds a record based on that unique bar code id - i.e. 01-000105, and subform displays the fields of the table 2 as datasheet.
The problem/question is:
How to write date/time to the related field in subform (table 2) when the bar code is read, and next time it's read, write date/time when they leave the company.
The scanner and computer will be at the front gate of the company.
Looking forward to any hints or help...
Best regards
I'm working on a project that would register workers as they come to work and go home when they are done. The output would be a simple report showing how many hours (total) has a worker spent inside the company.
I made their ID cards with unique bar codes, and made a main table and filled employees data in as follows:
FIELDS, table 1
baza_id - autonumber
sifra - text (their bar code in numbers - example: 01-000105)
ime - name
prezime - lastname
Now, I made another table which should keep track of employees date/time of entering the company and date/time when they leave.
FIELDS, table 2
ulaz_izlaz_ID - autonumber
baza_ID - number (relationship 1 to many, left is table 1, right is table 2)
datum_dolaska - arival date time
datum_odlaska - departure date time
When a worker scans his ID card via simple laser bar code reader, (the main form finds a record based on that unique bar code id - i.e. 01-000105, and subform displays the fields of the table 2 as datasheet.
The problem/question is:
How to write date/time to the related field in subform (table 2) when the bar code is read, and next time it's read, write date/time when they leave the company.
The scanner and computer will be at the front gate of the company.
Looking forward to any hints or help...
Best regards
Attachments
Last edited:
