Risk register table structure. (1 Viewer)

MickJav

AWF VIP
Local time
Today, 11:59
Joined
Nov 28, 2005
Messages
1,990
there could be multiple actions at different dates till the matter is closed out
Sounds like you will need a table inbetween the two tables that way you could add a new event type with a date of event if you don't want them to add dunplicate Actions you could use a combination key arrangement.

Tblincidentreporting
tblincidentsandActions
tblActions
 

HillTJ

Registered User.
Local time
Yesterday, 23:59
Joined
Apr 1, 2019
Messages
304
cabber, thanks. I've attached my latest database to post #40 of my "Trouble adapting Uncle Gizmos Checklist code." thread if you're interested to have a look. MickJav, I agree.
 

cabber

New member
Local time
Today, 11:59
Joined
Apr 19, 2020
Messages
7
HillTJ ,

I have found some example of incident reports see attached. Regarding actions you can use a query to make a subform and it would then be coded to be linked to the main form at all times.

I have not worked this out yet how it is done, maybe someone out there knows how
 

Attachments

HillTJ

Registered User.
Local time
Yesterday, 23:59
Joined
Apr 1, 2019
Messages
304
Cabber, thanks. I'll have a look at your reports & determi e what's best for me.
 

cabber

New member
Local time
Today, 11:59
Joined
Apr 19, 2020
Messages
7
HillTJ

I've attached a small example database which shows the Incident Form and Actions etc, as you can do this with only a few tables but use queries
 

Attachments

HillTJ

Registered User.
Local time
Yesterday, 23:59
Joined
Apr 1, 2019
Messages
304
cabber, thanks for your efforts. I'll have a look. Will let you know how I go.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom