Filter Linked Fields on Condition


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?


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.