Newbies SPG Posted April 4, 2006 Newbies Share Posted April 4, 2006 Hi guys, I'm having a problem with a search request. One of the fields I want to search for is formatted as a radio button field (with value list: nt1, nt2, nt3) so you can select only 1 value. In my search I want to use a global with the same value list BUT formatted as a checkbox field. My idea is that you can select for example nt1 and nt3 so you will get all the records with the values nt1 OR nt3. How can I achive this functionality? I was thinking about getting one selected value from the global (checkbox formatted) fiels at a time and use that in new searches with omit records afterwards. But how can I get the values from the global field? I need some hints because my scripting skills are not yet that well developed... Link to comment Share on other sites More sharing options...
comment Posted April 4, 2006 Share Posted April 4, 2006 Try something along these lines: Enter Find Mode [ ] If [ ValueCount ( Table::gCheckbox ) ] Loop Set Field [ Table::Radiofield; MiddleValues ( Table::gCheckbox ; Get ( RecordID ) ; 1 ) ] Exit Loop If [ Get ( RequestCount ) ≥ ValueCount ( Table::gCheckbox ) ] New Record/Request End Loop End If Link to comment Share on other sites More sharing options...
Newbies SPG Posted April 4, 2006 Author Newbies Share Posted April 4, 2006 Thnx a million!! That's the solution :D Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6736 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