I will try to recreate the scene of the crime

I had a two databases that were identical in name and structure but each of 
them contained some unique data.  I created a look-up from one database to 
the other and did a re-look-up to bring in the "outside" data.  Thus, I now 
had one complete data-set.  Then a few weeks later; I did a "save as; clone 
no records" and created another blank database to house some other unique 
data.  I then proceeded to manually enter data into this new shell database. 
All was well.

After entering numerous and painstaking records into the new database; I 
happened to notice that there was an 'un-needed' relationship stemming from 
the "re-lookup" event above.  I deleted the relationship. Much to my horror; 
when I returned to Browse mode; ALL the fields were blank and the Layout 
view showed "Table missing" in all the fields. All the data appears to be 
gone.

What the heck did I do and can I fix it?

Sob & thanks if anyone can help. 

It is probably just the relationship (table occurrence) that is missing, not 
your data.  Check the list of tables.  If the data remains, it should show 
how many records are there.  Then change your layout so that it references 
an active table occurrence.  If there is data, that should solve your 
problem.

Brent

"David" <john@aol.com> wrote in message news:3elhe.803$_f7.350@trndny01...
>I will try to recreate the scene of the crime
>
> I had a two databases that were identical in name and structure but each 
> of them contained some unique data.  I created a look-up from one database 
> to the other and did a re-look-up to bring in the "outside" data.  Thus, I 
> now had one complete data-set.  Then a few weeks later; I did a "save as; 
> clone no records" and created another blank database to house some other 
> unique data.  I then proceeded to manually enter data into this new shell 
> database. All was well.
>
> After entering numerous and painstaking records into the new database; I 
> happened to notice that there was an 'un-needed' relationship stemming 
> from the "re-lookup" event above.  I deleted the relationship. Much to my 
> horror; when I returned to Browse mode; ALL the fields were blank and the 
> Layout view showed "Table missing" in all the fields. All the data appears 
> to be gone.
>
> What the heck did I do and can I fix it?
>
> Sob & thanks if anyone can help.
> 

David said the following on 5/14/05 5:24:
> I will try to recreate the scene of the crime
> 
> I had a two databases that were identical in name and structure but each of 
> them contained some unique data.  I created a look-up from one database to 
> the other and did a re-look-up to bring in the "outside" data.  Thus, I now 
> had one complete data-set.  Then a few weeks later; I did a "save as; clone 
> no records" and created another blank database to house some other unique 
> data.  I then proceeded to manually enter data into this new shell database. 
> All was well.
> 
> After entering numerous and painstaking records into the new database; I 
> happened to notice that there was an 'un-needed' relationship stemming from 
> the "re-lookup" event above.  I deleted the relationship. Much to my horror; 
> when I returned to Browse mode; ALL the fields were blank and the Layout 
> view showed "Table missing" in all the fields. All the data appears to be 
> gone.
> 
> What the heck did I do and can I fix it?
> 
> Sob & thanks if anyone can help. 
> 
> 

I'm not certain, but is it possible you were actually creating the 
records in the related database, rather than the original? In that case, 
removing the relationship would loose access to them, but they would 
still be in the database where they were actually created.

Kent

Giving two databases the same name is asking for trouble, though it's
unclear if you really mean two databases or two tables (in the same
database).  Either way, Filemaker "sees" everything on all networked hard
drives & if there are more than one database with the same name, it will
invariably open and use the wrong one (Murphy's Law).

This means that you data may well have been entered into a different
version than you think.  Check out all tables in all files.  I bet the
data is there somewhere.  Rename your databases, DatabseA & DatabaseB, &
import from the incorrect into the correct file.

Steve Brown

In article <3elhe.803$_f7.350@trndny01>, "David" <john@aol.com> wrote:

>I had a two databases that were identical in name and structure but each of
                                 ^^^^^^^^^^^^^^^^^
 
>them contained some unique data.  I created a look-up from one database to 
>the other and did a re-look-up to bring in the "outside" data.  Thus, I now 
>had one complete data-set.  Then a few weeks later; I did a "save as; clone 
>no records" and created another blank database to house some other unique 
>data.  I then proceeded to manually enter data into this new shell database. 
>All was well.
>
>After entering numerous and painstaking records into the new database; I 
>happened to notice that there was an 'un-needed' relationship stemming from 
>the "re-lookup" event above.  I deleted the relationship. Much to my horror; 
>when I returned to Browse mode; ALL the fields were blank and the Layout 
>view showed "Table missing" in all the fields. All the data appears to be 
>gone.
>
>What the heck did I do and can I fix it?
>
>Sob & thanks if anyone can help.