Recent content by 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.

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.

Thank you

I will k#look into your suggestions.

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.

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

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.

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...