Sort portal contents by external field

[AndyCan]

Hi,

Can anyone tell me how i can sort the contents of a Portal by a field in a related table?

For example,

I have master table and layout with a portal showing data relating to the LINE ITEMS table.

The LINE ITEMS table has a primary key, ProductID Foreign Key, Quantity, etc. and a separate PRODUCTS table from which i import the contents of of the primary key ProductID into the foreign key ProductID in the LINE ITEMS table.

Thus the LINE ITEMS table is populated every time i run the import script with say 100 records (for 100 products) placing the ProductID in the aforementioned foreign key field. I have chosen not to show the ProductID in the portal, but instead display the Product name field PRODUCT::Product name (from the related PRODUCT table) so that for each line a human readable product name is shown.

My question is how do i sort the contents of the portal by the Product name, given that this is not a field contained within the LINE ITEMS table from which the portal was created.

Is there an obvious way that i haven't discovered or does this involve some workaround and possibly scripting?

Thanks in advance

Andy.

[comment]

See:

http://www.fmforums.com/forum/showtopic.php?tid/188622/post/259763/#259763