AnsweredAssumed Answered

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

Question asked by IanAllan(newuser) on May 8, 2013
Latest reply on May 10, 2013 by 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

Outcomes