Adding Records at Start

[Mark Maslowski]

> But you do something strange then.
> 
> You have 10 records with the same value in level_1
> You want DISTINCT them to produce just ONE record.
> 
> Then it is not clear way to use 10 indexes in that 10 records.
> You cannot guess which one index will be choosed.
> You see?

Well, I'm usually doing something strange! What I am doing is building a
menu tree, with little folders and files, out of the database. The folders
are built from the entries in level_1. level_2 is the list of files that go
into the folders. There might be several files that go into each folder, so
their level_1 entry would be the same... folder1/file1, folder1/file2,
folder1/file3, folder2/file1, folder2/file2, etc. So, the reason I need a
unique list of level_1 is that I don't want to create a new and duplicate
folder for each and every file.

- Mark

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

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

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*