VLOOKUP formula loses all relations to Jet table in designer mode

In report mode I've created in a non-jet table and added a VLOOKUP formula with relation to a jet table. So far so good. But when I switch back to designer mode all relations in formulas linked to that table are deleted and an error occurs.

This is because in designer mode the generated jet table will be deleted and of course the relation is not existing anymore. Unfortunately, Excel doesn't care about report and designer mode, the relation to the jet table is simply not existing anymore and the original relation will replaced with an error sign.

What is the solution for that problem?


Please sign in to leave a comment.