I work with FM 8 and would like to know if there is an equivalent of
mysql "select distinct name from tablename order by field2" in FM 8. I
would want to create a php drop down of distinct names and have no
clue how to do it!

Is anyone that know if there's a new version of FM soon ?? I still have my 1
years upgrade and I was ask to upgrade soon.... but if FM10 is launch soon,
maybe I won't need to :O)
Thank you

We just wanted to let you know that We are highlighted in the blog of this
up
and coming company Uniloc. http://redsky.uniloc.com/blog/?cat=1
We are using their main SoftAnchor product for  FileMaker plugins for

Dumb question of the week. Filemaker 6 (client won't pony up for upgrade

that flags records as "Unique" or "Duplicate". It's based wholly on a
single email address field. That part works fine when I'm in Show ...

I have added a calculated container field to the database. That is, a
container with a dynamically created reference to an image. If the
image exists then it displays in the containter field. Fantastic.
The calculation looks this this...

I am running Filemaker 8.5 advanced and am trying to open an XML file.
Done the following:
Open, Click on the file an come to the Select XML  and XSL options.
I specify the file and select continue (making no stylesheet selection )

I have an item that is not working as I expected in FileMaker 9.0v3
Pro.. Maybe I'm just going down the wrong path. I have set up the
following skeleton to test this method (of course, it doesn't work as
I want):

I need help! I have an ancient project in FMP v6 that uses CDML that I
have convinced my customer to upgrade (finally) to FMP v9. But now the
CDML - XSLT Converter is no longer included with the installer. Does
anyone have an idea where I could find it? Or even better could

I have some printing to be done on a NCR 3 copies with a DOT printer with
FM9 under XP.
Many other software, like Crystal Report, when selecting as default printer
the Dot printer, will give acces to printer font, for faster printing, and

Alrighty...  so I've run into an apparent limitation of filemaker that
I can't seem to work around.
I'm doing a very simple report, find records between date x-y for
customer z, I've done it a thousand times. One of the requirements is

I have a drupal module written in php interacting with FileMaker 8.
This module creates  a new record and sends out an email with all the
details in the email from the new record. But, very often unexpectedly
it throw up an error and fails. Is there a way I could log errors in

Hello - I've looked for 2 days to do this but no luck so maybe someone
can solve this for me in 30 seconds!
I have a FM DB.
I have a bunch of images which are in a folder on my computer and I

Free Auction Software - FREE AUCTION SOFTWARE
************************>>>>>>>>>>
http://freesoftware20.blogspot.com

We use FM Server 8. Recently our FM databases have been crashing
often. The status in the server admin screen gets set to "Closed" thus
taking the entire site down! We have to manually log back onto the
server and then set them back to normal status on the server. We use

How do I perform a lookup from multiple tables.
I enter a name on an enrollment form
I want address from table 2 or table 3 or table 4, etc.
Guy