Add multiple time entries into record

[mitch75]

Hello, Happy New Year to you all

I have created a wee database for security officers to fill out incident reports. But I'm stuck at where the meat of the incident gets entered. Each event needs to be added with corresponding time eg
10:00hrs male climbed over fence
10:05hrs sharks with frickin laser beams deployed


10:10hrs body parts cleaned up.
What's the best way to get this info and store it? Thank in advance, Ray

[andy49]

Have you set up the tables yet.

Is each report (you gave three) linked to one incident? Or are all the "incidents" logged and treated as separate events.

To clarify once the male climbed over fence has been entered, do you want deployed sharks etc linked to this. So that you can see how the initial event was dealt with.


Sent from my iPhone using Tapatalk

[mitch75]

hi Andy,

Yeah man, i have a table set up and there is fields for Officer Name, Date, Incident Details etc - Yeah, each entry would be linked to the same incident - yeah, all time entries would be linked to the unique (Key) Incident Report Number and see how the event was dealt with man.

thanks m8

[andy49]

I'd use something like

Tbl1officer

Officerid (autonumber)
First name
Surname
Etc


Tbl2incident
IncidentId (primary)
OfficerId (FK Linked to tbl1)
Initial date
Incidentdescription

Tbl3

Idfollowup pk
IncidentId fk linked to tbl2
Followupdetails


So tbl1 is only officer details

Tbl2 is incident details (man climbed over fence)

Tbl3 is follow up incidents (sharks deployed, body parts cleared up)

Main form would hold officer and initial incident details

Sub form to show follow up details

You might wanna hold back until you get ideas from others as database set up isn't my speciality.





Sent from my iPhone using Tapatalk

[mitch75]

Hi m8,

Cool, thanks man - thats an idea i hadn't thought of - will have a play about and see where that takes me - cheers dude - \m/ >..< \m/

[andy49]

Happy to help


Sent from my iPhone using Tapatalk