I need show a dialog that allow us select a value of a table. This would work like a field that has a TableRelation defined in its properties.
I hope you understand me.
We have employees that we are created like customer too. I have a dialog that request to the user the employee number that correspond to the customer. Then, i need that the window allow us select from the employee table this number. How can i get it?? (it would be like a drilldown).
I don't know how can i explain some better. My english is not so good. Sorry and thanks
You mean that you want to create lookup for field, which is No. from table "Customer" (or "Employee"?). It means you just needs to set TableRelation on this field to correct table and the Lookup button will be there to allow you to select the value from the related table... or you want something other?
do you need an new field on customer table to employee table :?:
If yes, then create an new field on the base table (like customer) and set on property table relation the table no of employee table.
Comments
I don't know how can i explain some better. My english is not so good. Sorry
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
If yes, then create an new field on the base table (like customer) and set on property table relation the table no of employee table.