Filter Linked Fields on Condition

#1

I have been searching everywhere for a way to do this, but I have a table, named Categories. It is linked to a table named Bonuses. What I want to do is in my main form (and table) filter the bonuses available based on the Category selected. Is this possible?

#2

In the Forms, you can limit the selectable records to a View (the same for the Linked Record field type), you can’t do conditional logic, ie select a Category, and dynamically load the corresponding Bonusses.