I have a simple 2 column excel spreadsheet with 56,000 line items. Column A contains "part numbers", Column B contains the associated supplier of those part numbers listed in column A. I imported this data into FileMaker. Created a great form, etc. BUT, I want to now be able to imput a part number into my part number field on my FileMaker form and have the associated supplier just automatically populate. Trying to figure this out for a week and just can't get it. HELP!!!