Updating multiple related tables via form/subform

[Sharkman1885]

Your changes work perfectly! Unknown sex will stay null value so the query will always include unknown sex. The mixing of the data was most likely from a bad join or relationship that I had. Thank you again for the normalization.

Ill have to go back and fix my original database and make sure everything works (it should) then Ill start working on how to update. I will post a separate thread when I am ready to do that. Thank you again!