Cross Product
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...
Forum Discussion
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.
Okay,
I have 5 Tables
1. Employee
2. Training
3. Group
4. Event
5. Employee Training Map
Parent Child
Employee Employee Training Map
Training Employee Training Map
Event Employee Training Map
Group Training
Event Group
I would like to be able to create an Event and select a Group and a number of employees. Then I would like to create a record for each Training and Employee that I have selected in the Employee Training Map.
Example
Before
Training Group Employee Event Employee Training Map
T1 G1 G1 E1
T2 G1 G2 E2
T3 G2 E3
Create an Event:
Event
G1 E1 E2
Quickbase will automatically create records in Employee Training Map
After
Training Group Employee Event Employee Training Map
T1 G1 G1 E1 G1 E1 E2 T1 E1
T2 G1 G2 E2 T1 E2
T3 G2 E3 T2 E1
T2 E2
I have 5 Tables
1. Employee
2. Training
3. Group
4. Event
5. Employee Training Map
Parent Child
Employee Employee Training Map
Training Employee Training Map
Event Employee Training Map
Group Training
Event Group
I would like to be able to create an Event and select a Group and a number of employees. Then I would like to create a record for each Training and Employee that I have selected in the Employee Training Map.
Example
Before
Training Group Employee Event Employee Training Map
T1 G1 G1 E1
T2 G1 G2 E2
T3 G2 E3
Create an Event:
Event
G1 E1 E2
Quickbase will automatically create records in Employee Training Map
After
Training Group Employee Event Employee Training Map
T1 G1 G1 E1 G1 E1 E2 T1 E1
T2 G1 G2 E2 T1 E2
T3 G2 E3 T2 E1
T2 E2