Fetching wrong data

Hi,
I have a Condo management app where I have two Condos with the same Unit Number but located in different properties and belonging to different Mngt_companies. I am using "Fetch Record" to auto fill in details such as Mng_Company and others. When I select the Property and unit number, the wrong Mngt_Company is Fetched. I have deleted the record in my master units form and recreating it but nothing seems to fix my issue.

Thanks for your help.

this is the script I am using:

if(input.Unit_Number != "Select")
{
    Fetch = Units[Number == input.Unit_Number];
    Unit_Type=Fetch.Type;
    Unit_Size=Fetch.Size;
    Rate=Fetch.Rate;
    Mgmt_Company=Fetch.Mgmt_Company;
    Street=Fetch.Street;

}