Changing table(s) structure

[cybercider]

Hi,

I have been provided a table of sport fixtures (and results) that has the following structure:

t_fixtures
ID
HomeTeam
AwayTeam
Official
(various other fixture stats but unique to each fixture)

To my understanding of database design it is better if I had three tables, t_fixture, t_teams and t_offical, with the correct relationships.

I tried the Analyse Table tool and it produced 4 tables t_offical, t_hometeam, t_awayteam and t_fixture, so close!

Is there another function in Access I can use to merge the two team tables and have the appropriate lookup field updated correctly in the t_fixture table?

Or is there a better method this limited Acccess noob doesn't know about?

Thanks

CC

 

[cybercider]

Relationship

Problem solved, FYI:

Exported initial table to Excel, extracted the teams to create a team table and assigned each a unique key.

Did a find and replace for each team, replacing the team name with their key.

Then imported the tables back into Access and changed the field type on hometeam and awayteam in the fixtures table to a lookup against the newly created team table.

Thanks for reading

CC

 

[boblarson]

Re: Relationship

Thanks for reading

Thank you for posting your solution. It may help someone else in the future.