Hi, I'm David from Malta

[DavidParnis]

I am building a database of a football club with matched#s played and players. I want to creat a form with every football match with line-ups and scorers. I am creating a form but when I put in the player's nameit does not show up when I open again the form. Do do not know what is wrong. I can I get any help?

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[bob fitz]

I am building a database of a football club with matched#s played and players. I want to creat a form with every football match with line-ups and scorers. I am creating a form but when I put in the player's nameit does not show up when I open again the form. Do do not know what is wrong. I can I get any help?

But what tables do you have? Tell us about your tables.

 

[DavidParnis]

Thank you for your reply. I have tables such as Clubs, Competitions, Games, Managers, Opposition Managers, Opposition players, Opposition Teams, Players, Referees, Seasons, Stadiums, and Transfer Table.
It could be i#I am doing something wrong in the Relationships.

 

[bob fitz]

Thank you for your reply. I have tables such as Clubs, Competitions, Games, Managers, Opposition Managers, Opposition players, Opposition Teams, Players, Referees, Seasons, Stadiums, and Transfer Table.
It could be i#I am doing something wrong in the Relationships.

Indeed. So show us a picture of your relationships window or post a copy of the db.

 

[DavidParnis]

I am attaching an image of the Relationship Table and the db.

 

[bob fitz]

So which form are you having problems with?

 

[DavidParnis]

The Form is called Players1. When I choose the player name from the dropdown list, it does now t show up again when I re-open the form.

 

[bob fitz]

The combo boxes from which you choose players' names need to be bound to a Recordsource so that the selection is saved somewhere.
I've noticed a few of other things that you should perhaps look at;
Some of your tables have no PK
You have Lookups in tables.
You have repeating data in tables e.g. Name, Full Name, Surname
Reserved words should not be used to name any object in Access e.g. Name should perhaps be FirstName
Using spaces in the name of objects is not advised e.g. Full Name should perhaps be FullName although this field should not even be in the table as it repeats the data in other fields.
You don't have a table Countries.
I haven't studied your relationships but I suspect that they need looking at also.

 

[DavidParnis]

I will k#look into your suggestions.

 

[The_Doc_Man]

As a side note, this post changed from "introductory" to "specific problem" - which by our CUSTOM (it's not a rule, David, so no chastisement required) needs to be in one of the specific tech forums. I am going to move this to "General" for you.

 

[DavidParnis]

Thank you

 

[The_Doc_Man]

OK, now that the thread has been moved, your problem is simple once you understand what Access does - and doesn't - do.

You have a form with controls on it. You want the form to be populated with data when that form comes up. There are two general ways to do that. One is to point the form to an object that contains the data you want displayed and BIND the form to it. Then the controls can be individually bound to the data elements you want. The other method is to have the form remain UNBOUND and use code to make it display things based on VBA code behind the form. Of the two, the BOUND FORM style is about a gazillion times easier.

Forms are bound to .RecordSource objects, which usually are a table or a query. The controls on the form are bound to .ControlSource objects, which are usually fields in the .RecordSource object. If you have some player not showing up, your problem will be whether the player is in the record source, in the specific record to which the form is currently bound. If not, you will need to either have code to do some lookups (usually very tedious) or you will need some kind of linked sub-form that can do a detail lookup related to the main form's current record.

Your question didn't tell us a lot about your familiarity with Access, so until we know a bit more about your level of expertise, it will be hard for us to give you specific help. However, from your responses, I infer that you are relatively new to Access. We don't hold that against you because each of us was once new to Access.

 

[DavidParnis]

Absolutely! I must admit, that I lack familiarity with Access. I just had a basic course in Access. I am trying to rebuild the database.

 

[mike60smart]

Absolutely! I must admit, that I lack familiarity with Access. I just had a basic course in Access. I am trying to rebuild the database.

Hi David
If you think about your process, you are trying to record information about All Games played in a specific Season.

So to get you started if you look at the relationships in the revised Relationship Diagram you will see that I have removed all of your current relationships.

I then added a field named "SeasonID" to your Seasons table and made this a Primark Key Autonumber.
I then added a field named "SeasonID" to your Games table and made this a Number LongInteger DataType,
I then updated the SeasonID in the Games table.
I then linked Seasons to Games using the SeasonID and Enforced Referential Integrity.
I then created a Main Form based on the Seasons table with a Subform based on the Games table.
See the updated database attached.

 

[DavidParnis]

Good morning, That is beautiful, thank you for your help. So I will try to make a form with a sub-form for each match with the squad players.