This is what your data should look like
tblFilters |
|
|
FilterNumPK |
FilterNum |
FilterName |
1 |
10 |
abc |
2 |
20 |
def |
3 |
30 |
ghi |
4 |
40 |
jkl |
tblScore |
|
|
ScoreIDPK |
FilterNumFK |
Score |
1 |
1
|
100 |
2 |
2 |
200 |
3 |
3 |
300 |
4 |
4 |
400 |
In the query upon which you bind your form to, you link pk and fk fields (equal join) and drag filter name field, as well as score and FilterNum if you need those also. My guess is that your tables are not structured this way at all and you probably need to read up on db normalization because H and V lookups really have no place in Access. That's why they're not one of the built in functions.
Last edited by Micron; 03-21-2021 at 06:38 PM.
Reason: correction
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.