Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me with the attched file.
Thanks a lot.
Use "<Expression>" as the listbox field and define it as
=if([left([Product Long Description],3='AMC', [Product Long Description])
-Rob
If i have understood right, may be you can try something:
=If([Level Desc 4]='Atlanta - Georgia', WildMatch([Product Long Description], 'AMC*'), [Product Long Description])
Note: be careful of 'Atlanta - Geogia' string, i am not sure if i wrote right.
Edit: Corrected the brace was missing