For you to be aware, I notice that in some TableRelation conditions you can get unexpected results. Let’s take for this example Tables 32 - Item Ledger Entry 112 - Sales Invoice Header both tables have a Field ‘Location Code’ with a TableRelation as follows T32 – TableRelation: Location T112 – TableRelation: Location WHERE (Use As In-Transit=CONST(No)) If you change the field ‘Use As In-Transit’ in the Location table from False to True and after that you rename the record, you get every record in Table 32, with that Location Code, renamed but you get none record renamed in Table 112. Hope that helps.
That is true. Since the 112 is now out of filter range for the table relation, it leaves the orphan records.