Subject:
|
A database question
|
Newsgroups:
|
lugnet.admin.database
|
Date:
|
Wed, 25 Nov 1998 03:36:50 GMT
|
Viewed:
|
499 times
|
| |
|
|
Hi:
I am currently in the early stages of completely redoing my Lego
Technics site and decided it would be cool to put all of my information
about technic sets and elements into an Access database (this may
not be the best choice but is was free!). At very least I could
then generate my HTML automatically and possibly end up with
dynamic ASP (or CGI) pages.
Since I know absolutely nothing about databases and alot of you
guys know alot about them here is my question:
What is the best way to handle the fact that a given set number
can refer to different sets and a given set can have multiple
set numbers?
I thought that I could have a simple table of all possible (Technic) set
numbers with each number pointing the real set record.
Is there a better way?
Thanks
Jim
hughesj@one.net
http://w3.one.net/~hughesj/technica/technica.html
|
|
Message has 3 Replies:
 | | Re: A database question
|
| (...) Since set numbers are not unique, they shouldn't be used as primary keys. So the best solution is to move the set number into a secondary key and introduce a new primary key which is either a function of the set number by tacking on "-1", (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
| | | Re: A database question
|
| (...) If you go with Access, take the time to write a VBA function to export the data to CSV format. That way, you can share with everyone, and you won't have a export-headache each time you update the database. (...) The classic relational database (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
8 Messages in This Thread:
  
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
Active threads in Database
|
|
|
|
|
|
