April 4, 200619 yr Newbies 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...
April 4, 200619 yr 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
Create an account or sign in to comment