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?