I have thought about the following problem during days without any
success. I would appreciate if somebody could help me.
I have a database with more than 2000 records which contain among
others a field named "Title". This field contains the title in this

We use a Filemaker database to track the workflow on documents that are
modified enroute by several people. The documents themselves are in
Word, since we need to use the track changes feature.  Unfortunately,
sometimes versions get mixed up.

I am building a database for a disabled artists exhibition. Tables will be:
Contacts (with a lookup for Artist, Sponsor, Guest etc)
Organisations (ie agencies the artists are connected to)
Artworks

I was wondering if anyone knew how to do this in FileMaker Pro 9.
Basically I am using 2 tables, Engineer and Task, one to many from
engineer to task.
I created a self join from Task to Task by Engineer_ID_kf.

Hello again,
Unfortunately, I cannot post in the previous thread opened some days
ago (and I do not know why),
so I will try a new thread to keep talking on the matter:

I have an address list that has the name and address all on one line
(in one field). I.E. Bill & Sally Smith 1234 S Main St Denver CO
12345.  Our mailing software can format the address if I could just
get the names into their own field. I just can't figure out how I

I am using FM 9.3 to create a reference library for documents needed
in valuation of various financial assets. A table called Muni Bonds
has a field containing a URL of the document describing the bond in
detail. This document is in the PDF format, and could be anywhere from

three users do share access to a database.
Typical operations are scripted imports (with heavy auto-enter data
manipulation), which is done mainly by one
user. Other users do search/replace operations.

They all rhyme, but do they play nice?  I'm ignorant about internet
security, and have been hearing some alarming claims regarding opening
ports for Filemaker access.  The latest was someone who said that "all
the 5000 series ports are especially vulnerable and prone to attack."

I want to be able to migrate a large (many columns) FM table to a MySQL
view with minimal FM effort.  I want to normalize the data in MySQL and
present a de-normalized view for FM because of the many scripts that are
written for the current DB structure.  Can I do this by accessing ...

This story started with a FM database (FM9 AS, Windows, and FM9 adv.
win/mac clients).
For different reasons (not the last educational), I converted the
database to MySQL using ODBC and

how to use a calculation to return a Random number between 0001 and 9999....
the problem is I want the leading zeros, if they come up.
thanks
JP

RANT only.
WinXp, FMP 9.1 adv
Why should the scriptstep: Show Custom Dialog > Input Fields NOT keep itself
to the validation for the input field?

We use FM server admin 8. Recently, our server admin crashes very
often freezing our server.
Also, sometimes the client database closes itself.  Could anyone help
us solve this !!!!!!!

I have a strange problem with a scripted import in a file in FM 9.0v3
on FM 9 Server.  The file is multi-table, but for the purposes of this
script, only one table is used.  Essentially the script does the
following: