When I export data with apostrophe's from FMP into an SAP enviroment it chokes. Looking at the data in notepad ++ I can see that the apostrophe character in FMP exports as Hex A1 (end of line...
Hi, I need some help on an import into Filemaker 9 issue. When I import a text file into a text field (Windows), I get invalid ASCII symbols at the beginning of each text line. It's the littl...
I have a few calculation fields that are sum(amount) through some dynamic self-relationships. I am trying to get zero to display if there are no records through the relationship. I tried:
I...
I have a FileMaker 8.5 database with 16 tables and a crazy relationship diagram. Some tables have multiple table occurrences on the diagram, and I am almost certain that over the development p...
I have a filemaker pro database with 330,000 records. What I would like to be able to do, is have a script that finds the records for each state and automatically writes them to a csv file wi...
Good Morning Everyone,
I am running into a odd issue with a portal in one of my clients databases. It appears to have some form of network or memory issue, but maybe you all can help. (Filema...
I am trying to setup our FM Server 9 to do a daily backup of all of our databases to a NAS. I have mapped a drive as the Z drive to the backup folder on the NAS. When I put in the Backup Fol...
We did a server migration this weekend and unfortunately, the Filemaker CD that we have does not contain the actual software for Filemaker 5.5 server.
I have two questions:
1) Is there a...
I am looking to use the "save as excel" script step in FM 8.5 to save a file to a specific folder with a dynamic filename relative on a variable.
IE, if $end = 9/31/2008 - filename = report...
My system: Self built, Intel Core2 Quad Q6600 2.4GHz, 3.5Gb RAM, Nvidia GeForce 8800 GT, Windows XP sp2.
When I go into 'layout' mode and view the relationship graph, the graph takes around 2...
I have a layout that is displaying multiple records based on sub-summaries. Here is how the layout is "laid out"
Header
First Sub Summary - "COMPANY" - groups "people line items" together ...
Hi,
The old filemaker had no username just a password.
Now we are migrating the old files to 9. I dont have time to redo the files for 9.
How do I make the login routine to not to place the...
I need the ability to create an "aged" report.
I have an accounting table with line items (positive for invoiced, negative for paid) and I need to generate a report that shows anybody with ...
I need a script to that will check to see if the user has entered a value (including zero) in a field before the rest of the script will run. the problem is as this is a numerical field if the...
I am building an accounting system that requires records to be "locked out" so that no data modification can be made after a monthly summary report is exported to peachtree.
The caveat is t...
I have a filemaker file,and all of a sudden when I open it, the records are blank. It says there are fifty records, but as mentioned, they are blank. I opened it earlier today. and it worked f...
Hi,
I have two related tables that both can be searched. In the results table I'd like to show the found records of both tables in one single list.
As far as I know, I need to have a thi...
Hello.
I am trying to teach myself FileMaker programming, and have a question regarding inserting a link to an external document into a record. I appreciate any advice and thank you all in...
I have a portal in a purchase order form showing data from lines when I use a calculation field the field shows 0 values on the next portal row even though there is no data on the next row if ...
Hi,
I have a Filemaker database that manages all kind of media resources: books, newspapers, CDs and so on. Soon, a large commented list of Internet links will be part of this database. So ...
Somewhat of newbie to FMP. probably a simple question but can't find the answer anywhere.
Using FM 8.5 - I am creating a simple customer contact layout and have created an "Add Job" button w...
Hello,
I am looking for an easy OR search in Filemaker.
From a lot of databases I know that you simply write "Ontario OR Québec" into a field, and as result you get all the records that ...
I am trying to create fields or buttons that will link to QuickTime files located on a separate server on our network. I want the file to be referenced and played within QuickTime outside of ...
We are working with a new server with Small Business Server. All programs are running fine on the old server, so we just reinstalled and copied all programs, including filemaker and the databa...
I am building an application which uses a fair number of drop-down lists. My problem is that when a selection is made in one drop-down, it automatically jumps to the next higher tab, which, if...
