Partial Filter

Business Central/NAV User Forum
1

Good Morning,

I have a custom form that has been created. In the header section of the form, I have a textbox that when I click it, I am wanting it to populate a certain number of customer numbers from the customer table. More specifically the ones starting with Z.

In the table relation property, I have the following.

Customer.No. WHERE (No.=FILTER(Z*))

When I use the textbox, all of the customer table’s information appears and doesn’t filter the number at all. Does the filter option in Navision have the ability to do this, or should I hardcord the loopup trigger?

Thank you in advance for your assistance.

Chris.

2

Something that i noticed as a side note is that i can filter on a custom field that was created. Is there rules about not being able to filter on primary keys or something along those lines?

Chris.