Dreamweaver
Well-known member
- Local time
- Today, 12:39
- Joined
- Nov 28, 2005
- Messages
- 2,466
I have added a ERD picture for this one.
Please note tbltracks in red.
My issue is the Track Title as I'm expecting the db to hold a large amount of data as the freeware project is being designed for use by DJ's I am trying to think of the best way to handle the track title.
there will be a import system which complicates things as I need it the not strangle the system.
I was thinking of adding an additional lookup table to hold the track title but it will create a lot of U.I problems not so much with the import system thats just a extra time thing, but the problem will come with manully adding records and tracks as there could be more tracks than a combo will display on lookup think thats something like 50k records.
Hope you can understand what I'm trying to explain, how would you handle the track title.
Please note tbltracks in red.
My issue is the Track Title as I'm expecting the db to hold a large amount of data as the freeware project is being designed for use by DJ's I am trying to think of the best way to handle the track title.
there will be a import system which complicates things as I need it the not strangle the system.
I was thinking of adding an additional lookup table to hold the track title but it will create a lot of U.I problems not so much with the import system thats just a extra time thing, but the problem will come with manully adding records and tracks as there could be more tracks than a combo will display on lookup think thats something like 50k records.
Hope you can understand what I'm trying to explain, how would you handle the track title.