AnsweredAssumed Answered

'Max' of text field doesn't work in related records

Question asked by barefootguru on Aug 3, 2012
Latest reply on Oct 3, 2012 by disabled_ntaylor

Summary

'Max' of text field doesn't work in related records

Product

FileMaker Pro

Version

11.0v4 and 12.0v2

Operating system version

OS X 10.8

Description of the issue

The manual for the 'max' function states 1. it works for text fields, and 2. it works over related records.

However from my testing I've found while 'max' works for text fields within the same record, numeric fields in related records, but not text fields in related records.

This would be consistent with the 'max' summary field which also can't process text fields.

Steps to reproduce the problem

table2 has:

'key' as numeric, field1 as numeric, field2 as text

first record:  key=1, field1=10, field2='a'
2nd record:  key=1, field1=11, field2='b'

table1 has:

key as numeric
max1=Max(table2::field1)  /* Result as number */
max2=Max(table2::field2)  /* Result as text */

one record with key=1

tables are related on 'key'

Expected result

max1 shows 11, max2 shows 'b'

Actual result

max1 shows 11, max2 shows nothing

Exact text of any error message(s) that appear

n/a

Configuration information

See also http://forums.filemaker.com/posts/2beb8259b4

Workaround

Don't try to use 'max' on text fields in related records!

Screen_Shot_2012-08-04_at_14.04.11.png

Outcomes