Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 3 types of suppliers (A, B, & C). I have a tab in an application where I only want to see information relating to supplier types A & B which I have done with set analysis. However I have a list box of supplier names which shows all the suppliers regardless of the type. How can I restrict it to show only types A & B?
Thanks
Hi,
Try this in calculated expression of field in list box:
=if(Supplier<>'C', Supplier)
Marc.
I've now got 2 columns, one with all suppliers and the other with dashes where the supplier type = C
Hi,
Check this.
Regards
ASHFAQ
Hi,
Check list boxes and table charts from attached file.
Hope it helps.
Marc.
This doesn't quite work as I want to restrict the list of [Suppliers] by the field [Supplier Type]
If I use
if ( [Supplier Type] = 'C' , Supplier )
then I still get all the suppliers. Am I missing something?
Thanks
This doesn't quite work as I want to restrict the list of [Suppliers] by the field [Supplier Type]
If I use
if ( [Supplier Type] = 'C' , Supplier )
then I still get all the suppliers. Am I missing something?
Thanks
Adian,
Please fins attached in my last post.
Marc.
HI,
Are both of them connected?
If yes then it should work.
Can you post sample data.
Regards
ASHFAQ