Is there a way with the web security db to restrict browse access to
certain ip addresses?
Basically I want to enable web companion sharing on a database, to
enable certain intranet functions.

I am working with this fp5 file with over 5000 records. Every record has
something like 40 fields.
The db is describing (in great detail) texts in a large number of pages and
chapters from books. Every field can contain texts (multiple hitwords) from

I've been away for sometime so greetings to all at the best FM group on the
net. I've got a field containing numerical values ranging from -3 to +3 and
a want to set the text colour according to these values - red for -3 ranging
through to green for +3. Is there any way of achieving ...

Can anybody help my.
I work with filemaker 5.
When i enter a field. The rest of the fields is marked. Can i put the field
marks away ?

I have been asked to 'get into' the data behind a Compiled Filemake 5.5
database.
This is a VERY small database with <10 Suppliers, 100 Invoices and a few
other related data tables.

I have 2 files with addresses but 1 file never has the last word
(i.e DR, ST, AVE, AV, BL, BLVD, WY, WAY, DRIVE, AVENUE, STREET, PKWY, LANE,
LN, CT, COURT ...)
I want to use them as my related field but I can't figure out how due to the

I have a many-to-many relationship with a join file between a Client
file and a Keyword file so that in the Client file I can show in a
portal which keywords clients are interested in, and in the Keyword file
I can show which clients are interested in any keyword.

I have a simple name, address database for business contacts which are then
categorized in the same database.
Sidebar: The database was created and working on a Mac (OS 9) in FMP4.0. On
two PCs' each running Windows XP, (however, Filemaker was installed when it

I know there are probably numerous ways through the web companion web
server but...
I have a few databases that generate content for our website.
I have a few databases that I use to generate list view in internet

I would like to use the excellent front end capabilities of FileMaker
but at the same time use the excellent back end capabilities of SQL
Server to develop a new data entry sytem for a large business
directory.

I'm doing some debugging on a rather complex solution. I'm experiencing an
intermittent bug that I can't seem to track down.
On occasion, I'll get the message that "This file is damaged..." followed by
"Filemaker has performed an illegal error..." and then FileMaker goes down.

I builded a script with the following:
select count (*) from v_employee
where home = '345'
how do I update a record with the result of my SQL? Appreciatte any help.

I want my database to feel less clunky when switching from one file to
another.  I'm using freeze window command, but it still doesn't feel
seamless.  Any tips on how to better implement the freeze/refresh commands?
Marc

To make my question simple, i'm looking for a way to store a
calculation field that can't be stored directly by Filemaker. I want
to store the result in another field that can be indexed to make a
relationship. A constraint: it has to be dynamic, just like a calc.

An Applescript bulk loader I'm working learns all the field names and their
creation order in the database I'm loading, so that I can construct a valid
'Create Record' command.  Briefly,
The following command gets the names of all the fields in the DB (Filemaker