Creating Pick List and storing the selections

[[email protected]]

I'm hoping someone with more programing knowledge than I have can help me with this design.
I am currently using Alpha 5 v12
I have developed a web based building permit tracking system
I need to design a new feature that allows the "plans examiner" to assign which inspections will be required for each permit issued.
I was hoping to store the inspection options in a table and create a checklist of the options dynamically at run-time then once the "plan examiner" selects which inspections are required from the check list have those selections store in a table that is linked to each permit via the "Permit Number" in a one to many relationship.

It was my plan to create a dialog using an UX component that could be used to make the selections and insert the records into a table and then display the selections in a linked grid.

I stared by using a UX component, placing a checkbox control in a header that is generated dynamically from a lookup table.
The lookup table will store a short description of the inspection, i.e., Footing, Framing, or Sheetrock and a memo field with details of what the inspector will be looking for.

My first problem is the list is displayed alphabetically and not in the order I want and I can't figure how to re-order the list.

My plan is, once I overcome the check list indexing problem, is to use an 'onclick' event on the checkbox to insert new records into the repeating section container and insert the new records into the detail table via the submit button.

So if you have endured this long message to this point I have 2 questions.

1. Is it possible to sort a dynamically created check-box list other than alphabetically?
2. Is there a better approach to achieving my goad than the path I have chosen?

[lgrupido]

Re: Creating Pick List and storing the selections

To answer question 1. Yes.

Do you have a sort field in your table?

If you use the expert mode when creating the list, you can sort it any way that you want - but you have to use the expert mode, you can't do it from the easy mode.

Question 2:

Maybe - it really depends on the design and how you need things to work. I'm using V11, not V12, so I'm not the best person to answer part II.

[[email protected]]

Re: Creating Pick List and storing the selections

Expert Mode? Never used it, where and how is this mode activated.

[lgrupido]

Re: Creating Pick List and storing the selections

If you are already creating the checklist from a table, you just need to go into the dynamic choices section. It defaults to the "genie" but there is an expert tab there. Click on that and look around.

(at least that is the way it works in a grid - it should be similar in a UX component)