I am creating a new database and I have 2 tables.
Table1 ( Games) =
PK GameID
Title
FK CategoryID
Table2 ( Categories) =
PK CategoryID
Category
As you can see, the category table has a list of game categories
The Games table, uses the CategoryID as the foreign key. However, that foreign key is an autonumber field.
I would like to be able to select a category for each game and have it be readable. For example a category of RPG,
or Platformer. How can I setup my tables correctly, so I can just type the category instead of the number of the key from the category table.
Please excuse me, I am very new to databases. I am using LibreOffice Base with Linux Mint 17.3