Populating layout fields with drop down menu
I have two linked tables trails::trail_ID to obstacles::trail_ID (parent child, one trail many obstacles). Obstacles is a portal. I have a drop down field called trails::trail_Name which I want to be able to pick different trails from and then have the whole layout refresh with the appropriate records/info. I also wish to trigger a new record if someone enters a new trail name. I've tried and can"t seem to make this work. Any help would be appreciated.