Finding Unique Records

[Jarvis]

Is there a way to extract a list of unique values from all records.

I am trying to produce a list of vendor names from checkbook entries. Some of these vendors receive just one check during the year and some receive several.

I want a simple list of everybody who received a check, without regard to how many checks they received.

How would you perform a find that just displayed one value for each vendor?

Any ideas?

Jarvis

[Raybaudi]

Hi

how about a list coming from the contents of that field, showing only related values

&

a filtered relationship ?

[Jarvis]

Daniele,

Thank you for your response.

Generating a list from the the values in that field will help me populate a a new record, but what I am really looking for is a report that lists all the unique values.

What I want is something that produces a result like you would get with a PERFORM FIND script. Instead of finding all the records that share a common value I want to produce a report that generates as many records as there are unique values for a specific field.

This is all happening on a columnar list type layout.

Any more ideas?

Jarvis

[BobWeaver]

If the purpose it to produce a printed report, then you can simply set up a summary report. Create a list style report. In layout mode double click on the body part tab and then change it from a body part to a sub-summary part (sorted by vendor). Place your vendor fields in this sub-summary part and any summary fields that you want to include (such as count of vendor, or total of amount paid, etc.).

Then just sort by vendor, and print. The drawback is that if you want to view it on the screen you have to switch to preview mode.

[Jarvis]

Thanks Bob!

This is an FM weakspot, in my opinion.

There is a lot of information available in Preview Mode that I think should be available while you have a record open.

Maybe they will get there.

Hopefully at the same time they will include native charting capabilities (such as excel has had for a decade).

Jarvis