I assume you'd rather want three separate tables (artist, album, track) with an autoincrementing ID field per table. Your approach would not allow users to own more than 100 albums.

regards,
Markus

Quoting "Sreedhar.a" <[EMAIL PROTECTED]>:

Hi,

I have a table with 3 columns.

Artist Album and tracks.

Can i fix a range of ids for each column
like 1-100 for Artist 101-200 for Album and 201-300 for tracks

So that I can have a unique number(id) for each record.

Will there be a problem while deleting and inserting the records?

Thanks and best regards,
A.Sreedhar.







--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to