Address info on a PDF form....
Forgive the complete n00b question.
I have been tasked with creating a FMPro database solution to allow several rental properties to fill out IRS form 1095 C (http://www.irs.gov/pub/irs-pdf/f1095c.pdf)
There al 11 properties, what I want to do is have a pull down menu on the "Name Of Employer" field and them select their property name and it fills in the address, EIN and contact phone number.
I have an excel spread sheet with that info that I turned into a table, but can not for the life of me figure out how to get it to work.
I also have a table with employee names that will later need to be related, so when they select their property name, it creates records of all their employees...
Thanks in advance