- I created a table named "onboarding employee"
- I made a column name "Sector name " and the type is choices, which are (Production sector, Support sector, ...)
- I created another table named "All Jobs", this table has two columns "Sector name" and "Job title" and each sector has some job titles like the below photo
- Jobs table
- I created a new field in the "onboarding employee table " named "Job title "
My request is when I select a sector from the "sector name field" like the production sector
and then when I press on "the Job title field", it shows me only the jobs related to the production sector what can I make this?
Thanks in advance