Can I populate a foreign key from a drop-down list?
I'm am brand new to FileMaker, and have hit my first problem! I know it's a noob problem, but I haven't been able to form a good enough search term to find an answer...
I have two tables: Dies and Vendors. I would like to enter (from a drop-down list of all Vendors if possible) a vendor's name and have it populate the _fkVendorID field in my Dies table.
Both of these tables are imported from CSV files and will have to be related via human editing within FileMaker.
Thank you for any help!