Question:Checkbox show in Edit box

[Scott Pon]

Heres my situation. My company is dealing with manufacturing. So we have an order, and we assign employee numbers to work on that order. We are using a field as a Checkbox, with a Valuelist that has all the employee numbers.

In a 2nd Layout we want to create a report. We would use Find to filter down to a single Employee. and review the orders that employee worked on. We used the same field, except as an edit box to show the data. Now I have 2 problems:

1) the Editbox does not show the Employee Numbers in numeric order. It shows who was clicked first first, and second is second.

2) The edit box shows only the first chosen number. It does not put them all on one line.

Is there any fix to these problems? Any suggestions?

Thanks

[Scott Pon]

Well no replies. Let me try to simplify things and see if that works.

I have set up 2 text boxes on a layout. both boxes are linked to the same field. (ie what you put in one shows up in the other.) Now I change one of the textboxes to a checkbox linked to a value list. Now when I check one of the values, it appears in the Text box too.

I was hoping that after checking off values, they would appear in the same order as the value list, in this case, alphabetically. However it does not. Any way to get the values in the correct order?

Thanks in advance.

[comment]

You can force the values to sort by setting your field to auto-enter a calculated value (replacing existing value) =

FilterValues ( ValueListItems ( Get (FileName) ; "YourValueList" ) ; YourField )

However, assigning multiple employees in a single field has its limits, especially when it comes to reporting. Consider a join table of Assignments instead.