Ref filter value not in data base

[lemonkung01]

i want to filter by ref such as 

Item ID, QRCode (REF of Item ID)

if Qrcode choose Ref of Item ID and save do not show that value in dropdown 

just Show value not in data

[WillowMobileSys · Accepted solution]

---

@lemonkung01 wrote:

i want to filter by ref such as 

Item ID, QRCode (REF of Item ID)

if Qrcode choose Ref of Item ID and save do not show that value in dropdown 

just Show value not in data

---

Ok, I am understanding that you want to adjust the dropdown list to remove list items that have already been selected by previous entries.  Since I don't know your data I'll have to give you a generic example expression:

SELECT(DropdownTable[Key Column], 
       OR(
          NOT(IN([Key Column], ThisTable[ThisColumn])), 
          [_THISROW].[ThisColumn] = [Key Column]
       )
)

You will need to replace the Table and column names with those from your app.

NOTE: the "[_THISROW].[ThisColumn] = [Key Column]" is necessary to ensure, when editing the row, that the current row's value is considered valid.

[lemonkung01]

Thank you 😍