Structure of data in Filemaker
Posted on 2004-04-23
Since Im new to Filemaker I would like to have an explanation how its data is stored and suggestion how to export it most efficiently. I hope I can make myself understood even though I use "Access vocabulary" :-)
I connect to a FM DB with a lot of information placed in different tables, and some fields use lookup and calculation functions.
When I try to fetch data from Filemaker, it seems to hang some times and I guess its because of the lookup and calculation functions. I try again and again and after some tries it works.
I only need raw data from some of the tables, not those calculations. Can I make FM to skip calculations when I get the data? I have tried to select only my preferred fields, but it doesnt seem to work.
Thankful for any clues / suggestions!
Btw, the FM database is not developed by me as you probably understood already.
I have experimented with both ODBC (Asp) and Datavations FM Connect.