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?