#8 Inserting column changes relationship

[Steve Piner]

I have two tables with a relationship between them.

I insert a column before the column with the relationship.
(Using edit tables, and control-up)

The relationship has now changed to be the column
before the column that used to have the relationship.

e.g.

Table 1 has column 'A'.
Table 2 has column 'B'.
There is a relationship between A and B.
I insert column 'C' in Table 1, before column 'A'.

The existing relationship has changed, so it is between C
and B.