I would like to have two fields. The first field I would enter a numeric value, and the second field right next to it would auto-populate based on a spreadsheet value. For example, if I enter in part 12323, I want the second field to auto-populate the part based on matched values that I have on an excel spreadsheet. How can this be done effectively? Can I copy and paste the spreadsheet values into a filemaker table that the program wound then use?