This is something that I have a fairly good understanding of in other database tools such as Sql, but do not know if Quickbase could handle. I am trying to create a training application that allows...
There may also be a native solution but it�s unclear to me if you are wanting to do a mathematical calculation and what your data structure is for parent and child relationships.
(1) Can you confirm that this is the ER Diagram for your tables?
(2) I don't understand what you are indicating by tabular information you have listed under the Before, Event, and After headings as the column headings appear to be tables names not field names. Can you clarify what the fields are?
(3) I get the impression you want to start on a form that creates and events and select a Group of Training and a set of Employees. A Group of Trainings can be selected with a lookup. But how do you propose to select a set of Employees?