Hey,
Hopefully you can understand my objective here, that is, to store data into this table called Computer Usage Log using a form.
A sample table of the original table I've created to store the data
LogID Logging_date ComputerID StudentID Check-in Check-out Reference Sheet 1 22/01/2020 1 3317890 08:00 AM 08:50 AM 1 2 22/01/2020 1 2191297 01:58 PM 02:52 PM 1
On the Form I've created will be storing the information on the corresponding fields above, but as simple as it sounds it still has some complications.
So far I've managed to let the form display all records that are existing at the time, but I can't add any new records. I created a relationship which I'm taking advantage of in the form, where from the StudentID, when data is being entered, the Student Name Field populates automatically from another table, which corresponds to that StudentID.
Anyway I can accomplish this objective?
Attached are some screenshots of what I've done so far.
Attachment 40955Attachment 40956Attachment 40957Attachment 40958