Return value of the most used value in a field

[Blake Lucas]

Ok, Hi everyone...

 

I have a db with 80 records.  One field is for the "Manufacturer".

 

I want to have a field on a global db that will display the "Manufacturer" that has the most occurrences in the other database. Is there an easy way to pull that value?

 

I have looked at summary fields and a few calculations, but nothing seems to fit.  so any ideas would be grateful.

 

FMP 12

 

Thanks everyone.

 

Blake

 

[mr_vodka]

See here.

 

http://fmforums.com/forum/topic/88233-counting-instances-of-a-recurrence-in-a-field/?hl=executesql#entry405500

 

 

In your case you  since you just need 1, use GetValue to grab the first line instead of having to use LeftValues