Help! Reference qualifier to show only with 5 digit numbers

[Jet R]

Hi! 

We have a custom field in the Department Tablen called "department id"  where in the data contains 5- 7 digit numbers. 

Now in the record producer field we only want to show the records with only 6 digits.  How can I achieve that? Thanks

Eg. Let say in the table below we only need to show in the record producer field the records Accounting and IT. 

Department Name	Department ID
HR	01203
Accounting	123456
Fleet	0234858
IT	033332

[Allen Andreas]

Hi @Jet R 

Thanks for marking my reply as Helpful.

If it ends up guiding you Correctly, please also mark it as Correct.

Thanks and take care! 🙂