dynamic drop-down value list

[MarcZ]

I've got a preliminary set of sorting fields, called, let's say, LISTsort1 and LISTsort2. A third field identifies (via text serial #) a record (LISTserial), a fourth describes it with a text label (LISTlabel). I need a drop-down to display a calculation of LISTserial & " " & LISTlabel, but be ~sorted~ either by the text-serial value in LISTsort1 or LISTsort2. Trying to obtain this now, can have either LISTserial & " " & LISTlabel in my drop down, alpha sorted by LISTlabel, or something even less useful. Any thoughts?

Selected drop-down LISTserial items are part of a portal

[bcooney]

Marc,

Others may be able to follow this question (it's very abstract). I'd be able to help with either a screen shot or a clone of the file.

Barbara

[MarcZ]

thanks Barbara, made example FM file (attached as zip) that works to fill in entries, but w/out ability to control (yet!...) the sort order of drop_down items from LIST

hope that makes my ? more concrete for you

drop-down.fp7.zip

[bcooney]

Marc,

Since you've ranked yourself a beginner, would you mind if I ask some basic background about your familiarity with value lists and key fields?

In your system, do you have a unique serial ID for each record? Let's take List. Each List record should have an auto-entered ID numeric and meaningless. Also, will have a text label. So, for a part table, typically you would have a PartID and a PartDesc.

You can create a value list that is comprised of PartID and Part Desc and only shows the Part Description. It will sort alphabetically by Part Description, although the field will be populated with the PartID.

Is this something you are familiar with?