At the design level of my application, I've consolidated two tables such that the second table is now simply an occurrence of the first table -- a worthwhile simplification. But now I'm faced with actually implementing this in an application with 100 layouts and 200 scripts. My question is:

Is there a way to substitute the new T.O. for the old T.O. without losing all the table references in layouts and scripts?

FileMaker seems very good at updating all references if, for instance, you change the name of a table or a layout, but I haven't found a way to avoid getting

Any suggestions of a way around this? Or am I up against a brick wall?

Thanks.

Simply change the source table of the existing TOs.

By double clicking on the T.O. and using the Specify Table dialog?

I tried this and, yes, it remained linked to the correct named table. The problem is that, at the field level, it didn't match up with the field names that had remained the same (i.e., that were the same in the old table and the new table). Did I miss a step? Or was I expecting too much?

Thanks for the reply.

Edited March 13, 200718 yr by Guest
Added results