Hi, I have a table for trainingexercises. In this table I have a referencelist with exercises I want to do. Now I want to show these exercices. How can we do that? Exercises linking to that training won’t work.
Ok… the list of exercises is generic, right?
I mean, in the Exercises list you create an exercise called “Jogging”.
Then at Training Exercises you create a record called for a date and trainers and select WHICH exercises will happen that day. Like jogging.
But for another date, you may select JOGGING again, right? The same exercise.
The linking you are thinking of is for 1-n relationships.
1 Training Session has multiple exercises. But those exercises created there belong “exclusively” for that Session and can´t be selected by other sessions. Meaning, for Session 2 you can´t re-select that same “jogging”.
Have you used SELECT BY in the Exercises Table Widget??
Consider my screenshot the same as your but simplified. Sessions in the top (Session Number and Exercises), with a list of references.
Then bottom table is exercises table, with exercise name and details column, full of gibberish for testing.
Notice I have the Exercicios Widget selected. Then at the Creator Panel on the right, Table Tab> Widget Subtab, click to alter/change widget.
You go to the same window as when you create a new widget.
Use the SELECT BY dropdown and select your main table. That way, the exercises widget KNOWS what record is selected in your main table, and FILTERS the exercises widget by that record’s references.
ps: thanks for Floor Jansen.
Thanks, you are correct. Each training have multiple exercises and that exercise will be done on other trainings aswell but never 2 times in the same training. It works now, the problem was that I had a filter of “today” but the timeslot made it not select that filter (when I use select by). Anyway, it works like I want to. Thanks for your help. Lol, Floor is not my child but damn what a voice she has. Did you hear her singing “the phantom of the opera”? https://www.youtube.com/watch?v=v_tlVUZ7mEk
I listen Nightwish since 1998. And yeah, I have been following their explosion on Youtube “reaction” videos since some 4 years ago (or even more?) including her Best Zangers participation…I meant thanks Netherlands for Floor haha.