So, my first question on this forum
I have a base with 2 tables: Table 1 deals with applications for following trainings. Table 2 has an overview of all personal details.
John | training 1 | formal (training) | man (lookup field from table 2)
Sara | training 2 | formal | woman
Eddy | training 3 | informal | man
John | training 4 | informal | man
John | man | training 1, training 4
Sara | woman | training 2
Eddy | man | training 3
Question: I want to know if (so yes/no or 1/0) John, Sara and Eddy followed (a) any formal trainings and (b) any informal trainings. No idea how to get this done.
Eg: 2 extra columns: “formal” and “informal” that states “yes” or “no” of “1” or “0”. I don’t need to know how many formal/informal trainings they did, just if they did any at all, but conditionalized on the factor formal vs informal.
Thank you in advance!