Does anyone know an elegant way to have a list of randomly numbered
items print out in a particular order in a report. I am doing a product cost
report
containing a list of materials. Each material has a material number and name.
The material numbers are currently autonumbered. The materials have a
customary way of being ordered. If they are ordered randomly it would look a
bit
funny and the report would be harder to understand and use.
It seems to me that I need to have an additional PrintIndex column in
my
materials table and some sort of form to arrange the materials in printing
order.
The material numbers are referenced/used in other tables; I cannot renumber the
material numbers. I guess i could put an index number in the material name.
If I
didn't want to see it, I could use an SSUB function to get the part of the name
I'd
like to see.
Thanks, Geoffrey Wheeler, Center for Vocational Building Technology,
Thailand
