Hi all, I’m a beginner and perhaps somebody can give me an advice: I want to visualize/display in a form with several tables/lookup boxes/fields for the user only the description after the user having selected the appropriate code. Reason: for the user codes are meaningless, and it would be time consuming for the user to check the description related to the code. How can I manage that? Thanks to all. David
Hi om If u look into the customer card (form 21), the control “gen. Bus.posting group” looks into the table “Gen. Business Posting Group” and if u want the description of the record u have selected to be displayed immediately, you can write the trigger on the on validate trigger of the field as 1.declare GenBusinessPostingGroup as VAR record in the globals 2.declare Description as text var. 3.add a tex box to the form and give the source expression as ‘description’ 3.on validate “Gen. Business Posting Group” control in the form write if GenBusinessPostingGroup.get(“Gen. Business Posting Group”) then decription := GenBusinessPostingGroup.description; Kumar
Hi, and if you add the code of step 3) also to the OnAfterGetRecord of the form, then the descripction will also be displayed when you select the and run throught the records without changing the content of the mentioned fields. Saludos Nils