The Missing Man Posted January 4, 2015 Share Posted January 4, 2015 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 More sharing options...
comment Posted January 4, 2015 Share Posted January 4, 2015 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 More sharing options...
LaRetta Posted January 4, 2015 Share Posted January 4, 2015 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 More sharing options...
Recommended Posts
This topic is 3400 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 accountSign in
Already have an account? Sign in here.
Sign In Now