Filtering Dropdown Selection List Prior To Searching

Hey Mark,

Currently, the filter field seems to primarily function as a search tool, which is useful, but I require pre-typing filtration.

Let's say in the related table, we have columns named 'Company Name' and 'Status'. Ideally, before a user starts typing, the dropdown list should already be filtered to display only items where the status is 'Active'.

For instance, let's consider a scenario with three records in the related table:

Company Name | Status
Amazon | Active
Google | Active
Apple | Inactive

If a user attempts to search for 'Apple', they shouldn't retrieve any results, and it shouldn't appear in the dropdown because it's marked as Inactive.

Deleting inactive items from the related table isn't feasible since we need to preserve historical data in archived records. Thus, when an item becomes 'Inactive', users shouldn't be able to select it in future records, but any archived record retaining that value should remain unchanged.

Do you have any suggestions on how to accomplish this?

With much gratitude,
Paden

Es werden keine Datei, kein Test und kein Einstiegspunkt genannt. Beginne damit, die TypeScript-Komponente zu finden, die das Dropdown-Menü für die verknüpfte Tabelle rendert, und verfolge, wie die Filterung vor und nach der Eingabe funktioniert; done sollte dafür sorgen, dass Active-Datensätze auswählbar bleiben, Inactive-Datensätze aus neuen Auswahlen ausgeschlossen werden und archivierte Werte erhalten bleiben.