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

    Imported records sometimes import 0

    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?