Combining fields from 4 different files
I am using FileMakerPro 10.0v3 for MAC. I have created 4 different fp7 files, each containing unique fields with data about a unique account # (field 1 in each file). So, if I find records in one file, say field 2 is > 100,000, I need to get all data from the other three files that match the account #, field 1.
I am a newbie to databases and would appreciate any help you can be.