Importing File as Table AND replacing existing relationship

[Spac3man]

Hello All!

 

I have a DB that has several files. Each of these files has only one table.  For the sake of good design ( I'm fairly new to FM but not to DB design concept) I want to import each file into the main File as a table but not lose the relationships.

 

What I have tried is to FILE/IMPORT RECORDS/FILE as table and join the new table to the appropriate keys in the Relationshp diagram.  The problem is that the fields in the corresponding layouts still point to the original file.  If I delete the original file and rename the newly imported table to the original file name, the links are still broken.

 

Is the only way to accomplish the end result to re-link all fields in all layouts?  If so, I'll chalk it up to bad design and leave it as is.

 

Any info is appreciated.

 

SPace.... out

 

[Wim Decorte]

Import the different files as new tables first, then on the graph: repoint the TOs that were pointing to the external files to the new tables.  You do that by double-clicking the TO and changing the underlying base table that it points to.  Don't delete the old TOs or change the existing relationships to the new TOs.

 

Having said that: it is not always good design to hold all data tables in one physical file.  Depending on how you structured your tables across FM files your design may already be good.

[Spac3man]

Thanks for the info Wim.  This was originally designed in FM3.  I'm gonna let sleeping dogs lie this time.