Hi,
I would like to create a list page with certification details from VendCertification Table. Its similar functioanlity to Vendors on Hold list page, I would like to open it with Menu item. The list Page should display separate line for each certification type of a vendor. Ex: if Vendor has 2 certifications it would display 2 rows with each certification Name.
I and added a new query with Vendtable joined with Dirparty, VendCertification tables, I added Vendcertifaction Table to the VendTableListPage query and used it in VendTableListPageInteraction class with the help of case statement. When I open the list page with my custom menu item it was working fine but the other three list pages were throwing an error as the datasource "vendCertification" was not existing for them when the list page was called as Vendors on Hold or Vendors with past due.
The other options I have is using Display method from VendTable when I tried it was displaying empty value, even if its displaying also as I need 5 fields from different table I dont think using 5 display methods is not better idea. the other options is looping through the query in VendTableListPageInteraction initialized method and assigning the values to form controls.
or is there a better way to achieve this using query.. If I use my custom query in VendTableListPageInteraction class its picking the right values but how to display them in form without adding VendCertification Table to Form Datasource.
Thanks
*This post is locked for comments
I have the same question (0)
