Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

3 fields single row 4 fields multiple rows?

Sep 13, 2001, 12:28 PM
rblissett
Novice (9 posts)
Sep 13, 2001, 12:28 PM
Post #1 of 4
Views: 1715
Shortcut
Quote Reply
3 fields single row 4 fields multiple rows?
Is it possible to build a database structure using this script that can accomodate some fields with single rows and others with multiple. The example is this:

Player stats for a hockey team would include Name, Height, Weight, Position, Shot which fits nicely to one row. I'm also obligated to store and also show their stats for the last four years, which obviously requires four rows. ie. Year -- 2001,2000,1999,1998 Goals -- 33,24,36,12 Assists -- etc....

Any suggestions how to accomplish this?

Thanks,

Rob Blissett Crazy
Sep 13, 2001, 2:39 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Sep 13, 2001, 2:39 PM
Post #2 of 4
Views: 1649
Shortcut
Quote Reply
Re: [rblissett] 3 fields single row 4 fields multiple rows? In reply to
Relational Mod
========================================
Buh Bye!

Cheers,
Me
Sep 13, 2001, 5:35 PM
AstroBoy
Enthusiast (720 posts)
Sep 13, 2001, 5:35 PM
Post #3 of 4
Views: 1650
Shortcut
Quote Reply
Re: [AnthroRules] 3 fields single row 4 fields multiple rows? In reply to
...which you can find in the Resources Section Smile
- Mark

Astro-Boy!!
http://www.zip.com.au/~astroboy/
Sep 13, 2001, 6:32 PM
rblissett
Novice (9 posts)
Sep 13, 2001, 6:32 PM
Post #4 of 4
Views: 1661
Shortcut
Quote Reply
Re: [AstroBoy] 3 fields single row 4 fields multiple rows? In reply to
well that's easy, thanks!