On 5 Jun 2011, at 07:57, Andrew Gordon wrote:

> I have updated FMP from 6 to 11 and have come across some changes that are perplexing for a FMP dummy.  When setting up tables in >Mangage Database>Relationships, and have made errors and placed tables in the trash, a message appears in the open table "table missing".  It seems there is a broken connection/link.  How does one recover from this?
> 
> We use FMP almost exclusively to manage our business and the jump in versions is taking a bit of adjustment.

Andrew,

There is indeed quite a jump from FMP 6 to FMP 11. In fact, the major jump was between 6 and 7. Most of us made it many years ago. I for one have quite forgotten the reality of working in FMP6....

It is worth reading the various literature still to be found around the web about the jump to FMP 7 (eg www.fmp.it/download/files/FM7_key_concepts.pdf).

Note that you are asking here about >Mangage Database>Relationships. This is, approximately, what it says: you are managing relationships in your database, not tables. Tables are managed in >Mangage Database>Tables. The upshot of that subtle difference? In the relationships graph, the things that 'look' like tables, and that you can name and reassign at will, are not the actual tables. Each is a kind of 'instance' of a table (and there can be multiple instances of the same table). Generally, FMP developers refer to them as table occurrences (TOs). I think you will find that term in the above Key Concepts pdf.

You can recover a broken TO by simply re-selecting the table it should be based on (or a different table if you like).

HTH

Steve