>I have two free tables that I want to join in a view. TABLE1 has a CATALOG field that is 6 characters long (eg AE001H). TABLE2 has a CATALOG field that is 5 characters long (eg AE001).

*snip*

>In otherwords, I want the relationship between TABLE1 and TABLE2 to be based on SUBSTR(TABLE1.CATALOG,1,5)
>
>How do I accomplish this in the View Designer?

Just the way you suspect:

Type Field Name Criteria Value
INNER TABLE2.Catalog = SUBSTR(TABLE1.Catalog, 1, 5)

You could also use:

INNER TABLE2.Catalog = LEFT(TABLE1.Catalog, 5)

HTH,
Paul M.