Problems with Insert on Table from Form

carioka
Member Posts: 20
Hello.
7000002 in the table in the Account No, I gave it to me bring in OnValidate name from Account No. When you insert the data from the table works fine, but when inserted in a Form not working and not running for Onvalidate the Talba.
7000002 in the table in the Account No, I gave it to me bring in OnValidate name from Account No. When you insert the data from the table works fine, but when inserted in a Form not working and not running for Onvalidate the Talba.
0
Comments
-
Just to clarify..
You have a table
It has the field account no.
When you enter the account no. you want it to pull up the name.
you say it works when you enter the account no directly into the table but thru a form the name is not appearing.
You feel the Onvalidate trigger on the table isn't being triggered when you enter data using a form.
Is this what you're asking?
What code you you have Onvalidate of the account no on the table?
What code you you have Onvalidate of the account no on the Form?0 -
Savatage wrote:Just to clarify..
You have a table
It has the field account no.
When you enter the account no. you want it to pull up the name.
you say it works when you enter the account no directly into the table but thru a form the name is not appearing.
You feel the Onvalidate trigger on the table isn't being triggered when you enter data using a form.
Is this what you're asking?
What code you you have Onvalidate of the account no on the table?
What code you you have Onvalidate of the account no on the Form?
Sorry but my english is very very very very bad :P0 -
Savatage wrote:What code you you have Onvalidate of the account no on the table?
What code you you have Onvalidate of the account no on the Form?
a filter won't refresh another field. is your code similar to below? the form shouldn't be effecting the code unless something else is going on. Perhaps theis "filter" you're referring to is set on the first line only? Or perhaps you're not leaving the field to complete the validation. Do you have a currform.update command on your form?
OnValidate of account no (of your new table)
if customer.get("new table"."account no.") then
"new table".name := customer.name;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