I am racking my brain trying to figure out how to get this to work. I can do it no problem in excel but being a newbie to Filemaker, not so much,. I need to have a price auto populate for a product based on a selected item in a drop down menu. If you select any of the items under the category section of the drop down, i need the amount field to populate the price based on some sort of spreadsheet or database where i designate the price of each item. Please help!