Filter ABC issue...

[sicSRT8]

I am using this currently but must be missing something because I am unable to replicate it for another use.

I want to be able to select an item based on what customer I have selected.Each job number has the customer initials in the beginning of it for example. Apple Pie is AP12345. So when I select AP from the initials drop down I wont see job numbers like AB or AC or AD etc.

Customer Initials

Job Number Selection

= Filter (Job Number; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" )

I then relate to on each table?

I have changed this over and over but missing something because it doesn't work.

[sicSRT8]

Never mind I figured it out.