Create your unique table by creating the field for product name. While you are at it, create the unique auto-enter FM serial number, something called ProductID. Set it as serial, increment by 1. On ProductName field go to validation tab and check it to 'validate always' and specify 'unique'.
Go to your table with the multiple products and show all records. Now go to your new table and perform an import, importing only the ProductName. Duplicate product names will not be imported - only one of each.
Thanks LaRetta. I just started using Filemaker, and am coming over from MS Access where you run a query to do this. Still getting my head around the diferences.. Thanks again, Bill