Incident Management Database

[mhikee]

Hello - I am starting my very first Access 2010 project today and I want to build an incident management db for my department from scratch. I would appreciate some guidance on how to accomplish certain tasks.
First problem I could not figure out:
I have an attendance tab on my form and I would like to have a checkbox when marked, that it would display the timestamp for a particular attendee. I would also like to capture the timestamp for each attendee on a database that would link with the incident ID.
So far I only have a form and 1 table which I called tbl_main.
I have attached a screenshot of my form so you can get an idea of what I'm trying to accomplish.
Can someone please point me on the right direction on how I can accomplish this?
Please do correct me if I have something stated incorrectly in my question and I apologize in advance.
Thanks!

Regards,
Mike

 

[spikepl]

Your form is rather uninteresting - the table is. But already now you should stop and assimilate the concept of database normalization - google it. Then you should be able to identify some shortcomings of your current design.

The issue is not just theoretical - if data is not normalized you'll suffer eternal PITA, in that development, updates, changes and maintenance are much more laborious than they should be.

 

[GinaWhipp]

Welcome to the Forum!

Hmm, we need to see the Tables, not the Form. Please post a screen shot of those.