Changing the TO for a layout merge field breaks the DDR
Operating system version
Mac OS 10.6.4
Description of the issue
When you have a merge field on a layout from the layout's TO and you change it to a related TO, the merge field continues to show valid data in browse mode, but the DDR reports a broken field.
Steps to reproduce the problem
Create a new file with two tables and one field in each table, all named differently. Add a cross product (X) relationship between the two table occurrences.
On the layout for Table 1, add a text object and a merge field like "<
Go into layout mode and change the base table for the layout to Table2, the other related table, but don't alter the merge field or click into it at all.
In browse mode, verify that the merge field still shows the related data from Table1 as before.
Generate the DDR and look at the Field list for that Text Object.
First, the field shouldn't show any data when the TO is changed. Because the merge field doesn't specify a TO, it should use the layout's TO and because "Field1" doesn't exist in Table2, the merge field should show a "Field Missing" error.
If it's going to retain the Table1 field, it should change or indicate in some way that it's using the Table1 TO.
Secondly the DDR should report accurately what is happening, so if it is still valid and showing data from Table1, then the DDR should report it as such. If not, then the DDR is accurate (ie it's a field from Table2) but the field shouldn't work fine as is.
First the field works, even though the field reference < NA NA If you click into the field and back out it will attempt to change the TO and so will show the literal text "<
Secondly the DDR reports the field as :
Which is that it's a field in Table2, but with a bad id and no name. So even though the field is still showing data from Table1, the DDR thinks it's from Table2 and is mis reporting what is actually happening.
Exact text of any error message(s) that appear
You would need to manually specify the TO for any merge field once you had edited the text.
If you click into the field and back out it will attempt to change the TO and so will show the literal text "<