AnsweredAssumed Answered

Re-lookup problem

Question asked by mz5005 on Jun 2, 2018
Latest reply on Jun 3, 2018 by mz5005

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?

Attachments

Outcomes