Lowest Bid/Quotation script

[peter k]

I am looking for a pre-made script that will pick out the lowest price from each grouping of bid/quotations. The price selected should so up in red.

I do alot of ordering of supplies and I am obligated to get bid prices and select the lowest. Very tedious. Need quick help.

[Wim Decorte]

You won't find such a script for the simple fact that it largely depends on how your solution is build, what field names are in used, etc...

Also, note that FM6 does not do text coloring. FM7 and 8 do. you can get the same effect in FM6 by overlaying two fields on top of each other, one with text formatted as red, one with text formatted as black. Once you've calculated the lowest bid price (through a self-join relationship using the Min function, or through a looping script), populate the red field.