How can the query results include null if it's a required field on the front end?

Because the constraint is FK,int,null this means that null are allowed. When you change this to FK,int, not null then the null is not allowed.

---

Please Vote as Helpful if an answer is helpful and/or Please mark Proposed as Answer or Mark As Answer when question is answered