I'll start while JimB's away...

Your original suggested "Density" and "Thickness" are both CHARACTER fields. This is so because you use the + operator to create your index and it is highly doubtful that you want to SUM them. So it is safe to assume CHAR and that you are concatenating them..

The TRANSFORM(Quote_No) will convert "Quote_No" to a string regardless of its current type so that it can then be successfully +'ed (concatenated) with the other fields in question. You've looked up PADL so you know what that does.

Build this index the same way you build any other - INDEX ON... TAG ... when the table in question is selected and used EXCLUSIVE.

I hope this helps


>Ok, I'm pretty new at FoxPro. I'm not sure how to do this or what it does. I looked up PADL and that pads characters to the left. I looked up TRANSFORM and it didn't make sense either.
>
>If you could offer a little more help, I'd appreciate it, like how to create this index and what its doing.