I have a Lay Out (LO) with fields from multiple tables.
The key in the LO/ table is ID. There is also a table Mailings with same key (ID).
All data from Mailings is shown as it should be on the LO (so the relationship is fine).
Now I have added a new look-up field on the LO from another field of Mailings.
I followed the Help step by step to define the lookup field (see screenshot for its status now).
Because there are many existing records already, I Relook-up.
I always get the error message "There are no fileds that llok up values based on the field ID".
(i have tried also selecting the to-be-filled field..similar message.. re-defining the lookup..restart fmp..all to no avail).
Q1 when i give the relookup command, then the field ID should be selected. Correct?
Q2 what can be the reason given that the relationship works well?