I have two tables: one called companies and one called candidates. I'm creating a form for candidates to fill out which will add them to the candidate table. One of the questions on the form is "where do you live?". I want to match them with companies that are in their same city, so I want the company locations I have in my companies table to be the options for the "where do you live" list in the candidate form. Is there a way to sync these up? I tried linking the record, but I get a message saying "this is read only and won't appear on the form".
Ideally I want new locations to be automatically added to the candidate form when I add a new company with a new location.