Adding Records at Start

[Mark Maslowski]

> I want want you that you have NOT GOOD db structure!
> 
> As you see YOU HAVE DUPLICATES.
> This is EXACT SIGN that you have bad design yet.
> 
> You can wish to split data into several tables,
> Or may be use Table with self - recursion because in your task you can have
> any number of levels.
> 
> In IDEAL, you must not have DUPLICATE data.
> 
> Think about this.
> You can read in any RDBMS book rules of table normalization.

Thanks Ruslan. I realize that this database should be structured differently
but there are various reasons why it's not... it was originally an Access
project and I needed to keep the structure similar and not change much of
the code. The client is also constantly changing the data for me (or to
spite me) and they are using an Excel spreadsheet for their work. I need to
be able to simply and quickly import their format straight into the db. I'm
not doing anything complicated with the db data so this method seems to fit
my needs for now.

One of these days I'll have the time to explore the proper ways to design
and program a database!

- 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

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