If you create a relationship between the tables like:
table1::value ≥ table2::valueFromTheLookupTable
Sort the relationship with the valueFromTheLookupTable ascending field then create a lookup from the first table to the second.
This would be easier to explain with real field names though :-)
Thank you for the reply.
The field names are:
Fixture Ch. #
so a relationship like
Fixture Ch. # ≥ Fixture Ch. #
Sorted on the Fixture Ch. # from the second table. Does that make any sense?
I will absorb this and give it a try!
I'll let you know how it goes.
Thank you very much for the input!
I deleted a previous reply because I am getting closer.
I'll be back
Had to tweak a few things but I got it working and learned a few things too!
Thank you very much!
You get how the relationship pulls the first value, hence why sorting it is important?