- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Any Microsoft Access Experts?
Posted on 1/17/14 at 1:23 pm to Tortious
Posted on 1/17/14 at 1:23 pm to Tortious
quote:
If someone is on two teams would you want the data in both team tables right?
Someone could theoretically be on a max of three competitive teams and could compete in a max of 5-6 competitions.
Posted on 1/17/14 at 1:28 pm to TheOcean
Your design is the problem I think. See the long post aboout 2 above. You need an alumni table, a team table, a competition table, and then a "results" table to store the combinations. So my alumni Id, team Id, and competition id would be stored.So if I'm A,on team B, inn competition C the results table would store ABC in a row (separate columns). Then if I'm on team B, but in competition D it would store ABD.
Popular
Back to top
Follow TigerDroppings for LSU Football News