i created a database then i switched to table view and have set so that only name fields appear in table view , i want to know how to go to the related record in form view when i click on a name in table view ...

Every time I open this one database, it asks me if I want to use the system settings or the file settings. It doesn't seem to matter which I choose, the database works properly. But how do I get it to stop asking me to choose when the file is opening? ...

Here's something a bit crazy... But - given a field "FirstName", shouldn't the following calculation return "FirstName" only? Instead it returns "T1A • MAIN CIND::FirstName" (TableName::FieldName) Substitute ( GetLayoutObjectAttribute ("FilterSearch1 • " & ......

Is there a way to print one record per page, or do you have to print each record individually? Thank you, Fed ...

Can anyone explain this? The found count exceeds the number of records. ...

Trying to get the Email plugin to work with a city government-supplied IMAP account, which I believe is run off an Exchange server. I can connect to the server with SSL off, using Outlook on the PC, and Apple Mail or Entourage 2008 on the Mac. When I try to connect with the ......

I just discovered that I can customize my toolbar in FM11. It's been a great discovery! As I was playing around in the customize window, I noticed that the toolbar screen has four buttons - New, Rename, Delete, Reset. Does this mean I can create new toolbars? The butt ......

Hi guys, I'm a bit of a FileMaker noobie but I've kinda been given responsibility of a FileMaker Server Advanced 11 and recently, for no reason that I can see, databases started crawling. Especially when duplicating records. When I first open a database, I can duplicat ......

I recently upgraded from 8.5 to version 11. I like most of the improvements, but I have found that the drop-down list functions differently then before. Before, the drop-down "window" would resize to fit the displayed field. Now, the "window" only displays a portion ......

I have a database to track job numbers. In a layout I have each specific job with a portal that shows the notes I have made for that job (notes are from job_notes table). I have a button "add_note" that has a script that opens up a new window in add mode to add a new note. ......

The background we use on our local database was created by taking screen-capped slices of another application, and then piecing together in the proper dimensions to fit our needs. It's something I have to stare at 5 hours a day, so I thought it might be nice to give it the ......

We just recently imported all data from our old system into filemaker and have found an issue. Our old system stored the zip code as a number but displayed it as text. So the zip code would show up as 00802, but was stored as 802. Now that everything is in filemaker, ......

Can anyone confirm that it is possible to get the Run Shell Script module to work on Windows, and if so, what is the magic? I am using the latest version of ScriptMaster, 4.0.2, and Filemaker Pro 11 Advanced on WinXP, and trying to run very simple commands like PATH or DIR ......

Hi folx I have a file invoices with n invoice line, each being max 3 lines long. How can I figure out how many pages I will need, and how can I manage this? As far as I understand, printing will be from a layout of the invoice lines. But what else? Thank you for ......

We are running a legacy system using FM5. I am looking to add-on Manufacturing Solutions components including shop Scheduling, Routings, Bill of Materials, Quality, etc. Any suggestions are greatly appreciated! ...

Hi. Im sure there is a simple solution for this, but I am unable to find the correct "section" in my reference material or terminology to get started with. I have several tables - all related. The main table is one that contains a client ID and the related tables cont ......

Need to create a custom menu script. So I don't accidentially create a new invoice. For example if I want to create a new invoice i would like a box to come up and say something like: "create new invoice" [Yes] [No] if I click yes then creates a new record, if ......

hi there,New to FileMaker Pro, just converted from Micro$oft Access. My problem is with field validation, I basically need a field to stop a user entering an incorrect postcode uk format e.g. LN94 4FM. I guess i must have to use a calculation or script but i need some help p ......

Hi forum, we would like to protect a runtime we are developing by requesting activation through a webserver we own. Our problem is to determine some unique value for each computer. On windows we can use the volume-id of te harddisk that we get from the troi file plugin, ......

Is there a way to print column headers on multiple pages when the column header is in a Sub-summary part? I have done this before by using a Title Header part and a Title part. However, in this case, I am using the Sub-summary part to pull in the organization's contact in ......

Hello I need to insert an image of my logo in my application, It´s already in filemaker pro 10 advanced but when I test the IWP from my browser this image is totally damaged and without clarity, I use .png for all my logos and icons, use already photoshop for save as we ......

FM10/11 Adv OS X 10.6.4 I need to be able to archive individual records and (on occasion) groups of records from more than 30 tables in a file that has been in use now for 5+ years. I have read the threads on this forum and others on the subject of “archiving records ......

Hi, I have one more problem I would like to ask you concerning setting a field to one from another table. I have a many to many reltionship between Patients and Doctors tables using a linking table (Doctor_Patient Relation), as a patient can have several doctors and a doc ......

I have a need to increment a field when I select the button. This field will not always be selected but when it is, I want to find last value and increment by 1, move new value into last value field and move new value into selected field. How do I do this? ...

Does any one have sample code to consume web service using 360 works web service manager in PHP,say for 'AddTwoNumbers' operation? here is code which we wrote require_once('lib/nusoap.php'); $wsdl ="http://servername/websvcmgr.php?wsdl&service=ExampleService"; ......

The video and the example that comes with the plugin demonstrated merging (find & replace) data from one single contact into the Word document. What if I have hundreds of contact and would like to merge all of them into one single Word document (like the normal mail ......

I installed snow leopard and my filemaker 6 web companion will no longer work. Does anyone have a work around? ...

I get the following message when I try to set up IWP on a starter solution I was testing: "Filemaker cannot share files over the web because IWP could not be started." I walked through the step by step directions in FMTS book, Chapter 12, but got that message. I noticed ......

Alerts/warnings that come up in FMPro don't seem to come up in IWP. For instance, if I try to delete a portal row using FM, a popup comes up asking me if I would like to delete the portal record. That doesn't seem to work in IWP, so I cannot delete the portal record. I end ......

I'd like to hide certain layouts when a user is using IWP. Is there a hook I can use that will tell me whether a user is logged in via IWP? ...

Hi, I'm running filemaker server advanced 11 on a windows server 2008 SP2 machine with IIS 7. We can easily access IWP internally at 192.168.1.49/fmi/iwp but we are trying to figure out how to make this available over the internet. We did it with FM Pro but in that ca ......

I want to export a csv file for use in another program - Prestashop. The best format is a csv file with semicolon ( ; ) field separators and no quotes around the fields. After perusing previous discussions I think the best solution would be an XML export. I have do ......

I have been programming for over 40 years. I went from FORTRAN to functional programming to object-oriented programming to database systems to client/server web pages. A couple of years ago a company I was with bought a manufacturing control package. The developers claim ......

I am working with external oracle database. I don't know how to stop a long Filemaker calculation process. Whenever ---"Summarizing field "xxxx", Records remain to process "xxxx", STOP button --- dialog box shows up starting a very long summarizing process and if I ......

What is the 'x' option for associating the 2 fields in a relationship? Can't find it documented and it wasn't obvious what it did when I used it in a test relationship. Thanks in advance. ...

HI currently I am working on FM6 project I need to respecify some of the field mappings in the FM6. But I dont know how to get the field mapping dialog in FM6, where I can just specify the new field mapping and it should get saved. I tired to run the import script in de ......

Hello, I'm trying to create a "splash" screen that will come up and stay up for the duration of my startup script. My Script goes through and verifies fonts, Scripts, Layouts, Etc. I don't want my users to see the whole sequence. So I'd like to just show a splash screen ......

Hello FM Forums guys and girls! I recently downloaded the trial of FMP and have quickly found how overwhelmingly powerful it is and so I'm having some trouble completing a seemingly simple task. I am trying to get the sum of numbers in a certain field only for records t ......