Restrict selection of items in columns of type link to other records

Hi,

I have a similar requirement to this (but it is not the same, also please keep reading):

I have a table with “age categories”, for instance U15, U17 and so on.
Then i have the table “races” with a name and category, for instance: night run U15
And i have the table “runners” with name, date of birth, age, and age category.
Then I have a table “race runners” to connect runners to races.
When having a race with category U15, I want to select only runners with category U15.

what is the best way to achieve that?

many thanks
Michael

other way to think about it:
to select the view for the selection dynamically depending on other columns in the row.

Please use this script and then post the output here.

Then explain what you already tried to achieve your goal and why it did not work.

Here i go again:

Category Table


Runner Table
image
Race Table (even simpler design, without “race runners” table)

What i need is to restrict the selection view to the runners with the same category than the category of the race.
If i add runners to race A i only want to see runners of category U15 when selecting them, just to have a better chance to find the right one among thousands of runners.

Is that possible?

Many thanks
Michael

You can reduce the possible selection of a link column by „limit the selection by a view“.

Think about how to build the right views, then you can reach your goal.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.