the subject is a bit misleading. this is my situation:
right now i have my "Gig" database (im a musician) in FMPro. i want
this online so heres what i do now:
1/ i manually run a simple script in FMPro that exports the database to

Is there a way of using a calculation field to tell me how many times a
value has been used/entered in the same field across all the records?
I have a field and i need to know when the value has been entered 3
times or more in previous records...  so i am basically looking for a

What is the easiest way to format an address? I have fields for city,
state, and zip...but in my printout I need them to format properly. Is
there an easy way to pu tthe info calculated into one field so that is
shows up like this:

this may be really simple, but i trying to find a method of allowing my
users to perform a search on records on one form/layout, and the
results be shown on another.
In one example, i have a 'letter' template created on a layout which is

Is there a way to script the number of portal rows?

I need to migrate a Filemaker database sitting on MAC onto a MSAccess
database on Windows.  
I was just provided a *.dat file as a sample.
I don't know anything about Filemaker (and I don't own it), and here

I inherited a couple of old, small databases in Mac fp5 format.
The new OS X server has FileMaker 8, and client installs for 8. I
installed 8 on a mac and when I opened one of the old fp5 databases it
prompted me to save them somewhere safe while it upgraded them to fp7

I have 3 Tables
Invoice (Master with portal)
Customers
Parts

I have a database which is basically a contact management system. On
the main window containing contact info, i also have a a portal
containing information/records on related notes for this contact
(numerous notes per contact). I have a button that opens a new window

LS.,
How to email a record in a certain layout? I am working with FM 6.0
thanks

Scratching my head on this one.
I've been working on a database that migrated it's way from FM6 to the
current FM8.
When I print from this database and select the PDF option in the Mac

Hope someone can help with this. I've setup several self relations in FM
8 Advanced that simply won't work and I can't understand why. The setup
is:
Relation:

I hope this question is not too silly.. I am developing a portal with
Dreamweaver MX connecting to a FileMaker Pro 5 database. ODBC
connections works well, Dreamweaver can read FM's table data, but..
there's a but: in server responses, text field are truncated to 255,

FMP 8.02, WIN XP
When we try to send an email from FMP, MS Outlook give us a warning, saying
that,
"A program is automatically try to send an email on your behalf. Do you want

Each time I open any database in FMP6, a new file called 'FMWSDEBUG.txt'
is created in the folder containing the various individual *.fp5 files.
This does not harm anything, but it's a bit irritating. I just put it by
hand in the trash.