hi I am not the best at Databases so please be kind...

I have been tasked with building a database to be used by nurses collecting certain information.

I have a form with 4 Tabs
Main Details, Employment Details, Episodes and Events.

In short One Employee can have many Episodes and Events.

What I am trying to do is if I have a record on the screen i.e. Joe Bloggs and I have the main...