This senior citizen is having trouble linking two simple tables to get the desired results. I am a self taught user to hasn't used Access for awhile. I am trying to set up a database to track March Madness (NCAA Basketball Tournament) bracket results.
I have one table which just represents a column of games as shown on the brackets. This table has two fields which pull down the names of the teams from another table using a drop down menu. For some reason my drop down fields for team number appears different in the games table. What am I doing wrong? I want the team names to show up - Gonzaga and Georgia State and not 1 and T02 in the games table.
I have attached the database for your review. Keep in mind I am self taught user and very very rusty.