Updating Boolean Field in a Form
IrishGiri
Member Posts: 61
Hi all,
I have a form which shows the records from a table. Each record has a boolean tick box which the user currently has to click on to select the record for further processing. I would like a user to be able to select records from the form by <CTRL> and <SHIFT> clicking the records in a form he wants and automatically the boolean field for the selected records converts to its opposite value and I want the form to update instantaneously and show these changes. Can anybody help me out with how to code this (SETSELECTIONFILTER??)? In which trigger should I put the code? Any help would be very welcome!
Thanx
I have a form which shows the records from a table. Each record has a boolean tick box which the user currently has to click on to select the record for further processing. I would like a user to be able to select records from the form by <CTRL> and <SHIFT> clicking the records in a form he wants and automatically the boolean field for the selected records converts to its opposite value and I want the form to update instantaneously and show these changes. Can anybody help me out with how to code this (SETSELECTIONFILTER??)? In which trigger should I put the code? Any help would be very welcome!
Thanx
0
Comments
-
Setselectionfilter is your friend for this.
What I usualy do is add a function to a menuiten and use a shortcut key for this.
A user can then select a couple of records and press Fx.
Good luck.0 -
From on-line help for SETSELECTIONFILTER:Use this function to have the system note the records the user has selected on the form, mark those records in the table specified, and set the filter to "marked only".
it means that on the record variable you will pass as parameter will be set filter which select just the records marked on Rec (on Form) by user. After that you can perform for example MODIFYALL(MyCheckField,TRUE) to modify the records.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

