It sounds like the relationship between the datasets is not established. What does it look like when you go to "Data" -> "Edit Relationships..." ?
As for 2 and 3: isnull() and zn() can help with the nulls.
no, the relationship is established. i set it up in the 'Edit Relationships' menu. i would not have been able to write the formula from above if the relationship was not established.