Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

FileMaker General Discussions

Older discussion forums for previous versions of FileMaker

  1. I have a list on a floppy that I want to import into FileMaker 6.0 but the line information is separated by a space like; Gary Stemper 12551 Wiffer Way Conroy, MI 66321 800/555-1212 So when I try to import it I get; Gary Stemper 12551 Wiffer Way Conroy, in one field and MI 66321 800/555-1212 in another field Is there any way that I can get first name, last name, address etc. into each of the proper FMP fields? Thanks, Carl

  2. We have numerous databases. We are running FMP 5.3 (recently changed from 4). We also recently created several relational databases. The problem is that the relationships keep changing? Let me try to explain. We have a relationship setup on a College/Dept File and a Student Record File to say "match the "academic degree abbreviation field on the Student Record File (SRF) to the "degree abbreviation" field on the College/Dept file. When that relationship matches, the relationship works and the fields from the College/Dept file show on the SRF. We have other databases that refer to this relationship as well. One of these is a Graduation File. We have many users who…

  3. FileMaker Legacy fp3 and fp5 · Started by esimon,

    hello i have a pb with filemaker server 3.0 v4 et filemaker pro 4.0 my client don't see my server my server is windows 2000 server and my client is windows nt4 my protocol is tcp/ip please help me esimon

    • 5 replies
    • 1.2k views
  4. FileMaker Legacy fp3 and fp5 · Started by hidoe,

    Has anyone tested this out to see if it is more stable? I read through the forum and can't see having to reboot the FMU daily to prevent it from crashing. Also, I've been manually opening the database files every time the server needs to be rebooted. Is there any way to automate this? With the standalone, I could put aliases in the Startup folder. With FMU, I have to open the files via the "Open Remote" menu. Any suggestions?

  5. Hi ! I need some help in writing a script which will put out the records of only students coming from MS, TN, TX, AL, AK, GA My database contains the following fields Student Name, SSN, Address, City, State, Zipcode, Phone Thanks, saraswati

  6. I know that this issue has already been discussed on this forum, but perhaps there have been some new developments that can help me with my problem. I run FMU 6 on two old Pentium II machines (one with Windows NT, one with Windows 2000) and more and more frequently FMU takes up all resources, rendering the computer unusable (more so on Win2000 than NT). Restarting FM helps, but only for a limited time. I cannot imagine using slower computers, albeit such a solution has been proposed for this problem. In fact, I am just about to move my servers to faster computers. All previous discussions dealt with FMU 5.0 and 5.5, apparently the issue is still a problem with FM 6. An…

  7. I have a stand alone in a customer site where the screen seems to Zoom to 150% on it's own. There is no script or button available for the user to do this.(that I know of) I saw it myself and one specific layout was enlarged and another wasn't. If you exit and re-enter it's fine. I added a button with a script to set zoom level to 100% as a band-aid. It happened again and my button didn't help. Does anybody know what could cause this? Larry

  8. FileMaker Legacy fp3 and fp5 · Started by schda,

    Just started with FileMaker and was wondering if it possible to make use of html to include a link to a website within a field. I would like to include the web home page of clients and consultants in each record with a link that will launch my browser and take me directly to their page.

    • 5 replies
    • 876 views
  9. FileMaker Legacy fp3 and fp5 · Started by pmusaev,

    how do i perform an 'OR' in my find requests? i need to find a range of values in a certain field and another range within another, but they need to be related by an 'OR' statement. any ideas?

    • 15 replies
    • 1.7k views
  10. What is the best way to automate the creation of graphs from data within filemaker? Should I learn Applescript and automate the export and generation of graphs in Excel or Appleworks? How steep is the learning curve? Would QuickKeys work for this one purpose? I appreciate any suggestions!

    • 4 replies
    • 1.1k views
  11. FileMaker Legacy fp3 and fp5 · Started by Anh_Tran,

    Hi All Before I can click in a field data and use copy and paste ...it works fine ...but now I click in a field and I can not use copy and paste ...someone has an idea why? Thanks Anh Tran

  12. I have a [Customer] file where all customers reside. An [invoice] file where all orders are placed and [Line Items] file where all of the line items reside. From the [Customer] file I send faxes to customers promoting a product, let

  13. FileMaker Legacy fp3 and fp5 · Started by bobbyt,

    I'm am having problems linking an InDesign document in a container field. It appears that FileMaker is truncating the InDesign extension to 3 characters (*.indd to *.ind). Does anyone know a workaround for this problem?

    • 0 replies
    • 651 views
  14. FileMaker Legacy fp3 and fp5 · Started by esimon,

    bonjour, voici le message d'erreur : filemaker ne peut heberger un des fichier a cause d'une erreur reseau le fichier de type multi-utilisateur ne seront pas disponible en reseau (erreur 10048) meric de votre aide

  15. Hi, I am using win2000 server with IIS5.0. I am trying to install the Web server Conector and I received this message: "You must configure a Scripts virtual Directory before filemaker WSCS-IIS can be installed" Can someone tell me what to do? thanks, alvaro

    • 2 replies
    • 1.7k views
  16. I've had no luck finding any info to help me copy my db to a cd so I can work on it at home. I get it copied but it is read only when I open it at home. Any help would be great... Greg

  17. Hi, Sorry for such an elementary post but I'm completely new to FileMaker. In any case, I'm using FileMaker Pro 6.0v1 for Windows and am a bit startled that there doesn't appear to be any way to "undo" the last action (i.e., if you accidentally delete something, most programs will have an "undo" button or command that will undo the most recent action). So, does FileMaker not have this? Or, by chance is it availabe in a newer version? I did notice there's an update to 6.0v4 so I didn't know if this might have this feature. I'm simply terrified of deleting an entire database and not being able to retrieve it. Thanks for your help.

  18. Hello I think I m the only Greek in this forum .... hahaha anyway sorry for my not so good English My real job is graphic designer (I design cd covers, posters, catalogues for music company's) Also I write articles in local graphic design magazines. All these began the moment that I realise the majority of graphic user interface and the Graphic design limitations of file maker pro. In the begging I experiment with graphic user interface and now I write code... for scripts and calculations ha ha ha ha I have read at least 15 books of database design theory ( General, SQL, PHP and FMpro ) and practice and I like it very much. It is a challenge. …

  19. FileMaker Legacy fp3 and fp5 · Started by esimon,

    hello i would want to do a migration between my server nt4 (with filemaker server 3.0v4) on my server windows 2000 server can you help me or where can i find a install guide

  20. hello i have filemaker server 3.0 v4 on windows2000 server and i would shared my database for windows nt4 client can you help me

    • 4 replies
    • 950 views
  21. Hi there I need your advice I have a very serious problem. I develop a huge music database system. A music statistic tool, A music marketing tool a logistic tool (all in one) (not for home users but for a discography company's). I wonder what can I do with the large amount of data and file limit size (2Gb) of file maker pro Let's explain my self... I have to store 100.000 ALBUMS (CD's Mc's DVD's etc) that means about 1.400.000 songs (tracks) until now everything is ok but as I said previously the database is for a discography company ' s. That means that I have to store and the Credits for every song (lyricist - composer - producer - gu…

  22. I am a first time user of a Filemaker 3.0 Pro and I have a database that has Names, Addresses, & Phone Numbers in a list. The problem is that the Phone Numbers are a straight 10 digits (without the hyphens). I need to reformat the field to include the hyphens. There are approximately 3400 entries on this list. Too many to add 1 at a time. Is there a way to add the hyphens to the numbers all at once. I am using Windows 98 and am a relative novice to computers, but do possess some very basic skills.

  23. I want to insert in a Filemaker database many images located on a disk. I don't want the images located directly in the FM database. I have to insert about 20 images for each records of the database. I want a single field for the image that can display all the images one by one with a click on a buttom. Can I do this in Filemaker Pro ?

  24. FileMaker Legacy fp3 and fp5 · Started by ernst,

    Just installed MacOS 10.3 a.k.a Panther on my dual 867 Mhz G4. Installing the OS and drivers for the USB ISDN modem went really smooth, was up and running in half an hour or so. Then I 'did' Filemaker 6.0v3 which also seems to be work straight away, including network access. No noticeable performance changes compared to running it in 10.2.X , but I was not expecting that anyway. The overall impression of the OS is really nice and snappy' and it has a lot of neat features, without going 'over the top'. Fast-user-switching' (One of my favorites) is a function that CAN cause problems with Filemaker when multiple users of a machine try to open the same local fil…

  25. we have two very serious problems: 1) when we recovered the FileMaker Pro 4.0 this morning, the system didn't show up any file lost or skipped after finished, however, we really did lost some records. what should we recover it? 2) we have two database(1 good, 1 bad) in FM4 and we like to retrive some good records from the bad data base and import the record to the good databas. How do I export the fields in the same layout formats of found records of bad database ? I did try to export all fields to a file in FM format, but the layout aren't the same. Thanx George Hsu

    • 6 replies
    • 1.2k views
  26. I just received shipment of FM Unlimited. There is supposed to be a disk in the box, right? I didn't get a disk. Also the user guide is for FM Pro. Isn't there on specific to FM unlimited and Web Connector? Thanks, Mark Durgee

  27. Using Windows XP, I am trying to run Filemaker 3.0v5. (This has happened on two computers that have been set up for me to use, same problem). The problem is: As I try open a database that I created last week, occasionally it brings up this message: "The instruction at '0x77f58267' referenced memory at '0xfffffff8'. The memory could not be read. Click on OK to terminate the program." Then the program dies. And when Filemaker doesn't bring up that error, it won't even open up the the database I want to open up. It was just crash/close automatically. (This happens on any database I am trying to open up. The specific databse that I want open, I …

    • 6 replies
    • 1.1k views
  28. Hello, I am running FMPU 6.0v4 (Educational) on Mac OS X 10.2.8 (the last one) / 733 G4 Quicksilver / 1.25 Gigs ram Over the last month I have noticed what I thought were increasing crashes, however after looking at 'top' when these things occur, FileMaker is actually just taking up 96-98% of the CPU. Normally FMP only takes up about 10-12% and spikes to 20% during heavy periods of traffic. So this is not a crash situation as the system still runs, no crash dialog boxes come up, it's just using too much of the CPU to serve any more pages. After reading other posts here about the many problems with FM crashing, I wanted to see if this may actually be t…

    • 3 replies
    • 1.3k views
  29. I do not want someone to be able to go up to the Records menu and select "Delete All Records". How do I keep it from happening? Thanks, Bill

  30. FileMaker Legacy fp3 and fp5 · Started by OffTheDeepEnd.com,

    Quick Question... I want to create an "If" script function, there are 4 values that the field can possibly contain, "Y" "Z" "A" and "N". If the field contains Y,Z,A then filemaker needs to perform that specific script, but if the valus is "n" then it need to run a different script. I cannot figure out what the if function would be set up as...

  31. It might just be the point that the coffee has not kicked in yet or maybe I am just going brain dead but here is my question. I need to create a script to print a record which is easy enough, but then also I need it to insert the time that the script was run and also the current username in the same field. This is probably just a simple calculation... Does anybody know what it would be? Thanks, -Austin

  32. FileMaker Legacy fp3 and fp5 · Started by nelliott,

    I have a database with 150,000+ resumes/cvs on and it is fast approaching the 2GB limit. Ideally I don't want to split the records into two separate databases as it will make searching cumbersome and slow. Any ideas on how I can reduce the amount of memory that is currently being used? Thanks Nick

    • 13 replies
    • 1.5k views
  33. I have an FM 6 database with 150,000 + records which I update on a weekly basis from sales transactions. The ideal way for the database to appear is with the most recent imported records at the top. Since this is a chronological history of sales, this would display this most recent sales first and the oldest at the "bottom". I am able to permanently Re-sort the database by sorting it and then importing it into a clone of itself, but this is a very time consuming process (it takes about 2-3 hours for the import). Each time I update the database with the most recent records, they show up at the "bottom" of the list, instead of at the top, and then the database is no longer …

  34. This error message keeps coming up when opening a database created in FileMaker 3.0 on Windows. The computer may or may not have had a virus. In addition, we cannot print to one of our printers from Filemaker, yet it prints to two of the other printers on our network fine? We have recovered the databases in Filemaker, reloaded the Filemaker program, and reinstalled the drivers for the printer. Yet we still get the error message "this file was not closed properly, Filemaker is now performing a consistency check"? And, when I go to print to one of the printers we get another error message that says "this program has performed an illegal operation",and it gives us the…

  35. I have a database with several records. Among the other, field A is indexed, B can't be. Very often I perform a find inserting criteria on A and B. for example A=192 B>0 Unfortunately (and without any logic) FM first searches for the records matching B>0 and then constrain the found set to the records that match A=192. This way it takes 10 seconds on 30000 records. If it would operate the opposite way (searching for the indexed field first and non-indexed after) it would take 0,1 seconds. In fact the indexed search would be performed very fast. The unindexed, that is slower, would be then performed on a smaller set (20 records VS the w…

    • 24 replies
    • 2.2k views
  36. FileMaker Legacy fp3 and fp5 · Started by gwmbox,

    H all Can someone please advise what are the 'limits' to the so called 'unlimited' version of Filemaker. I have a solution that has 36 files in total hosted, guests that access it (via FM standard) only open the files they need, which may be from five to ten each (I have it set up to close off files no longer required after login etc to minimise open files on the user end (concurrent connections)), but I have just struck a host limit error - haha - so much for unlimited! Ok on from that will FM Server solve my problem? Greg

  37. Is there a way to use tokens that carryover to a popup window? Currently I keep losing the thread. Or can I use cookies to suppliment for a token, and some how import the data back to the token? I heard good things about Lasso and session threads. But not sure what the limits of cookies and tokens are.

  38. Here is a hopefully simple question that I cannot figure out. I have a 20 value number (i.e. "1234567894561233 123") Everything after the space I do not need. Is there a way for filemaker to delete the last 4 values in that number without a person maunally deleting it. I would like the number just to be "1234567894561233". The numbers are imported from a txt file preformatted like the above example.

    • 2 replies
    • 2.2k views
  39. Guest
    FileMaker Legacy fp3 and fp5 · Started by Guest,

    I just finished migrating our office from classic mac 8.1 to OSX 10.2. The biggest hold up was moving the user dictionaries. I exported as text in 8.1, but could not import in as text in OSX. The staff was not happy with me as there are thousands of medical terms accumulated over years of use. Now that i have survived this, is this a known issue? Does anyone know of a medical dictionary that can be imported into FMP6/OSX? Thanks Running FMP Server 5.5 (OSX 10.2) and FMP6 clients (OSX 10.2/ NT)

  40. I am new here so I was not really sure where to post this. I am trying to find a way to change the initial view that FileMaker starts with to 150% instead of 100%. Any ideas? Thanks, Randall

    • 3 replies
    • 1.9k views
  41. I have any invoicing system. Databases - customers and sales items. Customers has a layout - Invoice. Some customers that have a small amount of sales items, they only need a 1 page invoice, but a some customers need a 2 page invoice. I can't figure out how to get Filemaker to continue the sales items on the second page of the invoice. I'm using a portal in the customer database, and linking the sales items fields. ideas?? Thanks [email protected]

    • 4 replies
    • 3k views
  42. Folks, How can I setup my home PC as a web server and have it host filemaker databases. I want to create a web business idea and gauge its success before splashing out cash on hardware or hosting. I have an ISDN modem/link, filemaker 5 unliimited, windows 98se. Thanks

    • 4 replies
    • 1.3k views
  43. Where is a good place to get layout ideas, themes and objects like buttons etc.? I've found one fmp db that has a bunch of buttons but I am looking for a new 'look' for a new project. I don't just want the FMP themes cuz they are just background colors and field fonts, but rather a whole sample user interface that I can take. Charles

  44. Hi All, I recently got myself a Tablet PC, and being a Filemaker fan, one of the things I was hoping for was the ability to enter data directly into fielmaker using the pen. Did a search on these forums and it seems that many people have been trying to workout a way to do the same thing, usually so they can enter signatures in. As far as I could tell, no one came up with a good answer, and this surprises me seeing as the answer turned out to be fairly easy (at least in theory). First off, you need to have the Office XP Pack for Tablet PC installed (free from Microsoft, although you probably also need to have office installed). Here it is, the way it wo…

  45. Hi, I'm new to FM Pro having just purchased it. My business partner has a copy of the Mac version 6 and I have the Windows version 6. We want to share a common database with one another that we can both access and update from our separate locations. We both have broadband and we also have a domain that is hosted. I've read about sharing files over a network but it appears that only works for a LAN and we don't want to use the Web Publishing option. Can someone steer me in the right direction and let me know what the best option(s) are for us? Thanks very much. Cheers, Carl

  46. i would like to have some buttons in the header and have a table view for the body, how can i do that?

  47. I have been experiencing this error on certain workstations running W2K and FileMaker Pro 5v3 and 5.5v2. As soon as the user attempts to run FM they get a Windows error stating that: The instruction at "xxxxxxxxxxx" referenced memory at "xxxxxxxxxxxx". The memory could not be "read". Click on OK to terminate the program. I have done some web searches, and I have found incidences of this error dating back to 1998...but no solutions. Has anyone else experienced this issue? I believe it has something to do with file permissions, since I can run the app fine as a local or domain user with Admin rights...but the other users with restricted access cannot. No…

  48. Hi, We're building a FMP 6 database that is basically a library catalog of museum artifacts. Our loans system is dependent on dates example: due date=today +14 ; no. of days late= today-due date etc. If we go into the computer's settings and change the date, it then affects dates of all new loans. For eg. change the computer's date to 1/1/1900 and the due date with be 1/15/1900. Is there a way for us to "lock" the date system used on the computer so no one else can change it? Or is there a plug-in or file that we can get today's date from, rather than use the computer's settings. Eventually, we'll be accessing the database over a server. Please…

    • 2 replies
    • 719 views
  49. Hi there, just received some feedback from my customer, ther said that can we set the tab key to enter key on numeric keypad. They found that they are more like to use enter key on the numeric keypad in order to go to next field, they say it is more faster for data entry, and most of the software there using in pc are all using enter key for go to next field. I know that we can use a looping with pause/resume script to do this, but pause the system is not the best way to solve it, they need to enter until end of the field then only will exit the script.So is that have any way to switch the function of tab key to enter key in FM? Regards, Henry

    • 4 replies
    • 875 views
  50. I have a filemaker runtime solution that I have been working with for the better part of a year now. It is operating commercially on 40 computers. Of course, over the year it has evolved as all solutions do. Recently I employed an idea that I've had for a while to incorporate images in a sort of "screensaver" kind of operation. Part of the requirement was having fairly up-to-date access to the image files, in this case a series of .jpg and .gifs. All 40 computers have a shared network drive where the images are stored. I instigated this "upgrade" by using a plugin from TroiAutomastering. Initially, I used the plugin to just display the image in a global con…

  51. FileMaker Legacy fp3 and fp5 · Started by Wing Fong,

    I have a layout with the following parts in it: Title sub summary sub summary body footer When I view it in browse mode everything appears as I expect, when I switch to previw, everything appears as I expect again. Then, If I perform a find, the browse is correct, but when I switch to preview mode, everything in the two sub summary parts does not show up. If I switch back to browse they are there. If I show all the records and then go back to preview the sub summarys don't show up again. I've checked to make sure all the elements in the two parts are set to print, and can't think of anything else to check out. Any suggestions are …

    • 12 replies
    • 1.1k views
  52. Is there anyway to open a database created in FM 5 in 4.1? I have a file that I need to open, but I only have access to 4.1. . .

  53. Hi-- I'm in FMP 6.0.4 in 10.2.8. I have a bunch of fields with specifc formatting, such as font and font size, but when I paste text into those fields, the formatting is always that of the original source. More than that, in a portal, a related field is coming up with the formatting of that field in the original file, not the portal. Is there any way I can get this to stop -- it's really a pain. All My Best, Jeffrey

  54. I'm thinking of moving from FM6 Pro to FM unlimited to accomodate more users both internal and external. One of the questions I have is with using IIS with the web connector. My solution is hosted on an NT box with IIS. I like to know how the security databases interact with NT security. I don't want our internal users to have to type in a password since they are already logged into our domain. The internet users should have to log in to obviously keep unwanted people out. Can I use NT authentication only as a security strategy? Or do I have to use the web security databases in FM? Or can they be mixed? I'm asking the question because there is no trial version to check ou…

    • 3 replies
    • 1.1k views
  55. I've been looking for a Web Hosting company that supports Mac's and offers both, hosting a Web Site and offers help in it's design. It must be the "design" part that does not support Mac's. But I'm really not sure. So far the Web Hosting companies I've found only give a list of Windows operating systems. I hesitate to say this on the forum, but "can you tell me where to go"? Thanks, Bill

  56. I am an Access programmer, and have been asked about developing a database in FileMaker Pro. Does FileMaker Pro actually have it's own programming language? How does the development of a FileMaker Pro database differ from an Access database? Appreciate any information. Thanks, BJS

    • 12 replies
    • 2.1k views
  57. I'm working on converting a project from Access to FM6. On Access, I have a file that stores all the code (Forms(Layouts), Reports, Tables(DataBases), Macros, VB, etc) and another file that stores all the data. The Tables(DataBases) in the main file are "linked"(they point) to the data file, so whenever I need to make changes to the Forms(Layouts) I don't have to interrupt work on the data file. I make my modifications to the main file and then replace the main file in my customer's host with the newly updated main file, all without affecting the work being done on the data file. How can I accomplish the same effect with FM6?

  58. Hi, I have a database let's say with 3 fields QTY DESCRIPTION PRICE how can i do it, that when PRICE has a value, it adds a new record automatically and places the input cursor in the QTY field. I appreciate any help in this. Faustino

  59. Okay, this one is baffling even the people at Microsoft. This one woman attempts to use the application as a guest. So she clicks on the icon and it attempts opening the files from the FMS as guest. It gets about 2 or 3 DBs open and she gets the error "Filemaker.exe has generated an error and will now close". If anybody else logs onto her computer and runs the application it works fine. No errors. This led us to there being something wrong in her profile so we deleted her profile and tried again. Everything worked fine. Until she logged off and logged back on after lunch. Same thing. She can go to another computer and logon and it works just fi…

    • 7 replies
    • 989 views
  60. Okay, I now have a script that connects the client to the server and opens the application. What I tried doing was putting that DB on the desktop so when clicked on it opens FMP and then should open the db and run the script. Seems logical. But it doesn't work. I looked all thru the manuals for how to do this and the only answer is to use the SDK and bind all the files, which I don't want to do. So how can I make an icon on the desktop that will open and run a script?

    • 25 replies
    • 1.9k views
  61. FileMaker Legacy fp3 and fp5 · Started by Paolo,

    I have two files and a relationship between them. (That's quite common ) I need to display records in a tree view. In other words I want to see main records and, under each main record, its related records, like this: RECORD A _____REL RECORD A.1 _____REL RECORD A.2 RECORD B _____REL RECORD B.1 RECORD C RECORD D _____REL RECORD D.1 _____REL RECORD D.2 _____REL RECORD D.3 _____REL RECORD D.4 it's easy in preview mode. I want to do that in browse mode. Thanks in advance for any help...

    • 6 replies
    • 2.9k views
  62. Is it possible for a summary part to be dependent on two fields? I have a summery field dependent upon one field, but it really needs to be two. I don't want to have to create a new summarry field for the second field because whenever one of the fields changes I need the whole summary to show again. I did not really know where to post this so I added it into Gen discussion. Paul

  63. Out of the blue, a new host has shown up on EVERY client computer. It is under LOCAL HOSTS and is FILEMAKER PRO SERVER TRIAL Anybody ever seen this before? If so, what where how who ....:: Now people are clicking on the totally wrong thing. I thought they were better trained than that. sigh

    • 3 replies
    • 790 views
  64. I'll try to describe my problem as easy as I can (Don't laugh!). I am developing a order/storage database for labelproducts and need help in solving how to organize data and databases. For the record : I use FMPro 5,0 and the database system will be accessed primarly thru a browser (cdml). It is not a e-commerce/shop solution, it is more like a in-house storagesystem. The system looks like this (at the moment): Ordermain.fp5 (F: Ordernumber, CoustomerID (CID), OrderDate, Est.Delivery, Delivered) OrderDB.fp5 (F: Ordernumber, CID, LabelID, QuantityOfLabels) Storage.fp5 (F: StorageID, CID, LabelID, Quantity) Additional databases: LabelDB.fp5 (F: LabelI…

    • 0 replies
    • 779 views
  65. I have an opportunity to get an XServe running OSX Server, which I would use just to run FMPro Unlimited. I would probably disable all other services on the computer. I know this sounds like a waste, but we purchase computers every 3 years, and I'm hoping the next version of Filemaker will run better on OSX Server. I have heard rumors of data corruption, etc. on OSX Server. We don't have too many database files, and don't have too much traffic. We would access FMPro Unlimited on XServe with FMPro from administrators updating the databases, which would then be published to the web using Unlimited instant web publishing, with some custom CDML pages. Will this work…

  66. FileMaker Legacy fp3 and fp5 · Started by jamesooooo,

    Whats the difference between Filemaker pro 5.5 and 6? is it worth upgrading? or just wait for the next version? just wondering if i could be making my life easier now. hehe James

  67. FileMaker Legacy fp3 and fp5 · Started by DLBS,

    I am creating a database using FileMaker Developer 6, and learning as I go. It appears that many of my files have been corrupted, as FileMaker quits on me several times a day. The files open up again and run fine (no recovery required) after quitting, but I cannot give this database to my workgroup until it is stable. I have gone through the recovery/export data/clone/import data process, but I just had another crash. This always occurs while I am running any one of several scripts designed to find a record using a calculated field, sometimes in a related file. I am reconciled to the fact that I probably have to re-create the database (all 45 files! and lots of re…

    • 5 replies
    • 981 views
  68. Hello; A specific question: In the Solution Framework sample app, I've cloned a new report from the product invoice in the lineitems.FP5 file, now want to add it to reports.FP5, but get the message - "Report ID values must be unique and assigned by the developer of the system" when I try to add a record. The help system says this is "typically done by an administrator," but I see nothing helpful about "administrator" roles, there or in FMP docs for that matter. This is all a single-user environment, so I AM the administrator - or trying to be! It's hair-tearing time - help! I'm new to FMP but not to databases at all. Trying to use the Framework sample as a s…

  69. FileMaker Legacy fp3 and fp5 · Started by DonH,

    Is there anyway of restricting what a person can do when they just open FMP? Like making it so they can not create a new file or mess with the preferences?

    • 2 replies
    • 1k views
  70. Hi, It would be of great help if anybody could make me aware of the testing tool and protocol to perform performance test of a FileMaker Pro 6 application. Thanks and Regards, Rajat

    • 0 replies
    • 827 views
  71. Just used the "default password" option for the first time. The problem is I left the box empty. No password needed. Well guess what. The "blank" password option won't let me log in as admin and I don't know how to get around it. Help!

  72. FileMaker Legacy fp3 and fp5 · Started by seker,

    Hi guys, just wanted to say hi to the forums and ask a few questions. I am new to filemaker but I have seen it used in some powerful organising tools. I am a photographer and I am looking to try and create a template for use at work. I was wondering if someone could tell me if what I am dreaming of here is at all possible before I venture too far in. I am looking to first of all create a whole database of my clients which I know I can do. But then I want to have a way to have a list of clients then can click and go into a single client and then from there be able to have a button or something that goes to generate quote or estimate. To which the hopes are tha…

    • 10 replies
    • 1.3k views
  73. Hi all, Not sure what words could be appropriate. Here is the case. I have a script that generates in a loop from 20,000 to 30,000 records. When the loop is over, FM needs obviously some time to index all what has been entered through the loop, which somehow "locks" the user that had been driven to another file. I'd like to make them wait in another layout with a "please wait" message, but how can I control how long they should stay there. Pausing the script won't solve the problem I think (Am I wrong ?). The script ends with SetField(g_time, Status(CurrentTime)). I currently set the time gap to 1 minute, so that if they try to exit (from a button on layout)…

  74. FileMaker Legacy fp3 and fp5 · Started by DonH,

    It appears to me, correct me if I'm wrong, that the biggest problem with FM is the inability to seperate the interface from the data. I would like to update the layouts without having to take the whole application off line. However, FM won't let me do this. Is there anyway to do a "hot swap" of layouts without having to swap out the entire db?

    • 18 replies
    • 2.3k views
  75. How do you set FM up to be in a certain layout when you first open a file? I have two views on one database (1 and 2)... i did a lot of work on view2 and the user should be working on that when they open up the file... but it always startsup in view1. is there a script i can make that will instruct FM to do this automatically?

  76. FileMaker Legacy fp3 and fp5 · Started by Paolo,

    My next solution will have a database that will contain up to 20000 record. Each record have a container field to store a 300-700kb jpeg. The file will be about 10GB. Can Filemaker Server handle it? Thank you!

    • 3 replies
    • 854 views
  77. Hello Everyone, I have a client configuration running Webstar with Web Server Connect one one iMac, FMPro Server on one iMac, and FMPro 5.5 Unlimited on two other iMacs. All iMacs are running OS 9.x. Recently, I was informed that the Webstar server constitutes a security breach for my client because it has an open proxy on port 8000. I reconfigured Webstar (and restarted it) to limit to and from access on the proxy to only the IPs used by the four iMacs. However, the proxy is still coming up as open to the public on the security tests and so we are having to shut down Webstar and go back to using a single iMac as our web server. I can't find any other way …

  78. No one seemed to like my other posts on date calculation so I thought I

  79. FileMaker Legacy fp3 and fp5 · Started by DonH,

    What are the major differences in running an application with FMS or in multi-user in FMP? I'm thinking of running the application in FMP as multi-user vice FMS. Of course one problem is I get an error when I open it up in FMP on the server for some reason. I don't get the error when I open it on another machine in FMP. It is an OLE error. Strange.

    • 3 replies
    • 945 views
  80. RE: Ah Anatoli. I can tell you are too full of yourself. I have programmed under so many different conditions that the platform does not matter to me. I was programming before you were a twinkle in your parents' eyes. That is possible. I am second oldest here; Lee is slightly older. Maybe you are oldest. That's OK with me. It doesn't prove anything. RE: Like DATA and INTERFACE linked. You say they don't have to be. Hmmmmm Not from what you and others have said here. What I mean by linked is that I can not take the interface (LAYOUT) and work on it and then just plop it in again. I have to take the whole database, do the work, and then bring it up again. …

    • 23 replies
    • 2.2k views
  81. I need to be able to automatically look up service intervals allowing us to contact our customers when service is due. I know what I want to do, but I

  82. I want to show the text formatting toolbar, but when I go to the View menu, Toolbars is grayed out, no matter what mode I'm in...am I missing something basic or is something screwed up? (Neither will surprise me! :-) Thanks, Susan

  83. Stumped! 8.5 X11 printout stops printing after 8.5" when i choose landscape. Still does it when i tried legal Portrait . I am printing business cards that are 2" x 3.5" which is 4 rows by 3 columns and need landscape to work. I suspect that there is some setting in FMP that i cant find that will stop this problem. If there was some way to rotate my filemaker bus card project so it ran 8.5 X11 i would be ok. Why am i unable to print a 8.5 X11 sheet in landscape mode?? thanks roy

  84. FileMaker Legacy fp3 and fp5 · Started by pmusaev,

    How do I create a sort of "Log" that will display, row by row, certain fields from each record? Is this a "Portal"? Cheers, to anyone that takes the time to help.

  85. This has bugged me for years. The on-screen display of Filemaker sometimes gets jaggy or fuzzy. Type doesn't display correctly. It's skewed and unreadable at any size. It can happen anytime, but usually occurs when changing magnification. Doesn't matter what font is open. I'm on a mac G4, using OSX (although the same problem existing on previous macs, with earlier systems... Filemaker 6.0v4. The same display bug affects other programs when FMPro is open! Does anyone have a clue about this... it's getting on my nerves as I do more and more with FMPro. Thanks, Joe

  86. FileMaker Legacy fp3 and fp5 · Started by tirtza,

    I'm saving eps images in a filemaker container field as references. Since filemaker actually only saves the thumbnail, the images are not so clear. Is there any way to force filemaker to save the actual image and not the thumbnail?

    • 11 replies
    • 1.4k views
  87. Hi there, just want to know normally the people using what kind of tools/language to create the filemaker plugin? Is that just using filemaker developer to create of other tools? Can somebody let me know the answer. Regards, Henry

  88. I generated a form, lets call it "work order". It works fine in browse mode and I can print it from browse mode, but I can only email the "work order" if I copy it in preview mode and paste it as a picture into my email. This works OK because I usually email one or two at a time. My problem is that when I switch to preview from browse I get a preview of the first "work order" in a list of a couple of thousand. Now if I copy the record number under the little book icon in browse and then paste it under the book icon in preview I get the order I want to email. What I would like to do is automate this process with a script. Maybe not the paste into email part, but viewing t…

  89. What is the best way to format color text in ALL field of selected records? In other words, I don't want my WHOLE database to be color text, just selected records. I can format color text one field at a time, but that is slow and tedious. There must be a better way. [color:"red"]

  90. Hey all. Has anyone else run into a problem with running FMP 5.0 or 5.5 in Classic mode under Mac OS X where moving a field in a layout actually copies it? (Basically, as though you're holding down option, even if you're not). If so, are there any known fixes or workarounds? Cheers, Gary Brusanowski http://www.utopianinc.com/

  91. Hi all, I need FM 5.5 in MSI format to deploy to WIndows clients. I have tried to package FM using a 3rd party packaging tool. Many features do not work while deploying FM this way. Does anyone have any experience doing this before? Is there a version of FM 5.5 in .MSI format out there?? Thanks in advance, Kevin

  92. FileMaker Legacy fp3 and fp5 · Started by RSGC,

    I created a layout and placed a global field in the header. When I was testing I had the layout in "View by Form" mode. As soon as I switch to "View as List" of course it stops working. I can see the logic of this in a List view with regular fields. But with Globals, it would seem that it would handy if they worked in List view as well. I am using 5.5. Is this resolved in 6.0? Or any other helpful ideas? My mission is to have a popup in the header that drives a find. So the user will select a value into the global, and then I will run a script that uses that value to perform a find and a sorts. Works like a charm in Form view. The problem is the form view show a rat…

    • 2 replies
    • 704 views
  93. Is there any way to use a pull down list in the header of a list (using a plugin or otherwise)? I've never been able to figure out why this isn't available, esp. when using global feilds.

  94. I want to beleive!

  95. This has to be the greatest forum. It really is great to be a member of a forum where people like Cobalt Sky - with a seemingly inexhaustible supply of knowledge and enthusiasm - jumps to the rescue of confused FileMakers, beginners and advanced alike. So there had been 'pressure' put on FileMaker Inc. to make FM7 a front end for SQL? If that's true, then pressure has to have come from the mother-ship? Mr J, with his recent embrace of Open-source also has the vision to realize that FileMaker is an old program and that FileMaker Inc. haven't exactly bust a gut getting much-needed improvements out the door. If anyone could instill the terror that leads to quantum jum…

  96. FileMaker Legacy fp3 and fp5 · Started by DonH,

    How does FM 3.0 keep track of the different sessions and users? Cookies?

    • 18 replies
    • 1.7k views
  97. We use FileMaker in our office, and we would like to be able to have our service technicians be able to access the customer database via laptop while on the road for printing out work orders for customers. We have wireless internet for all the laptops. We realized that using the Web feature is not going to work because the database would have to be re-desinged for the web......we do not want to do that. We would like for the techs to be able to access the same info, same screens and everything while on the road. We tried a VPN solution, but that it much too slow. Does anybody have a better solution? We are eager to get this done, as we are trying to computerize our …

  98. I have 4 layouts in a database, each is one page of a form. I have combined them all into a 5th layout to make printing easier. The problem is different users print to different printers each with different margins set up. This causes the text to flow differently based on the available print area.... Given that I have a Body part which is 4 pages long, and I have each page laid out small enough to print to the printer with the least available print area, is there any way to insert page breaks (3 total) into the Body part so that regardless of which printer is being used, I don't get text reflow? Thanks!

  99. Hi, I am a very new FM user who's been elected to create a library circulation program to be used yesterday. Patience is not of virtue at the moment. I have the general layout using some of the asset management from the FM webpage templates. I am learning how to use with scripts/portals/containers. If anyone is able to help me it would be so appreciated. This is what I have going so far. And if it would be of help to send you what I have I can do that too. I'm computer literate, just not programming literate. I have a check out check in page that I put in the Book number in, description, person's name ect. I have a calculation for 15 days check…

Recently Browsing 0

  • No registered users viewing this page.

Who's Online (See full list)

  • There are no registered users currently online

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.