AnsweredAssumed Answered

Auto fill fields based on dropdown selection

Question asked by MMCDSMP on Jun 16, 2017
Latest reply on Jun 16, 2017 by MMCDSMP

I have a table called "Events Detailed" with a field named 'Venue' with a dropdown list generated from a second table called "Contacts 2", with a field named 'Company' that does generate properly. My question is, how can I have all the other related fields in Events Detailed to auto-populate based on my dropdown choice in 'Venue'? That is, I would like the address, phone number, contact name... garbed from "Contacts 2" to auto fill in "Events Detailed" based on my 'Venue' field choice.

My head hurts trying to make it work, I only work in FileMaker once a year! Any assistance would be greatly appreciated Relationships.jpg

Outcomes