Auto fill Address/City of various Customers
I am new to FM and am stuck on auto filling out fields. I know what I'm trying to do is possible, just don't know how.
Let's say I have a list of Companies, CompanyA, CompanyB, and CompanyC.
I have in my layout Company NAME: ADDRESS: CITY: STATE: ZIP:
I want a drop down from Company NAME, Select that company, and have the Address, City, State and Zip fill in by itself.
Do I need a table for each company then relate them somehow? I've played with it but can't get it.
Can someone walk me through this? Thanks!