FileMaker Pro v7 – v11

I am using OS X (10.3.5) with FileMaker 7.02. Does FileMaker support vertical scrolling of an open window? It would be very nice to do this.

Hi, I am in the process of converting our FM5.5 data over to FM7. This has not gone well. Maybe someone can help. So far, I have two large issues. All the dbs from 5.5 used helvetica as the standard font. In FM7, it looks correct on the screen, but when we go to print the text, formatting is all over the place. For instance; We use quite a few checkbox fields. They look correct on the screen, but when we print it, the text runs off the side of the page and the boxes are no longer lined up where they are in the layout. Sounds like a font problem, so I change the font to Arial and it now prints OK. So, what's up with that? The dbs worked fine in FM5.5. Why don't they work…

If you have products and services in an invoice, and you want the Sales tax to only calculate tax on the subtotal of the products, what is the best way to differentiate a taxab;e item from a non-taxable item on an invoice line? Thanks

I have two check boxes and only one can be checked at a time. Without a script can I have them automatically toggle? (note fields must be seperate) - see attached (it almost works) toggle_chkBox.zip

In Filemaker 6, you could create a value list with 2 fields and you could keystroke the 2nd field chosen to view but it would insert the data from the first field in the value list. In Filemaker 7 when assigning both fields, it will only keystroke the 1st field and not the 2nd field. Is there a work around for this problem. Thanks, Sam

Hi, I am building a fairly simple accounting system for myself. My accountant however, has made it a little more complicated by suggesting it be a double-entry system. To this end, I have added a Table for the 'Position at Bank' (balance) for the start of my fiscal year. I have several different bank accounts to include balances for, but I thought it best to create a single record per annum, with a separate field per account. What I want to achieve : I would like to have my 'position at bank' (current bank balance) be calculated and show up alongside each entry (credit or debit) in my accounts. So, I have created a Table for debits (which I didn't h…

Hi, I have used customer postcodes and field that required a 'Unique' postcode field value during data entry to avoid creating duplicate customer records on my database. This worked well with FileMaker versions 3 and 4.1 but with FileMaker 7 the onscreen warning of a duplicate does not trigger until I have finished keying-in all the address and customer data. Earlier versions of FileMaker picked up the duplicate as soon as I tabbed out of the postcode field. I'd appreciate advice if anyone knows a simple way to get round this? It still seems to work in the 'old way' in FM Dev 7 in Windows XP... but not on the Mac in OSX!

I've successfully convert my FMP5 (Mac) dbs to FMP7 (Mac) but I still have a pb with some export/import scripts: when a script import data from another *fm database*(and only in this case), it says that text is at WIndows/ANSI format (it is *not*: it comes from a Mac) and it converts some all accented characters. Does anyone know how to modify this default setting ? Thanx in advance.

Hi all, did any one do this before? I have two sales man, each of them just can view they sales price in same field when login into database. I try use the password to get this but I'm not professional yet.....so failed to done this! Any one please help, Thank!

I have a portal which shows documents (.doc or .pdf or .xls) that are associated with a person. I have little upload buttons (for insert file) and download buttons (export field contents of the container field) on each row of the portal. My problem is that the records that have a few files in the portal take far too long to load. It's so slow that you really can't "browse" the records. Is filemaker really LOADING those container fields into memory every time you browse to a record :?? jeeeez... is there any way to avoid that or change the caching on Server to help with this : I thought I could not use file references because the users are connecti…

Does anyone know where I can find the grammar fmresultset.xml? The problem I have is I don't have FileMaker Pro Advanced, and I would like to be able to send data from a HTML form to a database, but apparently it uses this grammar that is included in the Advanced version for genarating the request to the server. If anyone could help me I would appreciate. Thanks, Thiago

Is there anything that might be a negative by hosting a database solution with FM Server Advanced (7) on a Mac (OS X Panther) to Windows users that would cause trouble or be a problem? I have a client that uses all Win machines...but I'd like to be able to program some Applescript features and for that I need a Mac to serve the database. Thanks!

I'm trying to make a relationship from one file to another - as you do! I have other relationships set up from the file I'm trying to make the relationship from. In "Define Relationships" I chose the file I wanted to link to and when the table came up, it couldn't see the fields from that file so I can't make a link. What could be causing it to not see the fields? How do I fix this??

Well, I'm a bit of an FM newb and I managed to lock myself out of my database. I made an administrator account, but I can't find any way to log into it. The database is set to automatically load a limited "guest" account and I can't find anything in the manual or help file that tells me how to switch users. I assume there is SOME way of calling up a logout or new login dialogue, right? I should add that when i go to the only place I can where "user" can be changed, under preferences (in FM7pro), I can change the user to anything I want with no results. The default admin account and the "administrator" account I made don't prompt for passwords at all and stay in guest pr…

Ok. In < 7 data flowed only one way. And the left side could be anything but the right must be indexable. In 7, data flows both ways. But if the left is a global, how can it? Can someone just help me clear my thinking on this concept? Isn't there still a left and right side? Or is that the old entity-based thinking. It's probably alot to ask but my mind sits and spins with the inconsistency of it. I stare at my multiple TOGs in awe and no, I haven't tried flowing through a global or unstored calc because I just don't see how it can. Old thinking sure dies hard. My biggest challenge in 7 is unlearning ... more than learning. LaRetta

I defined a field (depositamt) in a table to sum one of two fields in related records dependant on the contents of a global field (deposittype). The field definition looks like this: depositamt | Calculation | =Case ( deposittype = "Draw"; sum ( accounts::drawamt ); deposittype = "Distribution"; sum ( accounts::distamt ) ) I also have a summary field defined as: deposittotal | Summary | =Total of depositamt When I enter an amount to either accounts::drawamt or accounts::distamt via a portal the summary field does not update unless I place the cursor in the global field and then press the enter key. Oddly enough, the summary field was updating fine wh…

Hello, I used to use File Maker 6 Unlimited to collect data from HTML questionnaires. The FORM in the HTML file was something like this. <FORM ACTION="FMPro" METHOD="POST"> <P><INPUT TYPE="hidden" NAME="-db" VALUE="test.fp5"> <INPUT TYPE="hidden" NAME="-format" VALUE="replyfup.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="surveyerrors.htm"> <INPUT TYPE="hidden" NAME="-lay" VALUE="web"></P> Now using FileMakerPro 7 that does not seem to work. I always get an error that says : "The requested file was not found at this location. /FMPro" Does anyone have any idea how to use HTML to …

Hello all. I am new to FileMaker Pro, and have a question on which direction to go to use it the way I want. I am independantly employed, and when I am hired for a job, I bring up and print a lot of different types of documents. I also have to create my invoices, and keep track of estimates, and received payments. The documents are Excel Documents, Word Documents, Pictures, Quickbooks data, and address/contact information (through Address Book, or Now Contact). Is there a way that I can create a grouping that I could recall all this information automatically? For instance, if I type in the name of the engineer who hired me, I would like to have either a thumbnail come up …

Does anybody know anyway to open a FileMaker file on the host and automatically make it run a script from an email hyperlink or send them to a certain record in a hosted database (not a web page from FMServer Advanced)? We have currently been attaching a FileMaker database, copying a dynamic record number into it and using an opening script which will send people to certain hosted databases and records but would like to find a way to do it without a database attachment, since it makes so many databases in a corporate environment and makes conversion upgrading more time consuming. Is there anything like this available from email, from the command line, etc.? File…

Hi there, I have a database with a table full of projects with a project ID etc. Each project will have been reviewed at a meeting in stage one and reviewed at a second meeting stage 2. Secondly i have a table with the meeting details in - so i will have meetings with dates. What i want to do is introduce a portal on the meetings layout that brings up all the projects discussed at that meeting. I have got this to work for either stage 1 dates or stage 2 dates by creating a relationship between stage 1 date and meeting date. What i need it to do is find all projects that either stage 1 date is = meeting date or stage 2 date is = meeting date. (E.g. i have a meeting on…

I am laying out a report page with subsummaries to organize my data by individual room names in a list format. The problem is that it will display the room name on one page and put the related room info on the next page, or place a portion on one page and runoff on the next. Is there any way to format it so that it only places complete info on a page. I would format it using layouts if the number of rooms and info under the rooms were always the same, but there not. I have attached a pdf example of what we are trying to achieve. Thanks!! Pagelayout.pdf

hi, Find mode clears all fields. Is there a way to keep one field uncleared, i.e. retain the value?

We are a small company and wish to maintain our database on the server (network) and have each computer access this information with either FMP6 or FMP7 according to the windows available on each computer. Is this possible to enter information on the server and access it on any computer whether it houses 6 or 7? Thanks so much.

I have been learning a lot from these forums, and wondered if there was an answer to one of my earliest issues I ran into. I have a solution designed to track a vehicle's information and the information of any tickets written for that vehicle. We can then keep track of how many tickets each vehicle has, and how many of those are unpaid. I currently track this with calculation fields using the Count() function via relationship. I know that calculations using related fields are a bit slow. Is there something I am missing that would work as well? I've experimented with Ray's Calc, but it doesn't seem appropriate to this situation. I figured someone else …

Hi, Well, I have this Evaluation table with atleast 15 fields - Event Code,Department, Job Title, etc. I need to calculate number of records from a particular department, number of records from people with a particular Job title etc. So I made a lot of self joins with different fields. I also need Count of records with a specific JobTitle from a specific department, say records of Professors from chemistry department. So I created a text field JobDept, which is Auto-Enter with Calculation - "JobTitle & Department" and made a self join relationship using this field. I created another field which is a number with auto-Enter with Calculated value - Count(Relati…

I'm simply trying to get a file created in FMPro to display. I'm told that I need the "runtime" or runtime program by the people that gave the file (*.CL5) to us but they can't say what version. I've tried it on a PC that has FM 4 on it but it won't treat it as a native file. I've tried to understand FMPro in the past when we used it for various education databases but it's been quite a while ago. Is the "runtime" program like a simple reader? Something like a free reader program Microsoft gives out so you can view a Power Point presentation? Sorry, but I'm completly clueless on this.

I don't have a 'use compatible graphics' option on the windows version. I am really confused as to why i can't store pdf files as pictures in a container. i could do it before when i stored the pdf files using a button( i know - i was new and didn't know about container) - i also have pictures already stored that display fine and also my boss who uses a mac can insert the pdf files as pictures. I have attached a view of what i see. What is happening - should i be able to store pdf files as thumbnails. And why did this use to work but all of a sudden stop? might it be a problem with when my boss inserts the pics using a mac and then i get the database on a pc? …

Am using 30 day trial French version of FM-7. My question concerns the impossibility of deletion of already written key words in some (not all) key word tables. In the <<Catalogue Photos template>> the option "Formulaire" is followed by option <<Formulaire avec "m

I've been working on a database (about 800 records), simple scripts, about 40 fields, and about 10 layouts. When executing a particular script, (switch to layout X, sort, and go to preview mode), the entire application quit. When trying to open it, it asked for the username and password, each time it wouldn't accept ANY of the passwords. (The passwords did work to open the file, and they also worked on a backup from 3 weeks earlier, so it wasn't a "dumb capslock" problem) The error message was that that particular username/password combo can't be used to access the file. I tried to import the file into a clone, but that gave me the same error. I also tried…

Hi, I'm trying to improve a database that we use to record the status of student course applications. Basically I want it to regularly check for course applications which we have received and have not been acted on for 30 or more days and then send a email to the course tutor. I set up a related table which displays a portal on the main page to record the latest status of an application and all I need to do is search for those records whose last tracking record = under consideration. Now as soon as applications come in we mark them as under consideration, but as we make decisions we'll create other records in the portal accordingly. The find request is fin…

Can I stop people from changing font sizes or colors in fm through privileges for all fields - or on specific fields; or is there some other method? I know some plugins will remove menu items but can I stop them without a plugin?

Hi there, i cannot display pdfs as pictures in filemaker. however i have done before and it is only since transfering it between a mac and pc that this problem has started. I think i may have lost the thumbs.db file or something. Has anyone ever had this problem or knows what it might be. Regards

Am Newbie! After the first two days of 30 day trial period using French version 7 of FM), realize got long way to go before create anything without relying on templates ('mod

This may have been posted and/or talked about a few different times around here. What I'm basically trying to create is a hierarchical portal. Or in other works, to show child relationships underneath the parents in one portal. I've downloaded the example from FileMaker's website (I beleive it was created by Cleveland Consulting), but I can't make heads or tails of the workings of it, plus it uses plug-ins. I do like the way it works/looks, though. Are there any examples of how to create one from scratch (in FM7)? This would be the best way for me. I would also prefer not to use any Plug-Ins, as this will eventually be going into a commercial application,…

Hello, I am developing a system that tracks payments and balances due or owed on a monthly basis. I'm using relationships/calculations that look back to previous months to bring balances due or owed into the most recent month. The problem is, the db slows down during data entry on these pages. If the user does data entry that will change the balance, the db takes some time to refigure the balance. I want the user to be able to fly through data entry and to not have to pause while the db recalculates. I can't figure out if this is a common problem and I need to figure out a work around using scripts to set the balances in number fields to speed things up - OR if I a…

Couldn't think of a better title b/c I don't really know the jargon yet. I have to explain with example. In my Movie Database, I want to be able to click on a record within a portal and have that record come up in a separate layout. Is this possible? Is it hard to do? For example, in my layout there is a portal that serves as the Crew List. So for the record, Pulp Fiction, I want to be able to click on John Travolta within the portal and then go to layout [Person] to John Travolta's record. Thank you.

I am trying to duplicate the results of a summarized report (Break Headers), that would be interactive. It's a form that gives you different items to place a quantity next to depending on earlier selections. I need Headers for each Category to make it easier to fill out the form. Basically when I hit the preview button I have exactly what I want, but it is not interactive. Any ideas would be greatly appreciated.

Have we got a get table calculation in FM7? I know that I can get the file size but what I want is to be able to get is a size for a table in my application.

very new to filemaker, I have inherited an old FM5 database and have created a new database on FM7 I wanted to match the existing data in the old db to the new one but i can work out how to change the target field. At present i can only match fields in the first table of the new database not any other tables...how do i do this?

Hi there, I have a problem with displaying pdf files as picture files. I am using containers to insert pdf files as pictures. My colleague using a mac just rights clicks on the container then selects insert picture and selects the pdf file. A picture of the files first page is then displayed. When he passes the database over to me the file he has inputted does not show and there is a message saying 'file cannot be displayed'. The strange this is we have been doing this for a few months and the previous file pictures show fine - it is only recently this has happened. The only change i have made is to place the pdf files in the web folder so i can use them via instant …

Hi all, this customer of ours once bought an Adobe font and uses it across his company. Also used it in FMP6. Now he has upgraded to FMP7, but the font is not in the list of fonts he can use. I guess it's not TrueType or whatever FMP7 prefers to use. Is there a way to make a font, acceptable for FMP7, out of one of these older fonts? If so, is that legal? TIA Ano

Hi, In my solution I have two fields labeled "Alc percent" and "Alc Proof". Originally, I had the "Alc Percent" field as a simple calc "Alc Proof / 2". However, I would like to allow the user to enter data into either Field. If "alc Proof" is entered then the "alc percent" field calculates "Alc Proof / 2". If "alc percent" is entered then "Alc Proof" calculates "alc percent * 2". Can I do this with just calcs and not use scripts and globals? I have tried auto enter calc replacing existing data but it only works when I change the "alc proof" value. If I change the "alc percent" value, it reverts back to the "alc proof / 2".

After converting to FM 7, many of my layouts which have sliding text boxes with merge fields end up neither printing nor displaying the sliding text boxes in preview mode. Browse mode looks fine. If sliding is turned off, the text boxes appear, but obviously don't slide. Sometimes the first text box or 2 will appear at the top of a page, and the rest dissappear until the next page, where the first one appears (as though the rest had been there invisibly) - and the rest are gone. The text boxes are set to print in the sliding - printing dialog box. Does anybody know what's going on?

I am setting up an invoice system that will have different services attached but some of those services need to be related. I find that if all services are related to the invoiceID, I will not get a proper 'A' description when service B is a child of service A. If B is must be related to A should it only be related to A and not the invoice. Or would you keep it related to the invoice as well as a second relationship to A?

Can you change the highlight colour in FP7 and is it possible to highlight the whole field. At the moment the system highlight combines with the background colour.

Is there a way to reverse the FieldBounds fuction where instead of the computer telling me where a field is, I can type in the numbers and the field will change to the postion and size of the numbers I just put in?

I am trying to figure out how to make a database with 3 tables, clients-invoices-products. Pretty easy I would think. But in the process of trying to make it work, sometimes Filemaker starts spinning the color wheel of death, and goodbye database. has anyone else had this annoying problem? I would think that FM would at least give an error code.

well, at first when i came to FMP7, i just wondered why it would drop support for Chinese version when it was in FM 5 or something. this is odd for me. FileMaker doesn't want to take a stand in today's China's database market? or was it Oracle and MS SQL stepped into China way too early and FM is not going to step in? well anyway. i wanted to localize FMP7 to simplified Chinese version since most of my clients are Chinese. so far i have been implementing layouts all in Chinese, but when they use FMP7, they are just not used to see English menus. although they can do everything they can with my layout design as from the menu, they still prefer to be able to read …

Does anyone understand the following comment from FMI's "fm7_converting" document: "The Store compatible graphics preference is no longer available. FileMaker

I have a very simple database that contains 5 fields. We use it as an archive of all stories that have run in our weekly paper. headline byline date page story I would like to set up this database to be served on our intranet only. our employees would be able to search the database for a word or string of words and the search result would highlight where the word appears in the field. very similar to "cheesy word highlighting" by James Mastrianni. i have tried to share that file but it will not work over the intranet. seems to be an issue with overlapping fields. are there any other solutions similar to this? is this something that would work usi…

hi all~ is it possible to restrict access to certain records on a table by access privileges...? if so, how? or does it have to be another way of doing so?

Okay, I'm not a very experienced FM user but I can't work my way round making a database and use script functions and all that. I have a little trouble with relationships though, and while I was changing relationships trying to figure out how to link two files to show the relevant information, I decided to delete all relationships and start again (coz I got myself confused). Though when I closed the "define database" window all the fields in my database file were saying <table missing>. When I click on a field in layout mode to relocate the field, there is no option for choosing from the current file. Its like it can't find/see the file that its on. It look like to …

I feel as though I'm asking to be spoon-fed, but here goes: I have one week experience with FMP. Look up the word beginner in the dictionary and you'll see a picture of me in a few select dictionaries. I am trying to make a movie database similar to the way IMDB works. So far, I have three tables: , [Person], and [MoviePerson]. The tables and [Person] have unique serial id numbers to distinguish people from people and movies from movies. [MoviePerson] is the middle table that creates a relationship between a person and a movie. I did this so that one person could have multiple roles in one movie. I.E. M. Night Shyamalan produced, wrote, and directed …

I am displaying a portal window, which when a line item (UPC) is entered, it (the UPC field in my Items DB) does a lookup of an inventory item (in my Inventory DB). When using the [Full Access] log-in, the portal window refreshes after each line item is entered accurately displaying the new line item. When using any other account access (i.e. Data Entry only), the portal window fails to refresh automatically after each line item is entered. Does anyone know a work around or why the portal window behaves differently with access priv's? Thanks for any help!

I am trying to create a report in Tasks 2.0 based on two search criteria not being included in the results. Under saved finds, I enter the first criterion I want omitted. However, when I try to enter the second criterion in a new saved find, it reverts both saved finds to the same criterion. For example, I first put in that I want all completed projects to be omitted in the search report. Then, I say I want to omit all cancelled projects. When I run the report, only the cancelled projects are omitted. When I go back and check my saved finds, they both show up with cancelled being the criterion as opposed to completed and cancelled. Can someone tell me what I am doi…

I need to import a file which is always located in the same directory. The file always starts with "SEL". One week the import file is SEL01X.xls, the next week it may be SEL28W.xls. I would like for FileMaker to automatically find this file in the designated directory and import it. After the import then for FileMaker to automatically rename the file from SELxxx.xls to XSELxxx.xls, so that it would not import automatically again, because it placed a "X" in front of the file name. Can this be done and how? Thanks.

Hi, I really hope someone can help. Firstly, here's what I'm trying to achieve: I have two tables: 'members' and 'letters'. I want to be able to send any given letter to all of my members. So all the letters are common to all members. However, I'm really finding this difficult to implement in FMPro7. Any suggestions would be really great. Cheers, Dan

I know there must be a way to do this, but I haven't done much with text field manipulation. What I'm doing is replacing a SQL database with a FileMaker database that tracks memberships in a non-profit organization. Membership submissions come in as an email in the following format: John Doe 12345 Anystreet Anycity, US 12345 999-999-9999 [email protected] There is also the possibility of a middle initial, additional address line, and the phone number is user formated. What they've been doing in the existing database is to copy each part of the submitted info and paste it into the repective fields (first name, last name, address, city, etc) Wh…

Hello there, nice board! Hope you can help, I've lost a 1200+ record database... I don't know where to post that, sorry if it's in the wrong section! After an unsollicited reboot, one of my FMP7 databases (that was open when the PC crashed) has been corrupted, FM tells me to recover it. But when I try, the whole thing just crashes too, I just end up with the stupid Windows error report. Is there any way to save my data??? Config: WinXP SP2, FMP7, AthlonXP 2000+, 768Mb RAM, corrupt file definitely too big to be posted here (160 Mb!!!) (could there be a compatibility issue with SP2?)

I've just converted a database from FP6 to FP7 in it, there is a field that prints a number with two decimal places onto a form.. I need to leave out the decimal symbol so that it will print correctly on the form. In FP6, this worked fine, I just went into Format/Number and deleted the decimal symbol.. when I converted the database to FP7, the "." started showing up.. I went in to Format/Number and to my surprise, the settings were set correctly.. there was not supposed to be a decimal symbol printing.. but there it is on the report. Any ideas on how to get rid of it, without turning it into a text field. Thanks

I install my FMP solution on a new computer Win XP platform. When I try to print something in this dbase, i obtain this message: ---------------------------------------------------- PRINT JOB FAILED The print job failed to complete. Reason: The request contained an invalid parameter. ---------------------------------------------------- I try on another computer an its works well. Did anyone already see this problem? Need help to resolve this. Thanks GuyC

I want to e-mail a letter to a found set in my database. The letter will have record specific data in it. Is there a sample script? Should the letter be its own layout? I'm really clueless as to how to get started. I did a search in the forums, but couldn't find a solution. Thanks for any help or pointers to some other web resource!

Is there a way to make the fields on LayoutX default to be read only (not editable), then with the flip of a global switch and some clever scripting LayoutX becomes editable. I understand I can do this with two layouts, however this would make the solution more cumbersome to manage. Any help would be much appreciated. Thanks

hi all, i seem to have a problem creating a relationship between a calculation field with another calculation field, or a number to a calculation field. the calculation fields returns numbers. is this something i am supposed to know that calculation fields cannot be used in relationships? i tried to match a calc field and a calc field and it shows nothing, neither does a calc and a number. it only shows records if the relationship is a "X"...

Hi, I'm new to this forum and have a (probably) simple question! I know FM7 has the ability to change text colour depending on an answer using a calculation. I would like simply to change the results of 'PO Received' if "no" to red and "yes" to green in the field. Every time I try I get messages telling me I have too many or too few '(' ')' I know I'm doing something wrong. Can anyone help me please? Thanks Lorraine ps - I have searched the forum but couldn't find any topics relevant.

I have a script that adds the user name, date etc. into a text field called "CS Notes" the user then carrys on typing what they have to say about the customer. I would like to set the script to use a certain colour for the text entered by the script and then by the user. Is this possible??? I have read about a calculation changing the font style but not through a script like this. Thanks guys... my 1st post oh and thanks to any girls out there too. ... in advance Mike

Question. I have lots of scripts that I would like to include on some sort of drop down box. For instance, the conference management database that I have has about 10 scripts that print different items. Is there an "If" script that I can create that has a field "conference scripts" and have the 10 scripts as value labels, then if I select one of the value labels it runs that script? Seems like that should work, but when I created the script steps it doesn't work, seems like I may have missed a step. PLEASE HELP any suggestions would be appreciated. Patti

I am trying to develop a medical database that gives choices for a physical examination. ie I have check boxes ie DEVELOPMENT (Normal Delayed) I want the print out to say a. DEVELOPMENT (Normal) or b. DEVELOPMENT (Delayed) or if no box is checked I want the print out to say nothing as below c. however if left unchecked, the print out will look like: d. DEVELOPMENT () Selection d. doesn't look nice so I'd rather have nothing. Is there any easy way to do this? I've tried using a script to input data into a DEV2 field as below If (Devlopment = "") Set Field (Dev2; Dev2 = "") Else Set Field (Dev2; Dev2 = …

I am wondering if anybody knows how I could perform a find where the find is performed over mutiple fields as opposed to just one field. So, for instance, how do I search for Bob and the request returns all the records where Bob appears in either the first name or the last name field. Thanks, Nick

Hi, I am hoping somebody could help me out here. I have an Evaluation table. The table consists of fields - Job Title, Department, Years of Experience etc. In my layout, I want to be able to choose a particular Job Title, say "Professor" and find the percentage of Professor records. And similarly for Department. If I choose "English" Department, I want to get the percentage of English department records. This is my first step. My next step is to choose "Professor" and "English" department and find percentage records with Professors from English department. I hope somebody can help me out here. Thanks in advance.

I'm maintaining a dual platform solution which I recently upgraged to fm7. There is a place where mailing labels can be printed in my application and in the preview mode, the lables appear 8 or so to a page as it's supposed to but when i print the job, only one label spot is filled with an address. I've tried recreating the layout, and Printing to several differnt printers (since this is to be a bound solution for both mac and pc) with different results for different printers. I believe i'm to the point where the labels print as expected on a laser printer, but not on an inkjet. When I print to a PDF file all the addresses tile as expected also. Any thoughts?

I have a list of town and some of the need to be linked together. So if I I am viewing town A and town B and C need to be linked to it, I will need to see that A and C belong to B when I am in that record and when I am in C I will need the portal to show me that A and B are related. So if a town is related to two other towns there would be six relationships in a 'join' file. A town related to three town would have nine relationships. How can this been done? Note I have considered that the records share a common 'join' id but that would be plan B

Hi all. I am in a bit of a situation. Prolly really easy to fix, but yeah. I have figured out how to creat merge fields etc, and how to apply them within a letter made in fmpro. My problem is how can I do a mail merge for say 40 clients all with the same letter. I was hoping something that would physically show on a layout page, the 40 letters (as you scroll down) and each indivdual clients details merged. I guess problem is 1. Actually merging more than one record. 2. Being able to select the records that you wanted for the mail merge. Any help would be greatly appreciated. Regards, Daniel

New to FMP7, I have searched the Forums for an answer but I must not be using the correct terms. I am building a db that will track mentors for a community program. Some of the mentors have provided me with their Profile in MS Word. I plan on storing a Link to the doc file in a container field. How do I display one icon if a profile document exists for the mentor and a different icon if the document doesn't exist? Additional if the file doesn't exist how do I script an object insert so that all the user will have to do is navigate to the file location?

here is a little demostration that shows how a record is before ur very eyes, and cannot be found!~ ok here is what u do in the program 1. enter a record in [style Details], this is the thing that u want to order. 2. press the "Order" button, which will generate an order form for you. and now u see in [style Details] that shows the order number it is being ordered. 3. now sometime later things happen, and u have to cancel the order. so u go to [Order Form], and press "Delete", the computer deletes the entire order, and then it tries to set those styles that holds the particular order number to nothing, so u wont have any styles that has an order number th…

Would it be possible with FM pro 7 to automatically check the field contents with a filename? For instance I have a text field with "babe.mp3" filled in and a container field with the mp3 matching file called "mister.mp3" (stored only as a reference to save disk space). I want to (automatically) check if the mp3 file in the container field is still in my folder "mp3s". For this I used the solution provided through the thread: http://www.fmforums.com/threads/showflat...=true#Post98226 Would be something for the weekend to figure out! Greetings Thomas

I've been intensively using FMPro6 as a text processor for letters and press releases, and as a web archive. Many new features are interesting, but: 1. I am astonished to see that v. 7 (Trial) turns any text pasted from the clipboard (or dragged and dropped) to plain text! (v. 6 would deal with rich text). And once you've restored your text formatting, there is no way to move it out, since the Export Field Contents command, as well as the copy-paste or drag-and-drop methods, only generates plain text. 2. On the other hand, justified paragraphs are clipped, with unequal line length! Some last words in a line are shortened by 2-3 characters... 3. Italic fonts…

I know I can get a count of the active users, but can I get a list of the active 'account' name and a list of acctive 'user' names

Folks, Having upgraded to fm7 from 5.5 now find can't open databases one at a time, ie all relational db's ask to be opened if they are involved - this is different to earlier versions. Is this the case or is there a way round this? (Should mention this is sharing on a network with 5 users..) Look forward to hearing any ideas... Cheers

This is a first. Maybe I'm beyond tired and just don't see it. I exported some records (FM7, WinXP) as .fp7. I can open that file directly and the fields display fine and all records are displayed. But when I try to import that set into another file, I get the FM error sited in the subject. I am on the correct table (layout Activities). I get the error even before I can attempt field mapping - as soon as I select the file. But the fields are in that file - along with the records! Do I need a very long vacation or is something going on? I posted on a few forums, sorry. I know the weekends are a bit slow and I need to resolve this before I attempt any more im…

hi all... when i use the "Adjust Window" script step, it adjusts all opened windows within Filemaker. is it a way to make it adjust only the active window? thanks...

Hi, i am having trouble solving a date calculation. i have fields like this: [Date due assigned by Customer] (data type Date) [Date due for ordering materials] (data type Date/Calculation/Number???) Then [Date due for ordering materials] is by calculation, [Date due assigned by Customer] - 60 (in other words, 60 days before customer assigned due date). i don't know which function will return a Date type for this kind of calculation or just to satisfy my demand. i tried using simple calculation, and it returns a large number, representing the Date in actual number of days!~ Fo example, [Date due assigned by Customer] = 2004-09-10 then, [Date…

is their a way to make a 2 columns portal to allow my price list to fit in a single page. I can't see how to do this... I haven't seen this question in previous post. Thanks

I've just discovered that while FileMaker Pro 7 includes JDBC support, it is implemented in such a way as to make it impossible for FileMaker databases to be used as data sources. This functionality is required to use WebObjects and Filemaker 6 via the WooF plugin. Does anyone have any idea why this has been dropped in FileMaker 7? Is anyone aware of FileMaker's plans? To perhaps include this facility in FileMaker 7, via an update, for instance? It seems strange that this was dropped. The question for me is: was it dropped due to development time or product strategy? That is, was it taking the developers too long to incorporate this functionality in time for re…

Does anyone have "inside" information as to when FM will release bug fix v3? I am holding off upgrading our offices until v3 is relased. I can not spend time reprogramming around the Value List bugs. I am making a huge assumption that that bug will be fixed in v3.

I'm creating a script that will send an email to people that have an appointment. In the email body I'm using a calculated result that pulls over the person's appointment time. Could someone please share with me how I can format the time as text with the appropriate AM or PM tag ?? I've searched for this but can't seem to find anything.

I am new to FM Pro, can it automatically send emails from data it receives. Thanks

I know I should be able to do this easily, but I'm just back from holiday and my brain is still fried. The problem: I want to populate 11 fields in one table called "games" with names of players selected from a pop-up that refers to a second table "teams" which contains a portal to a third table "players". That part is easy. However, if a name has already been selected for one position, I do not want the name to appear in the pop-up for other positions. I just can't get it to work. Anyone got any ideas???

I just installed the developer version of FMP Advanced. Now when I try to open a file located on our FMP 7 Server I get the message "THe maximum number of licensed users are currently using this copy of FileMaker Pro. Please refer to the license key section of your software documentation for further instructions. I don't have the server version running on this computer. Our server is running on win 2000. If I turn on my server advanced copy on this computer I can run the files. If I run local files it runs fine. I really wish FM had some kind of support. The knowledge base has almost no information. I hate calling and paying for help to work around Filemaker bug…

Does anyone know if there is info you can download somewhere that you could use to make some kind of lookup table for finding the extended 4 digit zipcode for a given address that could interact with FileMaker? What I need to do it to type in an address and zip code and have FileMaker return the zip+4 For example, "123 anysteet, OH 12345" would return "123 anysteet, OH 12345-6789"

I know 6.0 has a pretty poor method for data syncing, my only question here is does FMP7 handle things differently, or are we still unable to sync a local database to the server in FMP7? I appreciate any help anyone can give, as every source of info I've perused seems to tell me that this method hasn't changed from FMP6 to FMP7.

I posted this in the import forum, but it's a bit low traffic. I'm converting an older version of a database into a newer one that we've developed for a non profit doing fundraising. The old DB has "home phone", "address phone", and "other phone". The new DB has a 5-field array of phone numbers, and a corresponding popup menu with phone types, including fax, work fax, etc. Is there any way to map the separate fields from the old DB to be imported into the array? Otherwise, I can only import the home phone, essentially. Can someone let me know if this is feasible with FMP, or if I'm going to have to do this manually (yikes)? Thanks

Hi, I have 5 radiobuttons with different values. Is it possible when i click one of the buttons that a script is automatically performed? thanks

I'm working on a program for our office to make balancing the Visa a bit easier. Its fairly simple, and doesn't need many protections from user error, although I guess in the future a reliable annual report would be nice. This is what I have so far, but the one thing I am having trouble with is providing subtotals (For GST, Post, and Total) for each "category", being the account names. The post amount is the amount we need to pay, the GST is the tax (that we don't have to pay; it's the 8% PST tax that we do have to pay). Any ideas how I can get this to work, easily? I don't want to have to flip between three different windows just to put in an account name (li…

Is it possible to export records without returns in the text string? What I want to do is to generate an email "To" field separated by semicolons for inserting into an Outlook (or Eudora) To field. If I can get it into a text file, one copy and paste will address the email. (I don't want to send many emails, only one with a single list of addresses in the To or BCC field.) Or is there a better way to do this (on Windows; AppleScript isn't an option in this case)? There is only one field to be exported, but all the options I've tried result in a return between each record. Thanks for any tips, RD

Hi everyone, I am new to this forum. Can someone tell me why sometimes when I have a pop up value list, you can click on it and it automatically tabs into the next field and sometimes it stays in the value list field? This drives me crazy Thanks

I've been working on my first big FM7 project and have noticed a naging problem. Popup Lists (not Popup Menus) are very slow to display once clicked. In addition, after the list pops up and a selection is clicked, there is another pause until the value is actually entered into the field. It takes about 2-3 seconds for the menu to appear and then another 2-3 seconds for the selected value to be accepted. This is painfull. As a test, I created a new database and saved it locally on my hard drive (to rule out any network issues). I created one table with one field. I also created one value list with 10 "custom values". I formatted the single field to be a popup list usi…

Hello. I've done a search and cannot find an answer to my question. Hopefully someone here can help me. I have created a database in FM7Pro and have turned on Instant Web Publishing with guest access to enter data. I enter the http address on my computer's web browser and I can see the file. However, when I enter the http address from any other computer's web browser (Mac or PC) it says that it is an invalid web address. Any ideas?

This is a complete newbie question, but I cannot find an answer for it anywhere in the help information, the user guide, or online. I have created a new database from scratch, and I cannot figure out how to resize the layout so it only contains the information entered, and not a large white space to the right of the layout that goes on seemingly forever! How does one do something as simple as this? Thanks for your help!

I am not an avid FM user, although I have created a nice DB that I would like to share with other professionals in my trade. Most likely none of these end users will have any type of FIleMaker app so is there some sort or free version or third party app ala stuff-it or win-zip that will allow others to take advantage of my DB?