Hi All,
I have 2 separate databases set up on a small PTP network using FMP7 for 
both databases
I want to do table lookups on one db from the other db across the netwok. 
Obviously in this case FMP7 is going to be both a Client and a Source. My 
questions
1. Because I am communicating between FMP7's only do I have to install a 
driver
2. If so where do I find the driver and how do I install it
3. Do I have to install the driver in both Client and Source FMP7's
4. Because FMP7 networks only allow 6 users (Host + 5 Remotes) per database, 
will a Client making a SQL request to a Source cause the user count on the 
Source machine to step up by 1

Regards Ron H. 

Ron H. <ronald_h70@hotttmail.commm> wrote:

> Hi All,
> I have 2 separate databases set up on a small PTP network using FMP7 for
> both databases
> I want to do table lookups on one db from the other db across the netwok.
> Obviously in this case FMP7 is going to be both a Client and a Source. My
> questions
> 1. Because I am communicating between FMP7's only do I have to install a
> driver
> 2. If so where do I find the driver and how do I install it
> 3. Do I have to install the driver in both Client and Source FMP7's
> 4. Because FMP7 networks only allow 6 users (Host + 5 Remotes) per database,
> will a Client making a SQL request to a Source cause the user count on the
> Source machine to step up by 1

Don't use ODBC between FM databases. Set them both to be multiuser, host
them both, and do the lookups directly using the Field definitons in FM.

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

Hi Lynne,
As always, you have something good to say. I did not realise that I could 
make Table Relationships across db's. I tried it and it is simple. Thank you
Best Regards Ron H.

"Lynn allen" <lynn@NOT-semiotics.com> wrote in message 
news:1h12y5z.1lqzfxg10kzgloN%lynn@NOT-semiotics.com...
> Ron H. <ronald_h70@hotttmail.commm> wrote:
>
>> Hi All,
>> I have 2 separate databases set up on a small PTP network using FMP7 for
>> both databases
>> I want to do table lookups on one db from the other db across the netwok.
>> Obviously in this case FMP7 is going to be both a Client and a Source. My
>> questions
>> 1. Because I am communicating between FMP7's only do I have to install a
>> driver
>> 2. If so where do I find the driver and how do I install it
>> 3. Do I have to install the driver in both Client and Source FMP7's
>> 4. Because FMP7 networks only allow 6 users (Host + 5 Remotes) per 
>> database,
>> will a Client making a SQL request to a Source cause the user count on 
>> the
>> Source machine to step up by 1
>
> Don't use ODBC between FM databases. Set them both to be multiuser, host
> them both, and do the lookups directly using the Field definitons in FM.
>
> Lynn Allen
> --
> Allen & Allen Semiotics        www.semiotics.com
> FSA Associate       Filemaker Design & Consulting