I have a table with companies listed. Some are clients and some are vendors (This is determined by radio buttons. Either you select client, vendor or both).

I want to create a value list that just show my vendors in a drop down list and I am currently stumped. Any help in sending me down the right direction would be appreciated.

Thanks in advance.

There are two ways you could accomplish this:

 

1.  Use a conditional value list, based on a relationship that makes only vendors related;

 

2. Define a calculation field =

Case ( not IsEmpty ( FilterValues ( "Vendor" ; CompanyType ) ) ; CompanyID )

and use this field as the basis of your value list instead of CompanyID.

This is determined by radio buttons. Either you select client, vendor or both.

 

As an aside, if you are using a radio button and you let users select both (which requires holding down shift to accomplish it) then it really suggests that you are using the incorrect control and it should be checkbox instead.  Just something to keep in mind for future.  :-)