Scan a code barcode and fill in a text field ???

SPost29
Member Posts: 148
Hi,
I have a table called RGA Rejection Reason
with 2 fields
Code (10)
Description (30)
The code is printed on a sheet of paper as a barcode with the description beneath it.
I have an entry form with one control Rejection Reason
Can I have my user scan in the barcode (which is code) and have Rejection Reason description filled in by the description field from the table?
without having to capture and store the Code field
I also would like the user to be able to type in a random and should be rare text reason into the rejection reason field if they need to.
hope you can help
Thanks
steve
I have a table called RGA Rejection Reason
with 2 fields
Code (10)
Description (30)
The code is printed on a sheet of paper as a barcode with the description beneath it.
I have an entry form with one control Rejection Reason
Can I have my user scan in the barcode (which is code) and have Rejection Reason description filled in by the description field from the table?
without having to capture and store the Code field
I also would like the user to be able to type in a random and should be rare text reason into the rejection reason field if they need to.
hope you can help
Thanks
steve
0
Comments
-
i believe you can. you need textbox where nextcontrol is itself, so you cursor will not run anywhere.
then you can add code in afterinput() with thistable.description := "RGA Rejection Reason".description
so you dont store the "RGA Rejection Reason".code in thistable.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions