Hi
I am looking into using filemaker 9 with external data source and i am just
wondering
how related tables from an external source act within filemaker.
lets say i have company and employee in mysql and the employees are related
to a specific company, when i add these two tables into filemaker, do i need
to remake the relation within filemaker or will this automatically be picked
up.
Thanks
CW
"cw"
> lets say i have company and employee in mysql and the employees are related
> to a specific company, when i add these two tables into filemaker, do i need
> to remake the relation within filemaker or will this automatically be picked
> up.
The SQL database itself knows nothing about relationships. You have to
connect the ESS table occurrences in FileMaker's relationship graph.
-jens
--
http://jensteich.de
Thats ok,
so in theory i could take my large filemaker solution which has about 80
tables and recreate the backend in mssql/mysql and set them up in filemaker
as ess table, recreate the old relations and have it working in the same way
as before
i ask this as i am looking into ways to distribute the FM database in two
offices USA and UK.
so i could run local copies of the FM frontend and have an sql db merging in
the backend between the two sites
Thanks for you help
CW
"Jens Teich"
news:uir21af0u.fsf@jensteich.de...
> "cw"
>
>> lets say i have company and employee in mysql and the employees are
>> related
>> to a specific company, when i add these two tables into filemaker, do i
>> need
>> to remake the relation within filemaker or will this automatically be
>> picked
>> up.
>
> The SQL database itself knows nothing about relationships. You have to
> connect the ESS table occurrences in FileMaker's relationship graph.
>
> -jens
>
> --
> http://jensteich.de
"cw"
> so in theory i could take my large filemaker solution which has about 80
> tables and recreate the backend in mssql/mysql and set them up in filemaker
> as ess table, recreate the old relations and have it working in the same way
> as before
In theory yes but in reality it will behave quit different compared
with a pure FileMaker solution.
FileMaker Server publishes data changes of one client close in time to
the other clients. Their screens are beeing refreshed without any action.
In an ESS setup 'other' clients get no information about changes they don't
do themselves without updating their data actively.
The record locking is different from a pure FileMaker setup too.
FileMaker server inhibits a second user to open a record which is locked
by someone else. ESS can't do this and checks later (before writing data)
wether the record has been changed by some else. This will be often too late.
FileMaker does state very clear that their application is not thought to
be an frontend for SQL databases for these reasons.
> i ask this as i am looking into ways to distribute the FM database in two
> offices USA and UK.
Terminal services?
> so i could run local copies of the FM frontend and have an sql db merging in
> the backend between the two sites
You have to check wether you can live with the inconveniences of ESS compared
to a pure FileMaker setup.
-jens
--
http://jensteich.de
Thanks for the input
>
> Terminal services?
>
this is how we were working until recently, but the lag of the remote
desktop is unworkable for the guys in the US so we need somthing local to
them
at the moment we have split the data in two databases US and Europe
but this leads to us not being able to see what the other half is up to.
other than Sync dek are there any other fm data syncronizers out there
>
the way we use the data, it is very rare the two people will be working with
the same data set at the same time
the only thing they may dislike is if there is any degradation in speed
cw wrote:
> Hi
>
> I am looking into using filemaker 9 with external data source and i am just
> wondering
>
> how related tables from an external source act within filemaker.
>
> lets say i have company and employee in mysql and the employees are related
> to a specific company, when i add these two tables into filemaker, do i need
> to remake the relation within filemaker or will this automatically be picked
> up.
>
> Thanks
> CW
>
>
create a very simple test db setup to explore the implications