I have a detail table which has foreign key from master table’s primary key. But I don’t know how to display another master table’s field, which correspond to the detail table. for example I have these following tables : masterTable key name detailTable key description I want, if I scroll through the detailTable, there is a staticEdit displaying the ‘name’ field from masterTable which correspond to its key in the detailTable. any help would be appreciated. Thanks a lot.
Make it with a flowfield of type lookup
Hi Agus, you have to add a field, lets call it MasterName, to your detail table. if the properties of this field you change fieldclass to flowfield. After that the propertie ‘CalcFormula’ will appear with a assist button. Use this button to define a formula based on Method = ‘Lookup’ As table use your mastertable field = field from mastertable which you want to see Table Filter : Use the assist button to set the filter to matching fields
Thank you for your comment. But there is no field named fieldclass. I don’t find any help for keyword ‘fieldclass’ or ‘flowfield’ in the axapta developer’s guide. I can’t proceed with those clues.
[:D][:D] Sorry I am wrong here, that is a navision solution SORRY [:I][:I]
Hope it’s Help… now you made a form, example DetailForm. in that datasource form you put master and detail table. if you want to scroll detail table and showing the ‘name’ from master table you can use joinsource property in master table and change it become detail table. and then put detail table to the grid and add stringedit pointed to field name in master table. everytime you scroll in the detail table grid … the ‘name’ that related will shown in the stringedit. i’ve made an example for you … if you don’t mind please give me your mail address to danang_ismu@yahoo.com and than i’ll send you the example. best regards, Danang Ismu .S.