External Data Source Change

[Tom Assia]

Hi everyone,

i'v got many copies of a Filemaker DataBase.

There is many changes week after week in this file put the tables are the same.

I would like to count for example how many records i have week after week.

For example starting month with 10 000 records, next week (another file) 17 654, next week (again another file) 18 765.

So your doing this i set in external data source, changing with a loop so i have $$path for example, then open template but data or not changing.

Maybe it's not possible to refresh the template even if the datasource changing ? The template is set with a table from the external data source

Don't know if it is clear

Thanks

Tom

[bcooney]

You have only one chance to set a $$externaldatasource. It cannot be changed once it is established. 

Why do you have several data files? Couldn't you use a date field  to count records within a range?

[Tom Assia]

Thanks for your replay.

I found a way bi using a second file which manage the first by opening, closing and then i can access to the datasource modified.

You're right, only one change by session.

I use it to list some weekly changes base on the backup i a have every week