I'm new to FMP scripting and working on cleaning up a rather large database. I need to create a script that searches for specific field value and then translates the data into values for several newly created fields. All are known values and text based fields. Basically something like this...
Hello,
Can anyone tell me what are the specific problems when running FMP Server off a undedicated W2K server? I would like to run it on a server with relatively low usage - but some. Basically just File/Print services for only a few people but FMP access for about 75 users. The manuals say...
Thanks for your help. The problem with a string of OR Is Null statements is that it also returns the thousands of records that have nothing in them. I don't want these - I only want records with some piece of the address.
Thx!
Here's the SQL from Access
SELECT Contacts_Full.ID...
I need to return contacts that have partial address info.
I've set up a series of queries in Access to find records with null values for Street, City, State and Zip (one query for each field)
I then wanted to combine the results of these queries to give me a list of records with any one of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.