We have three lists in modern SharePoint:
- Employee: Used lookup on Industry column
- Database: Used lookup on Employee and Industry column
Question: How can I show only those employees which are belonged to specific company while adding new item in Database? Example: If I select CTS as company then only A employee should be visible in Employee column dropdown.
Note: Modern SharePoint does not support any external scripting file.