Display all Qualified records from a related table on a layout.
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.