Recent content by fsagwe

Thank you for the reply!

Thank you so much for the inside!!Need to review the lesson. Best Regards,

Dear Everyone, Please assit on which will be the most appropriate primay key for the Book Table in the above extract?The image is attached! Thank you Best Regards,

I have a form with sub forms . Each sub form has a textboxes getting me a total value of a field. In the main form I want to add a textboxes that will sum up values in the textboxes of the subforms. Help!

Some body to assist with access formula to calculate sum of numbers vertically

#How does one come up with a Joint table and can you assign PK & FK on one single entity table? Kind Regards,

Thanks, well on TeamGame table ,I can use GameID to extract two records .But my problem still is on fixtures:20 teams taking part in a league,each team must play (Home & away) and that the coach of each team will act as a referee in the pool.But,the coach/referee can not officiate his /her team...

Thank you very much on the guide.Should I follow the same method in assigning For and Against Referees.

Dear all, I have tried to work on these attached football system database.I got problems in: 1.Generating automatic fixtures(home and away)for a league of 20 teams.(query) 2.Automatically assigning referees both home and away(query) 3.Functions to come up with a league table(query) 4.Report...

Thanks, once more, let me try and make the tables first and I will update you on the progress.

Thank you @ GinaWhipp for the sound advice .Actually am going to work on the tabless.Please do me another by giving me an overview on how to create junction tables in these case.Should I use SQL statements.Few guiding steps .

Dear Members, Thank you very much for replying to my threads on the earlier posting. Well, I have created the following tables with equivalent queries:tblTeams, tblPlayers, tblReferees, tblFixtures, tblSeasons, tblVenues , tblTable Standings.With appropriate field names and relationships . Help...

Dear Members, Please assist me with coming up with a full working Access football system.Involving tables,queries,forms and reports or involving tables,forms and modules. KANDANDA FOOTBAL LEAGUE MANAGEMENT INFORMATION SYSTEM Kandanda football league (KFL) is a secondary organization...

My name is Fred Sagwe from Kenya.I am a teacher by profession and I teach computer science in high school.Happy to join the community.