Lookup for two columns in data verse table

Copper Contributor

Dears 

 

  •     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 tableJobs 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

0 Replies