Limit drop-down connection fields to specific records
If you'd like to filter a connection field to only show particular records- for instance, to only show records which are active- this can be done in the filter tab of the field.
Let's start by opening any form which contains a connection field.
Next we'll select the connection field we want to filter.
In the new window, click on the Filter Record tab and press the Add New Rule button
Add the criteria for which records should be enabled in the form and click update.