Reduce VL items by left characters

[Corey-Troy]

I have a relationship set up between tables 1 and 2, whereby a value list is populated by records from table 2.

All the value list items are in a Text format such as:

ST-***-###.

the astrixes are always 3 letters, and the Hash's are always numbers.

I am trying to populate the value list with ONLY items that start with say: ST-VUL-###, but have been unable to do this.

The list needs to only list those records that have those 7 characters(including hyphens) and not ALL the records.

How can this be achieved?

[comment]

Try defining a calculation field (result is text) in the values table =

Case ( Middle ( Value ; 4 ; 3 ) = "VUL" ; Value )

Set the value list to use this field instead of Value.

BTW, it would probably be better to have a separate field for each of the 3 components of Value.

[Corey-Troy]

Perfect.

Simple when one is shown how.