Listing

[outandabout24]

I am to type in lets say a football team... called eagles and I also want to put all the team members that belong to the eagles. Is there away to do this?

An example of this would be that I select the team eagles from a form that is linked to a separte table via a drop down menu. Then I use text box #1 to enter in my first player then click a button, Save or just a toggle button, and then it displays my first player in a large text box. Then I enter in text box 1 another players name and click the save button again and now I have two players names in the large text box.. I would continue to do this until I have all my players.. then I would be able to select another team and do then same thing.. I can get it to display in the Large text box but once I enter in another player it just erases the first player... Hope this makes sense... Can anyone help?

 

[RuralGuy]

Two tables: tblTeams and tblPlayers
TeamID (AutoNumber) as the PrimaryKey of tblTeams
PlayerID (AutoNumber) as the PrimaryKey of tblPlayers
tblPlayers has a field named TeamID that is a LongInteger field and will serve as a ForeignKey field.
Two forms: frmTeams and sfrmPlayers
MainForm/SubForm arrangement with TeamID (AutoNumber) as the LinkChild/MasterFields of the SubFormControl.

 

[outandabout24]

Thanks so much.. I'm gonna give it a try.. you mind if I have questions to send you a reply back? Thanks again

 

[RuralGuy]

Not at all. There are pleanty of people on this forum that can offer suggestions and solutions to issues.

 

[outandabout24]

Ok... I created a two tables.. one named Team and one named player

I also set the primary keys to the Team ID and Player ID

How do I set the field named Team ID in the Players table to a long interger? This is probable very simple.. i'm just not that experienced with access

 

[RuralGuy]

In design mode you can select the data type of each field. Use the DropDown to select Number and the default is LongInteger.

 

[RuralGuy]

There are a ton of really good on-line tutorials on Access. Google knows where they are located.

 

[gemma-the-husky]

dont use a team name - have a number field so that

team NUMBER 1 is named EAGLES
team number 2 is named LIONS

then players are allocated to team numbers, rather than names

that way, if a team name changes, you dont have to worry about how it is represented anywhere else