Help to use tables in MySQL with foreign keys to create drop-down-lists
Project detail
We need a good SQL expert to clarify some open issues in our small project.
One of the topics is to create an example and step-by-step documentation (slides) for:
How to use tables with foreign keys to create drop-down lists?
For example in a table with clients, we want to have a drop-down menu with all countries and country codes from another table. As a front-end, we use LibreOffice Base.
Proven workflow for MySQL Workbench is required!