Jump to content

Unique Value List


The Missing Man
 Share

This topic is 2886 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.  :-)

Link to comment
Share on other sites

This topic is 2886 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.