AnsweredAssumed Answered

Text value interpreted as number by error

Question asked by CrimesTechno on Sep 16, 2013
Latest reply on Sep 17, 2013 by philmodjunk

Summary

Text value interpreted as number by error

Product

FileMaker Pro

Version

12.0v4

Operating system version

10.8

Description of the issue

A text field and/or calculation of text that contains 9 or more digits will be interpreted as a number format when using a value list and popup menu.

Steps to reproduce the problem

1. New DB.
2. Create table A
3. Create a number field "idA" auto enter serial.
4. Create a text field "textA"
5. Create table B
6. Create a number field "idB" auto enter serial.
7. Create a number field "link_ID_A"
8. Create a value list "list_text_A", values from field : "table A"
- Value first field "idA"
- Also display value second field "textA"
- Include all values
- Show only from second field
9. Create a relationship between idA and link_ID_A
10. On the layout of Table B, select "link_ID_A" and make it a popup menu, values from "list_text_A".
11. In "table A" create a new record and enter in  text field "textA" : 'test12345678'
12. In "table A" create a new record and enter in  text field "textA" : 'test123456789'
13. In "table B" create a new record and select for number field "link_ID_A" : 'test12345678'
14. In "table B" create a new record and number field "link_ID_A" : 'test123456789'

Expected result

Second record of "table B" to show the data as 'test123456789' just like the first record shows 'test12345678'

Actual result

Will show a number representation of  'test123456789' in the form of an exponent.

Exact text of any error message(s) that appear

- NONE -

Configuration information

Tried with local and remote (Filemaker server 12) DB

Workaround

Change the field type of "link_ID_A" to text

Screen_Shot_2013-09-16_at_1.43.30_PM.png

Outcomes