It would be great to have the ability to have the facility to cascade / filter Select Fields - here’s a typical use case in CRM:
- Against an opportunity / deal you enter a company (from the Companies table)
- Once the company is entered the Contact field is now filtered to only show Contacts in the selected Company
Of course, if no company were entered it would be ideal to show all Contacts records in the dropdown.