What's the best method for approaching the following scenario?
I have imported data from an SQL database into a new FMP database and I am stuck on my next step. I've seen lots of different approaches and have been going through videos on Lynda.com but am still coming up short.
I have 60 fields in my table with 80k+ asset records and I'm trying to create a list of the 6k products in those records. Here's a small example:
|Nikon D3||6 Mpx Nikon Camera||Nikon||ND3-005|
|Nikon D3||6 Mpx Nikon Camera||Nikon||ND3-007|
|Samsung S3||Samsung Galaxy S3 Phone||Samsung||S3-002|
|Kindle Fire||Amazon Kindle Fire Tablet||Amazon||KF-030|
|LG 6560 PK||LG 60" TV||LG||LG-102|
|Samsung S3||Samsung Galaxy S3 Phone||Samsung||S3-024|
I'm trying to generate a product list like this:
|Nikon D3||6 Mpx Nikon Camera||Nikon|
|Samsung S3||Samsung Galaxy S3 Phone||Samsung|
|Kindle Fire||Amazon Kindle Fire Tablet||Amazon|
|LG 6560 PK||LG 60" TV||LG|
I'm not creating the data in FMP otherwise this may be easier to wrap my head around. I've looked at self join tables, ExecuteSQL, aggregate functions, summary, sub-summary, etc. I am completely lost and have spent way too much time trying to figure out this seemingly simple task.
Maybe you can help...