View Full Version : Table lookup order


Bill Clementz
03-07-2005, 06:19 AM
I am doing a table lookup for parts in an invoice application. Parts table has a field (PartNo)which is used for the display order under field rules. When I do the actual lookup it displays in assending order.
Can I get it to display in descending order??


03-07-2005, 06:32 AM
Hi Bill,
use the function INVERT() in your LOOKUP order expression within your field rule. Expreesion will look like this INVERT(YOURFIELDNAME). This will order by descending order. Good luck.


Bill Clementz
03-07-2005, 08:36 AM

Thank you for the quick reply. I missed invert() when looking through expressions book. Just what I needed.


Edward Larrabee
03-08-2005, 05:07 AM
If you are not familiar with the webhelp, it will provide the most accurate and up to date reference for Alpha Five.