Hi
I have a list of business divisions (business divisions table) within an organization like, 'Large Projects', 'Innovation', 'Small Projects', 'Government Projects' etc.
There is a employee master (employees table) where in each employee is mapped against a business division. One division can have multiple employees linked
There is a need to create new project(projects table) for a division and select an employee for the project. While selecting the employee (a linked field in projects table pointing to employees), is there any way to restrict the employees that are belonging to the business division selected (a linked field in projects table pointing to business divisions table)
If there are any alternates please suggest
Thanks
Sri