PDA

View Full Version : Table lookup order


ABC123

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??

Bill

Rawlings
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.

RAWLINGS

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

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

Bill

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.