9 Replies Latest reply on Jan 17, 2017 2:24 AM by cillion

    Imported records sometimes import 0



      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?