7 Replies Latest reply on May 10, 2013 1:43 PM by IanAllan(newuser)

    Display all Qualified records from a related table on a layout.

    IanAllan(newuser)

      Title

      Display all Qualified records from a related table on a layout.

      Post

           I am working with four  tables. Customers,WorkOrders, Joining, and Timesheet. I want to display a list (array) of ALL the qualified (active) Work Orders that contain a field Complete="NO" on the Timesheet layout. The list is to be an aid for a worker entering his time as there may be many qualified (uncompleted) Work Orders at any time.

           A Dropdown List of work Orders really will not give enough info. I need to show wo_ID, wo_CustCode and wo_DESCRIPT for ALL the open Work Orders.

           I can open a WorkOrder window displaying the qualified records placed beside my Timesheet window but that is too clunky. I need to display my (scrollable) list on the Timesheet window.

           Hope you can help.

           Ian

      ManyMany.png