Create a Column whose content type is 'lookup'. once we select Lookup we need to choose Listname and columnaname to loopup on.

Now I have List User with following data. I will choose lookup column as 'Name'.

Name Status

A 1

B 0

C 0

D 1

E 1



But I want that its should display Name whose status is '0' only in above lookup field.

Please help to create such type of custom lookup field or suggest any alternative to get field which contains filtered values from other list