[[ This message was both posted and mailed: see
the "To," "Cc," and "Newsgroups" headers for details. ]]

I have several related FM 6 files that I've converted to FM 7, in the
most basic way possible: keeping each table as separate file rather
than combining all tables into one file One file in particular keeps
"forgetting" its relationship to another file. Can someone suggest a
solution?

In article <160720051358046664%mrehab (AT) mrehab (DOT) com>, <mrehab (AT) mrehab (DOT) com>
wrote:

It may help to have different files in the same folder, so that file
references are as simple as possible. I don't know if that will make a
difference, but it might.

How did you do the conversion? The recommended way, which seemed to
always work for me, is to convert them all at once, by dragging them all
together to the FMP 7 icon. That way the file references and
relationships all get converted together.

That still leaves them as separate files, but the file references and
relationships should be good.

Later, if you want to combine some tables into one file, you can do that
by building the tables and doing data import. There is no automatic way
to build a single file with multiple tables by conversion from multiple
FMP 6 files (at least no automatic way without using some third party
software).

Bill Collins

--
For email, remove invalid.

<mrehab (AT) mrehab (DOT) com> wrote:

I encountered this with FM6 files, hosted with FMServer. The hosted
files were fine, but when I stopped the services and opened the files
with regular Filemaker, certain relationships were broken every time.
Putting the files back on the server "fixed" it every time, so I stopped
worrying about it and just dealt with it as necessary.

Someone suggested that something about the OS (WinServer 2003) was
conflicting with the FM Pro ability to set file reference pointers that
*didn't* occur under the FM Server service. Now, after several months
of this, something I've done has permanently fixed the problem and that
file now finds the relationships properly.

Several things I might suggest:

1. Fix relationships, don't close the files, clone both, import working
data.
2. Make a new relationship in each file, to the other. See if it sticks,
or brings in the old relationships.
3. Make a new relationship, clone each file, etc.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting

Thanks to all, I followed the suggestion below and it seemed to do the
trick. I then just had to export/import any recently input data.

Regards with all my thanks ... mike branagan

In article <bbcollins-C39018.20234716072005 (AT) news1 (DOT) east.earthlink.net>,
Bill <bbcollins (AT) invalid (DOT) earthlink.net> wrote: