How not to show a value in ref dropdown based on a condition?

[akhilnadhpc]

My Table Structure 

Expense Table

• Accounts - Ref column to accounts table

Accounts Table

• Accounts Name - key - text
• Type - Enum 

In the default form generated for Expense Table, I wanted only to display accounts whose type is not "Deposit Account".

What I did

In the  Data Validity section on "Valid If" condition of column Expense[Accounts ] I added  the following expression  [Accounts].[type] <> "Deposit Account". Which shows and invalid error if I select an Account of type "Deposit Accounts". 

But I do not want to see such an account even in the dropdown list. I wanted to keep the column type of accounts to "Ref" as I have related records 

[Joseph_Seddik]

Instead, use this expression:

FILTER("Accounts", NOT("Deposit Account" = [Type]))