Lookup for two columns in data verse table
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 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
