cillion

Imported records sometimes import 0

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

Hi.

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?

Outcomes