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

[mmoossen]

Hi,

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 b…

Not sure why this topic was closed, without given me a chance to reply.
Even marking a reply as a solution, when it is not.

When using “limit the selection by a view” the view can not have parameters and need to be fixed up-front.

What I need is to filter the items to select depending from the row I am adding items to.

Any ideas?

many thanks
Michael

[cdb]

Sorry, but I don’t get your point.

• Limit to a view is the only way to limit the selection of a linked record.
• Filters support parameters. Please have a closer look.

[mmoossen]

I am giving it one more last chance:

I have a table Race:

And I have a table Runners:

I can configure ONE view in Race to restrict the Runners selection:

When selecting then Runners for Race “Race” (for runners with category U17), everything is as expected: I can select U17 runners (and only U17 runners) for the U17 race:

BUT when selecting Runners for Race “Race A” of category U15, I get the list of U17 runners, and not U15 Runners:

I want to select Runners for Race “Race A” of category U15 out the list of all U15 runners, not from all runners, and not from U17 runners.

The Question is again:
Is there a way to dynamically restrict the selection of Runners based on the value of the Category of the Race where the Runners are selected for?

Many thanks
Michael

[bennhatton]

Hi Michael, you’re right, unfortunately I don’t think there is currently any possibility of create such a dynamic filter in linked records…
One solution which I’m not really happy with could be the following: instead of having one single Runners column in your Race table, you could create three columns, each linked to the Runners’ table: U13 runners, U15 runners and U17 runners. For each column, you can create the corresponding view in your Runners table. This is really not perfect, as your use case is probably simplified, so maintaining such a system with more than 5 or 6 categories will be quite painful…

Bests,
Benjamin