I'm in a bad relationship

[John Chamberlain]

Trying to start a new project, I had several different tries at my inital file. Somehow I messed up and the seemingly simple file has a glitch.

The file (attached) has two tables, and they appear to properly related, but when I try to place fields into a layout they appear to insert OK.

Hoever,  in Browse view. I see  "Table Missing" instead of the merge field I was expecting.

Any help is greatly appreciated. 

NEW DB.fp7.zip

Edited August 26, 2017 by John Chamberlain
clarification

[bruceR]

There is nothing wrong with the merge expression.

The text block in question is actually a GROUP; and part of the group is an invalid field.

[comment]

 

Apparently you had another TO of one of the tables that you have since deleted - but you did not reassign the layouts and the fields belonging to that TO to another occurrence of the same table.

 

 

Edited August 26, 2017 by comment

[bruceR]

True; and also ...

Layout #5 has the correct table occurrence but still shows the problem, due to the other issue (invalid field ref).

And once the table occurrence for layout MONTHLY DISTRIBUTION SHEET is straightened out, the problem still exists on that layout; because of the bad field ref.

[edited]

Edited August 26, 2017 by BruceR
replies supplement each other

[comment]

3 minutes ago, BruceR said:

Layout #5 has the correct table occurrence but still shows the problem, due to the other issue

It's the same issue: some layouts and some fields are assigned to a deleted TO. My post was intended to add to your answer, not to contradict it.

[Lee Smith]

Hi John,

Bruce and comment responded with more or less the same things I was about to say.

It might help to see this screenshot of your  TOs and Layouts.

HTH

Lee