Relation with a Field that has multiple values

[Tissot]

Hi guys

I'm having a problem with an external DB via ODBC.

Within Filemaker you can relate a field with multiple values in it via a relation.

eg:

In the Child Table theres a field "Users" with the following content:

Record ID 1 = "343¶[color:red]391¶392"

Record ID 2 = "345¶385¶[color:red]391"

Record ID 3 = "332¶345¶[color:red]391"

¶ = simply a return

In the Parent theres a field "User" which has a value "[color:red]391".

What usually happens is the Parent record would show all 3 records but instead with ODBC none show up.

Has anyone experienced this?

Any help would be greatly appreciated.

Ron

[bcooney]

I've strictly book knowledge of ODBC/JDBC, but on p. 47 of the FM ODBC and JDBC Guide, it says:

"FileMaker supports repeating fields (array data types), but ODBC does not. FileMaker exports

repetitions to tab-delimited or comma-delimited files and separates each repetition with a group separator

(Unicode decimal value 29). Text columns separated with the group separator are concatenated. All other

data types return only the first repetition. "

Sounds like this fact applies to your situation. hth, Barbara

[Tissot]

Thanks Barbara.

What a shame. I've managed to solve it another way.