How to remove the unwanted values from reference field.

[VIKAS MISHRA]

I have a project table where in the project form i can see 20 different "IO number" field. where people can add IO different IO number in different fields as much as they want. 

so whenever somebody add any IO number is any of the field this creates one IO record which gets saved in a separate IO number field. 

Now we have a scenario where some time people add incorrect IO number in any of the 20 fields in that case we have to manually remove or replace that IO number in project form. but the issue is that once we add any incorrect io number and later deletes that but that IO number still shows in the reference field to select while adding new timesheet. 

Hence we want those IO number which is currently added to that project record that should only be visible in reference field "IO number" to be selected. 

I can see the field "IO number" is having a Reference qualifier , please suggest what should i add here so that only current IO number would be visible to select.

Refercence qual below

javascript:"u_io_value!=No IO Required^ORu_io_value=NULL^u_io_value!=IO Pending^ORu_io_value=NULL^u_io_value!=Not Applicable^ORu_io_value=NULL^u_io_value!=IO Required^ORu_io_value=NULL^u_io_value!=No Internal Order Created^ORu_io_value=NULL^u_io_value!=No IO Available^ORu_io_value=NULL^u_project_number="+current.task+"^ORu_project_number="+current.top_task

[Ankur Bawiskar]

@VIKAS MISHRA 

sorry your question is not clear.

you have 20 fields to hold IO number?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[VIKAS MISHRA]

You can see in the below screenshot that its an project table record where i have 20 different IO number fields , where we can add different IO in different field.

Whenever we add any IO number in any such field here that number gets visible in another table's field "IO number" which is a reference but when we remove that IO number from this project fields then that IO no. should not be visible in that another table's field becuase that is removed from the project.

but that always gets visible which i want to hide.

[Ankur Bawiskar]

@VIKAS MISHRA 

so user will enter those 20 string fields

In order to remove it from other table are you querying this record and getting all the IO numbers from all the fields? if any field is empty then it should work fine

the field on which reference qualifier is applied is on which table? how does it link with the project record?

If my response helped please mark it correct and close the thread so that it benefits future readers.