Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

One to many relationship "how can I display a field different from the primary key"?

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

One to many relationship "how can I display a field different from the primary key"?

I am creating a new database and I have 2 tables.

Table1 = Games ( Games) = PK GameID Title FK CategoryID

Table2 = Categories ( 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

One to many relationship "how can I display a field different from the primary key"?

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