Filtering out non-related values? (Showing only related values)

[EmorejDoingApps]

I'm new so bear with me.

I'm currently trying to create an application that holds two schemas one called 'Personnel' and one called 'Activities'. My goal is to track when a personnel has participated in an activity. Within the app, I've successfully been able to display the 'Personnel' involved in an activity which shows their name in an editable EnumList.

What I want to achieve is able to see the activities the Personnel have taken part in. With my current implementation, all activities are being shown on every Personnel and I just want those that the said personnel has participated to show when I'm looking at their details.

MORE INFO:
My 'Activities' schema has a column "Participants" of type EnumList which is of base type 'Ref' that refers to the 'Personnel' schema. This allows me to select the personnel I want that are involved in the activity. In the 'Personnel' schema I've added a virtual column of type 'List' which is of type 'Ref' which has a AppFormula of '=Activities[Activity]". This displays in the personnel details as a list of activities but it displays all activities instead of just the ones that the personnel has taken part in.

tl;dr new, need to display activities that only the personnel is taking part in

[Joseph_Seddik]

This is a many-to-many relation for which you need a third table to maintain it. Please read these guides:

Data: The Essentials - Many to Many Relationship
Relational Database Design
Basics of Database Modeling | Tutorial | Datanamic

[EmorejDoingApps]

Cool, I'll check it out. I'm probably rushing into things too quickly. I'm used to working with C#, so maybe the way I'm thinking is different.

[Joseph_Seddik]

Think SQL, without writing SQL 🙂