More versatile lookups
I am new to FileMaker and when looking up values from another file, such as customers, I need to see more than two fields. Am I doing it wrong or is there a 3rd party function that can be used. What I need to do is look up a customer from the customers file but since I have many hundreds of them, I need to be flexible on searching for the correct one, selecting it and returning the data to the entry screen. What would be the proper way to accomplish this. Any help would be appreciated.