Imported records sometimes import 0

Discussion created by cillion on Jan 16, 2017
Latest reply on Jan 17, 2017 by cillion


Iv just imported alot of data from a an access database. One field has a weird behavior: some records shows the value 0 in this field, but the most records get empty value.


In access this field is a foregn key of a related table called STATUS. And on the layout its a selectlist with this values (also in filemaker solution):

0 = "empty"

1 = active

2 = not active


But after importing there is some record that show "0" in this field, and I would like your input on how this could be? Or could not filemaker show "empty values" in a select list?