Best way to assign tasks to a Work Order record

Discussion created by mikerevans on Mar 7, 2017
Latest reply on Mar 8, 2017 by mikerevans

Hi all,


Apologies if you already read yesterdays post, but i'm really struggling here.


I have two tables, "Work Orders" which will contain the Work Order records. Each work order record will need to contain multiple tasks, which will need to be referenced from a list of set Tasks and associated descriptions and costs. This table is called "SOR". The "SOR" table has a primary key which is a set number per task listed. The work order records primary key is the actual work order number.


I just need to know the best way to get multiple tasks into the work order. I originally did it by making drop down lists, but I had to create a duplicate SOR table for each choice and reference that separate one for each task i needed to select, as you imagine that can become very unwieldy but it worked.


I have tried a portal to select from the list of 846 separate tasks, it also is unweildy.


Please can you advise?