How to auto-add a checkbox option to a form when a new record from a linked table is added

342 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.  

0 Replies 0