Help with Baseball DB

[tmperez]

Hi Everyone,

I have been thinking about creating this Fantasy Baseball DB for a keeper league we have had for about 12 years. I started work with Navision a few years back and planned on using that but its just too complex for what we need.

Anyway, my first question is, how can I populate a table from another table?



For example, I want to upload my draft, which will include: Team Name , Player Name , Contract Value , Years , Date (auto populated)

I want this data to be auto populated in the Team table will the above into (in addition to more) I will then use queries and report by date to track the "finished" teams. Im ok if I have to use a utility of some sort to create the record in the the team table.

I do not want to enter data twice ie. Draft and teams, I just want the team table to auto populate from the draft data.

Thanks in advance!

[June7]

Don't understand. The player is associated with team in the draft table, why another table? Consider:

tblPlayers
PlayerID (primary key)
LastName
FirstName
Birthdate

tblTeams
TeamID (primary key)
TeamName
TeamCity
TeamOwner

tblPlayerTeam
ID
PlayerID (foreign key)
TeamID (foreign key)
ContractValue
ContractYears
DateStart
JerseyNumber