I want a drop down list to show me all my Vendors from my Company Table.

Background:

In my company table I have a field called (Name) to list the name of companies and then one with check boxes (Choices_Client_Vendor) to identify if the name is a vendor or a client. Sometimes they can be both so this is why the check box.

To create the drop down list I created a new field called CompanyVendor in my Company Table based on the following Case:

Case (

Choices_Client_Vendor = "Vendor" ; Name;

Choices_Client_Vendor = "Client" & "Vendor" ; Name ; "" )

My value list shows me all my records that only list "Vendor" in the (Choices_Client_Vendor) field but will not show me the ones that have both "Client" and "Vendor" checked.

Am I going about this the right way or am I all backwards?

Any help appreciated.

Thanks in advance.

Case(

ValueCount ( FilterValues ( Choices_Client_Vendor ; "Vendor" ) ) ; Name

)

That did it! Thanks for your help.