@hugo, my apologies I am just trying to get to see which method will work best as I am fairly new at SQL:

1. what I need to be done functionally is this:

In the UI, when a user there is a field called code and it has a sub field called description. So in the front end when the user clicks code lm40.0, the subfield description needs to auto generate "asthma", I am basically matching a code with a description. each disease code has a description matching the code.

So if I select via the UI lm40.0 in the code field, the underneath in the subfield the description must auto populate to asthma

2. yes selecting the code in the UI but in the backend in sql there is a table called codes with columns code, description

3.The description value is in the codes table, it is associated with a code. Each code has its own description. I.e. Each disease code has a description.

apologies for my ignorance I just want to know the best route to take here