Restrict What Shows in List Box

[Anonymous]

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

[Anonymous]

Hi,

Try this in calculated expression of field in list box:

=if(Supplier<>'C', Supplier)

Marc.

[Anonymous]

I've now got 2 columns, one with all suppliers and the other with dashes where the supplier type = C

[ashfaq_haseeb · Accepted solution]

Hi,

Check this.

Regards

ASHFAQ

[Anonymous]

Hi,

Check list boxes and table charts from attached file.

Hope it helps.

Marc.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Adian,

Please fins attached in my last post.

Marc.

[ashfaq_haseeb]

HI,

Are both of them connected?

If yes then it should work.

Can you post sample data.

Regards

ASHFAQ