I have a multiple select field with an @DbLookup to provide a dialog list, from which users select a number of projects, and this field is used to populate a series of other fields on the form using @Elements, viz:
Projects: Project A, Project C, Project E
Project1: @Elements (Projects; 1) => Project A
Notes1: rich text field with notes about Project A
Project2: @Elements (Projects; 2) => Project C
Notes2: rich text field with notes about Project C
Project3: @Elements (Projects; 3) => Project E
Notes3: rich text field with notes about Project E
All works fine, until at a later stage the user wants to add or delete a project, then the project name-notes thing gets all mixed up:
Projects: Project A, Project B, Project C, Project E
Project1: @Elements (Projects; 1) => Project A
Notes1: rich text field with notes about Project A
Project2: @Elements (Projects; 2) => Project B
Notes2: rich text field with notes about Project C
Project3: @Elements (Projects; 3) => Project C
Notes3: rich text field with notes about Project E
Project4: @Elements (Projects; 4) => Project E
Notes4: blank
Is there a more elegant way to go about this?
Failing that, is it possible to make the Projects field sort in the order the user selects the projects? Because the dialog list is based on an @DbLookup, it is of necessity sorted alphabetically.
Or is there some other easy option that I can’t see?
I’d appreciate any advice at this stage; I finish up at work in two weeks, and this has just exploded in my face as I’m trying to sign off on everything.
Helen.