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

User Talk Columns
1

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

2

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

3

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.

4

Here i go again:

Category Table

image
image814×138 5.8 KB

Runner Table
image
Race Table (even simpler design, without “race runners” table)
image
image1241×508 17.7 KB

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

5

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.

6

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