How to group sales type and link to Sales table

[hdemissie]

In my sales table I have 5 sales type 1-5, How can I group these sales type to Warehouse and Direct?  Sales Type 1 , 4, 5  group as Warehouse Sales type and 2 and 3 are Direct. When end user select Direct the result will be direct sales type only.

[#2]

Hi Richard,

Did this work out for you?

Matt

[hdemissie]

Sorry for the delay Matt. your solution worked perfect. Thank you so much.