*** Household *** HouseholdID (UniqueID) LocationID (UniqueID) ApplicantID (UniqueID) -> 1-1 to Persons *** HouseholdMembers *** HouseHoldID (UniqueID) -> HouseHold PersonId (UniqueID) -> Person RelationshipRoleID (UniqueID) ->RelationshipRole DateAddedToHousehold (DateTime)What I need is to obtain the single row from Household and pass in a PersonID. The PersonID may be found in household in the ApplicantID column but if not, then it would be found in the HouseholdMembers table and would give the HouseholdID value there to get the row from.