I have a beautiful relataional db in FM Pro 6 -- one file, Inventory, has a layout, Order Worksheet, in list view of the items that I sell (including the manufacturers I am using) to set up pending orders, etc.

In a seperate file, manufDB, (with just one l ayout) I have each manufacturer entered into its own

record.

How can I create a button or pop-up menu/list or portal in Order Worksheet that will trigger a script to selectively sort by an individual manufacturer (and keep current as I add new records in manufDB for the manufacturers)?

I know how to create several scripts that will sort by each of the

various manufacturers, but it is neither self-updating when I add a new maunfacturer in manufDB nor are the various scripts available from one easy to use option ....:

Maybe you can use a portal, and specify that the records be kept sorted.

I was thinking about that -- setting up a portal for all the records that correspond to manufacturers and creating a button over that so when choosen with trigger a script to sort according to the manufacturer choosen.

Any further ideas?