Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Storing a 3-dimensional Array

Author  Topic  Fusion Starting Member 3 Posts Posted - 2001-10-21 : 21:27:44 Hi, I have a problem, and I'm hoping someone here can help me. I have the following tables, Users, Games, UserGameLink, UserGameData. I'm trying to store data that can be thought of as a 3-d array. I have a list of users, and each user has a few game, and each game has a few levels, and I need the score for each level. Right now the UserGameLink, has user, and game fields, with each referencing the users and games table through foreign keys. I tried doing the same thing, with the UserGameData table and foreign keys to UserGameLink, but it wouldn't work. I need referential integrity, but I have no idea on how to implement this. Hope this is clear enough. Here's some info about the tables: Table: Users Fields: UserName (PK), FullName Table: Games Fields: Game (PK), AddDate, etc. Table: UserGameLink Fields: Game, UserName [Constraint PK: Game, UserName] Table: UserGameData Fields: UserName, Game, Level, Score Thanks, Fusion