Selecting specific fields from a selected record.

[Rog]

I have two DB set up as follows - the first is called TYPE and the second is
NOTES:
There are only two records in this example, but there will be many more
records for each when done. I want to be able to type MAJ and find the right
pattern in TYPE for example. (MAJ - 1 - 5 - 8) and then get the corresponding
notes to that pattern from NOTES for a selected key, like "C". See below.

I need to be able to enter "C" in one field on a form and "MAJ" in another
on a form and come up with "C" "E" "G" in four other fields on the
form;
or "A" in one field and MIN in the other and get "A" "C" "E", (from
1,4,8) but I cannot figure out how to grab only certain fields in a given
record.

(TYPE)
MAJ 1 5 8
MIN 1 4 8

(NOTES)
1 2 3 4 5 6 7 8
A A# B C C# D D# E F G
C C# D D# E F F# G G# A

Thoughts?