I think I'm getting closer to the answer. I was wtaching this: FileMaker Tutorial - 089 - Lookups pt 1 - YouTube and realised that I too, have corresponding fields in the YEARS-table as well as the INDEXATION-FIGURES table. The parameters.
But they are 4 parameters.
- - List type, (housekeepings or employes)
- - Base year, (1995, 2000 or 2006)
- - Year, (1995...2015)
- - Month/Year average (Jan...Dec, Year average)
These 4 fields appear in both tables.
I'm thinking of dragging 4 relations between the 4 corresponding fields.
And then I should be able to script a lookup like:
Look up index-figure
WHERE List type = houskeepings
AND Base year = 2000
AND Year = 2013
AND Month/Year average = Jun
...Something like that.
It is time to go home now, but I'll pick it up tomorrow.