Using table for selected records

[Sam W]

In my file, I have a "parts" table that contains records for each part of a letter. Each part is named and is keyed to a part number for that component. The "component" table holds the finished component's name and key.

The "parts" table has fields for each letter part along with what page it is found in the finished component. For example, letter #13 has five parts: four of which (signature, salutation, etc) are on page 1 and one on page 2 (Offer).

In the past, I have built an excel file that has for each row, the name of the component (letter 13) and an appellation (letter Front). The next row has (letter 13) and its appellation (letter back).

I still must generate this spreadsheet and I have this info in my "parts" table. It seems to me that I should use this table, but at present, instead of two records/rows for (letter 13) with different appellations, I have five records/rows.

Is it a dynamically generated value list I'm looking for to make this excel data dump?

Sorry if this doesn't make sense, sam

[sbg2]

Its hard to decipher. How about two examples files? 1st file being a stripped down sample of your database file (complete with sample data) & the 2nd being how the same data should appear in your excel file.

[Sam W]

Yes, you are right.

Attached is a oversimplified, crude example. At this point I'm leaning toward using the "parts" table as it would have all the records needed. I just need a way to easily suppress the extra records so that each instance of a unique part would show up as a row in Excel.

If I use the get valuelist function, then how could that translate into rows into Excel?, sam

excel-diff.zip

[Sam W]

I'm racking my brain trying to figure out to get unique values into records that can be exported into Excel. Is this example inappropriate?

It seems that get valuelist can pull the unique records, but how can I extract them and make records of them?

thanx, sam

[sbg2]

Example attached.

1) created a field to hold all the exported fields data using a Tab between each field (it may appear as a square in defined calculation (ctrl+Tab).

2) created a global field to hold the Value list for Export

3) created a script to set the global field then export field contents.

* note: there may be a limit to the number of characters FM uses to validate a field as "unique".

excel-diff2.zip