Hi, this may be an elementary question, but I don't have much experience
creating macos.

I have created a form with a combination of text fields, check boxes and
drop downs. To make it easier for the user, I want to create a macro so that
if they choose a location name, it automatically fills in the location
address, and phone numbers that are in different drop downs. But when I try
to record a macro, it won't let me pick from a drop down. Am I missing a set
here? I have read some previous entries on this site and it looks like I may
have to use programming language. If so, how do I do that and what is it?
Thanks in advance for the help.