I have a list of job numbers listed inside a portal in the Product file. The job numbers must be listed in the order that the product is manufactured. I know the portal can be sorted via the job number but that would not be the proper sequence.

For instance:

A product could have the following list of job numbers,

201804 PCB XYZ SMT

180401 PCB XYZ MOD

198020 PRODUCT XYZ-1 BUILD

210841 PRODUCT XYZ-1 TEST

450802 PRODUCT XYZ-1 QA

Now, initially when I create the Bill-of-Jobs (Product with a list of jobs) I create it in the manner it is going to be built. But after the list is defined, down the road, production may request a job number for "PCB XYZ TEST". Now this new job number must be inserted in between these two portal rows: 180401 PCB XYZ MOD

198020 PRODUCT XYZ-1 BUILD

So how do I get the new job number/description in between two existing & populated portal rows? Remember, the list of job numbers must be sorted in the sequence that a Product is built... perhaps someone can help me with this dilemma.

Thanks in advance,

Linda

How about allowing the list of items to be allocated a sequence number - which can be re-applied when required. The use the sequence number as your sort criteria.

Expanding some on what Mark Dore mentioned, if you use a sequence field to set the sort order, you can change the order by changing the values in the sequence field. I am attaching a sample file to show one method for moving rows up or down. It also includes a script to set the sequence number for existing records. The file is not real pretty, but you should get the idea.

You can find more portal techniques at Database Pros by searching on portals.

portal.zip