If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table relationships and lookups
Hi guys, I may be a little over my head, I've had some experience in
creating simple access db's. however this one will be extremely complicated as far as I can tell. Some backround info - i've got an excel spreadsheet currently that i would like to convert to Access. The spreadsheet does multiple lookups and calucations. This is for a Soccer club that i run to maintain roster information, dollars, scheduling and stats. I'm currently working on the scheduling pience. Here's what I have so far. tables. Club - Lists the teams in the club, home field name and address, city, state, zip and notes Opponent - Lists the teams in the league, home field name and address, city, state, zip and notes League_division - Basic, lists the league divisions 1,2,3,4 ( I didn't want to include this in the two previous tables because teams can move up and down depending on the season records. League_Season - Hopefully to use for keeping historical data, players and game info. Schedule - This is going to be for entering each shceduled game. Schedule table includes the following fields Game_ID - AutoNumber Game_Date - Date of game Game_Time - Time of game Game_Location - Value list, Home, Away, Other Game_ClubTeam - Combo box of Club team from Club Table Game_Opponent - Combo box of Opponent team from Opponent Table Game_FieldName - Game_FieldAddress - Game_FieldCity - Game_FieldZip - Game_FieldNotes - What I would like see is this.. Once the Game_Location, Game_ClubTeam and Game_OpponentTeam has been chosen, I would like the Game_fieldName, Game_FieldAddress, Game_fieldcity, Game_fieldState, Game_fieldZip and Game_fieldNotes all be filled in automatically based on the Location, club and opponent fields. I don't know if I am over complicating this, but I really don't know where to start. Both the ClubTeam and OpponentTeam Tables have matching fields. Anyhelp would be greatly appreciated. Thanks! Shaun |
Thread Tools | |
Display Modes | |
|
|