Hi people, I'm looking at possibly buying filemaker pro 8.5 as an interim
database in the non-profit company in which I work. I currently use multiple
spreadsheets, with multiple lookups to import data into a master
spreadsheet. There's a couple of questions I have which I've not been able
to find answers to my satisfaction so far.

Is filemaker a true relational database? As an example, I'll need to input
from about 40 odd different forms to a master which contains the most up to
date data that I require. The data will be based on a selectable name field.
Most imports will be date fields dd/mm/yyyy, however some will also be name
(SURNAME, Firstname/s).

Will filemaker import data from Excel into selectable tables?

Are reporting functions fully customisable? For example monthly reporting
will look for all fields where there is either no change, or a change within
a given month.

Are calculation functions OK? As an example, if an event/s occurs midway in
a month, can a report calculate the number of days the event/s has been
current and add them to those records where the event has been current for
the entire reporting period? And in line with this, differentiate between
periods of time?

This is perhaps not to clear, but I hope that perhaps if not a direct
answer, someone may be able to assist me with a URl that goes a little more
in deoth than those I've found so far.

Thanks

K

In article <o4VBh.558$8U4.31 (AT) news-server (DOT) bigpond.net.au>,
"Ken" <kwlumley (AT) nobigspampond (DOT) net.au> wrote:

The general answer to all your questions is yes, FileMaker is/can do it.
Specifics would need to be worked out.

You need to get a basic understanding of FileMaker, tables, table
occurrences, relationships, calculations, lookups, scripting and
layouts. FileMaker allows setting up very powerful, complex relational
databases. However, you need to understand the "grammar" of FileMaker to
see how to do it. The structure of the best solution may be quite
different from the structure of the multiple spreadsheet approach you
are using now.

Don't know why it would need to be "interim," no reason it can't be
"final."

--
For email, change <fake> to <earthlink>
Bill Collins

In article <o4VBh.558$8U4.31 (AT) news-server (DOT) bigpond.net.au>, "Ken"
<kwlumley (AT) nobigspampond (DOT) net.au> wrote:

As a non-profit organisation, you may qualify to get FileMaker Pro at
educational prices.

FileMaker can only be installed on one computer per license, so if you
need multiple computers to have access to the database you will need to
buy multiple licenses of FileMaker (at least, if it's a complicated /
heavy use database you may need to have the server version of FileMaker
as well, whatever they call it these days - it seems to change with
every release).



As Bill has already said, FileMaker can do this (although it will no
doubt require careful set-up and some re-working of the data) ... the
real problem will be can you do it?? )



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

What we're telling you is that the behavior you describe cannot be replicated, so I am wondering if it is entirely something else happening.

Is it actually that an existing Maximized window is minimized when a new window is opened?

Is this what's actually happening?

Make the window one pixel smaller than max before you open a new one:

Move/Resize Window [ Current Window; Height: Get ( WindowHeight ) - 1 ]

Matt

On 02/19/2007 13:32:33 "Hatzigiannakis Nikos" <ypai (AT) aigaio (DOT) gr> wrote:

Oops, sorry, clicked in wrong place. Ignore.

On 02/19/2007 16:14:03 Matt Wills <I'm (AT) witz (DOT) end> wrote: