Hi guys,
I have just got FMP 8.5 on trial for a company project. I am looking to track incoming collections and have set up a DB to help this process.
What am I after
OK i have 3 fields User ID, User name, User Phone:
When i selct a user ID from the first drop down box(User ID) i want to auto populate the USer name and User phone?
I have set up a seperate table with User ID, Name and Phone whic i have information in but i can not figure how to like them together.
any help would be great.
Thanks in advance
Darren