Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 268 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
TableRelation Ignores my Table Filter
Bagheera
Member Posts: 57
When clicking on the lookup button of the field Doctor No. Ι want to get the lookup list displaying ONLY the doctors that have their Hospital Code set to a value that I get from another field. So this is the TableRelation in complete
And this is the Table Filter alone.
D@mn thing ignores me or dumb me that I get ignored, the full list of doctors comes up... Any ideas?
Doctor.No. WHERE (No.=FIELD(Doctor Code),Hospital Code=FIELD(Hospital Code))
And this is the Table Filter alone.
No.=FIELD(Doctor Code),Hospital Code=FIELD(Hospital Code)
D@mn thing ignores me or dumb me that I get ignored, the full list of doctors comes up... Any ideas?
0
Comments
in OnLookup of that field I have specified a Recordset I filtered it the way I want and I assigned it to a Form (the form is specified in Globals).
How do I assign the Global Form with the filtered record to my filter in order to display it. At the moment it has the lookup button but it does nothing when you click it...
Thanks for ur valuable help.
found an answer in a previous post...
Doctors.RESET; Doctors.SETCURRENTKEY("Hospital Code"); Doctors.SETFILTER("Hospital Code", "Hospital Code"); IF FORM.RUNMODAL(55006, Doctors) = ACTION::LookupOK THEN BEGIN Text := Doctors."No."; EXIT(TRUE); END ELSE EXIT(FALSE);It works excellent now. Thank you.