Getting specific record number

[Gunnar Swan]

I think a tree structure may be what you want. Search for 'polo' give one record. 
But client wants to scroll 'shirts'.

Consider two cursors. One with direct hit on 'polo'. But second ... search for parent of 'polo' ... 'shirt'.

To scroll, get record position 'polo' within 'shirt' cursor. Then move forward or back.

To implement, I think a tree structure in database. With tree structure, you can organize products nicely.

Gunnar

With a tree structure, you can pull all shirts

7/18/03 9:43:14 AM, Mark Maslowski <mark at majico.com> wrote:

>> Is myCursor.currentPosition what you're looking for?
>
>I don't think so. Let me see if I can explain it better.
>
>The project is a clothing catalog CD. Let's say the user uses the menu to
>select Mens Shirts > Polo. I display the record information for this product
>by creating a cursor with WHERE shirt_style = 'polo'. This creates a cursor
>with a single record. However, the client want the user, with a back and
>next button, to be able to step though and display the products in Mens
>Shirts. So, I need to find out where the current product, Polo Shirt, is
>within the larger cursor of Mens Shirts so that I can do a NextRecord or
>PreviousRecord from that point.
>
>Did that help?
>
>Thanks.
>
>- Maz
>
>*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
>
>Mark D. Maslowski
>Partner/Designer/Programmer
>
>MAJICo - The Mark and June Interactive Company
>Serving Northern California - from Napa to Monterey!
>www.majico.com
>
>831-336-3343 voice       831-336-3353 fax
>
>*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
>
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>


Best Regards,
Gunnar Swan
Practice To Pass
1.888.307.2050
http://www.PracticeToPass.Com