Create new record through filtered drop down
GoMaD
Member Posts: 313
Hello,
I've got the following situation:
we have a field with a table relation and this table relation is also filtered on an option type.
I'll explain through an example.
The Table relation of that field is to an Address Table with an extra filter on the Type field (Option field) to show only Addresses of the Terminal Type
Important: Terminal is not the default value of this option field!
On the page the drop down shows all the Terminal addresses.
So far so good ...
But when a user wants to create a new address of the type terminal and uses the "New" link on the drop down the default page will open but the Type field will show its default value and this means that you cannot create a address record this way with the a Type equal to Terminal.
Can this be solved in another way than writing your own OnLookup Trigger on the field?
I've got the following situation:
we have a field with a table relation and this table relation is also filtered on an option type.
I'll explain through an example.
The Table relation of that field is to an Address Table with an extra filter on the Type field (Option field) to show only Addresses of the Terminal Type
Important: Terminal is not the default value of this option field!
On the page the drop down shows all the Terminal addresses.
So far so good ...
But when a user wants to create a new address of the type terminal and uses the "New" link on the drop down the default page will open but the Type field will show its default value and this means that you cannot create a address record this way with the a Type equal to Terminal.
Can this be solved in another way than writing your own OnLookup Trigger on the field?
Now, let's see what we can see.
...
Everybody on-line.
...
Looking good!
...
Everybody on-line.
...
Looking good!
0
Comments
-
Try to set the PopulateAllFields to yes on the form...0
-
Do you mean on the card that's opened when pressing new?
If so, this doesn't help.Now, let's see what we can see.
...
Everybody on-line.
...
Looking good!0 -
Ah, ok, I have not noticed that it is RTC and the New function, not only entering new record in the dropdown... sorry...0
Categories
- All Categories
- 73 General
- 73 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 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
