This seems like a basic question to me but I'm having trouble finding practical solutions.
I have two tables, one for video game consoles, and another for the games themselves.
Consoles
+ -- + --------- +
| ID | Name |
+ -- + --------- +
| 0 | Console X |
+ -- + --------- +
| 1 | Console Y |
+ -- + --------- +
Games
+ -- + ------ + ------- +
| ID | Name | Console |
+ -- + ------ + ------- +
| 0 | Game X | ? |
+ -- + ------ + ------- +
| 1 | Game Y | ? |
+ -- + ------ + ------- +
| 2 | Game Z | ? |
+ -- + ------ + ------- +
My question is how do I do the data entry from scratch for the Game.Console column here? As a human, it'd be easy to write the Console.Name there, but obviously that's not recommended to use as a Foreign Key ID. But if I use the integer Console.ID as the Foreign Key, for 700 games and 30 consoles, it seems like I'd have to manually cross-check the table as I enter in all those numbers.
How do I do the task of data entry for an association like this? Is there a better solution than manually entering numbers? I'd think if I was using an IDE there might be some feature for a drop-down of foreign rows to fill in a foreign key value, but I haven't found anything.
Additional Info: I'm not expecting user input in this application, just my own personal data, so I'm not worried about validation, just how to alleviate tedium in the initial data entry. Entering cross-referenced integers seems like the job for a computer or tool.