FileMaker Pro v7 – v11

I've asked this question before, but I thought I would ask it again in the hopes that a current forum participant can help me. Is there a way to toggle the script debugger without having to access the scriptmaker dialog box? What I would like is to be able to be able to turn the debugger on or off from the keyboard. Thanks for any help. Jarvis

Don't be surprised if you see bloodstains, broken (monitor) glass and tears on this post. Some time back and elsewhere, I asked if anyone knew how and why my customer's (and my) Helvetica just up and went. Nobody knew. We've been slowly converting to Arial and now I find there is a bug in converting Arial from V6 to V7! We still have dozens of layouts with ex-Helvetica on them. If you've struck anything similar, you'll know that this shows as a blank font box in layout mode. The question. Has anyone out there converted a layout with a non-font to V7? If so, what happened? (I can check on Developer's behaviour but not vanilla V7.)

Is there a way to get a sum of all the records in a database with a specific value in a specific field without having to go to find mode. For example, I am creating a stats page for the database I am working on. On this stats page I want to know the total number of records that have the color field set to red and how many records have it set to blue. Is there a way to auto-enter this info in rather than going to find mode searching, copy, paste. Heathbo

Converting a read only file from FMP6 to Dev7. Used Arial font, and it dosen't convert perfectly. I have to go to layout mode and adjust everything. Is this a known problem, or is it just me? Thanks in advance.

Using [color:"green"] TextStyleAdd(someField; Bold) works just fine to make the text in someField bold... When I try to make it dynamic and have a field named itemStyle where the user chooses from a list, Bold, Italic, etc. then use the syntax: [color:"green"] TextStyleAdd(someField; itemStyle) then it does not work. What am I missing? "Normally" we can pass the value of a field as a parameter. I checked to be sure that the result is text. I also tried using GetField("itemStyle") within the function, but no go.

Okay, here is the issue: I have a solution that consists of many tables. I use a primary table to display the related tables data in about 5 portals on one layout. The affect I am trying to achieve is the ability to show a path that someone may take when selecting something in each of the portals. (See the attached screenshot) Ex: The portals are: Business / Location / User / etc... When you select a business, you see the related locations. When you click on locations, you see the related users and so on. The portals all work correctly at this point. Here is the tricky part. I am implementing a highlighting feature that shows the path between the portals. When you…

I am trying to create a PDF library to store all my PDF files. I am unable to import my files in FM 7. Any suggestions would be greatly appreciated. Have tried several forums but to no avail. Thankyou

Hello- I have a database where I would like FMP 7 to generate an alphanumeric serial number based on 1 or 2 fields in the record, (i.e. the team and the member). For example, John Smith of the Yankees would have "YJS123456" where 123456 is the number that was created and appended to the "Y" "S" and "J". Is there a way to do this automatically? Thank you...

I have JUST begun using Filemaker for the first time and im trying to specify an image to change once a field has been changed. I have a "status" field which can be changed to active or closed. Depending which is selected would dictate which image is displayed. Is this possible? Thanks

I am able to write an "If" calculation with one condition and a default result, but cannot figure out how to write an "If" calculation that should only be completed when two conditions are met. For example, if Color=Blue and Size=Large, then Fish=Marlin Any help would be appreciated. Thank you...

Do any of you good and fair folk have a coin collection database template that I may use and modify for my own collection : Any leads will be rewarded--- in the hereafter. Thanks for watching, ya all come back now, ya hear.

How do you set the default state of radio buttons when using custom values? I have 2 radio buttons. 1. Active Custom value = ACTIVE 2. Closed Custom value = CLOSED When creating a new record I want "Active" to be selected by default. Regards Dave

I would like to create a database that takes information like name, test scores, recommendations and inserts these results into a generic word document or text document (or Form) so it can be personalized to each individual. Where can I look to find out how this can be done just so I can get myself on the right track. Thanks in advance.

Hello, I am working on a DB for card collectors. I have a script that will do a report layout for all cards the person owns or has put in at least a 1 for quantity by a perticular company. The search will look for >0 in QTY and company. I do have this setup with a self-join relationship to match year, so it does find the right year. I have the user select the company and year. The report will go through and find all cards with >0 and company that equals the global company they selected. The problem is it works great if they have cards by the year and company, but if they have zero then my script just keeps looping. I need to figure out how to show a dialog box w…

find mode has worked beautifully for me until this wrench in the cogs came up... how would you search a specific RANGE of things...for example, if you are identifying records by number and you want numbers 01-50 only. I know there is a script function to do that, but that's also pre-set, so it wouldn't be as flexible as i'd like. any thoughts as to what I can do?

ONe of the minor annoyances (for me) from earlier FP versions was the inability to freeze the first column of a layout (wo all the subsequent columns scroll horizontally but the first column stays fixed for users reference). Does anyone know if FP7 allows for this? Thanks, Mark

apology to everyone if i'm double posting but if someone can give some input on how to import, export word and excel files and view and modify them in filemaker pro please do so here. http://www.fmforums.com/threads/showflat.php/Cat/0/Number/112906/page/0/view/collapsed/sb/5/o/all/fpart/1

How do I test to determine that a certain window is open? I'm making a menu layout which will open in it's own window IF it's not already open. If it is, I'll have the script simply activate the window. Can someone help?

In pre 7 version, the solution in our medical office was protected with a password to open the files on each client in every exam room in the morning. After a few minutes the Energy Saver would blank the screen. Coming into the room the provider would enter one password for any client to unlock the screen and a provider specifie passname/password into the initial database layout to start using the solution. In FM7 I am wondering if it would be better to start at an OS X login screen, providers type in their provider specific passname/password kept in an Apple Open Directory. That OS X account would automatically open FMPro with an opener file to the database solut…

Is it possible to set a FM Pro ver 7 file to have no account name? For automation purposes, I need to skip the open file notification box that says to click on the account name and enter password. (Yes, I realize that I can set Guest to full privileges and no password, but I want to skip this startup box entirely) I am the only one who will ever use the file. Thanks! -Cliff

I have two databases: departments and people. Each department has a unique number. Each person has a the number of his/her department. The department number is the basis of the relationship between tables. I want to send an email to each department head with the information about the department and the list of people in that department. The people in each department are displayed in the department layout in a portal. Inserting the department information in the message portion of the email is no problem. The question is: How do you list the data from the portal in the email message?

Ummm.. last post got moved or deleted I think.. Anyway, here's the problem. I had a relational DB set up in FMP6 so that a Notes Database would display the Date and Tiltle of the Related record in a portal in my Main DB. Now, I had a button and script set up so that I could click on the button in the portal and it would open the record in my relational DB. The problem is, I can't edit anything in the related record once I get there. I get "This record is already being edited.. blah blah" I assume that if it is being edited in the portal, it won't let you in the record, but it wasn't this way in FMP6 any way around this? Thanks! D

I wrote a navigation script so I could do away with FileMaker's book navigation. One step in the script seems to be slowing it down. This step sets a global field with the current record number using the Get(RecordNumber) function. Sometimes the pause can be over 20 seconds and at those times I get a message that a query is being performed. This is in a database that only has 12 records in it. The record that seems to have the most problems has about 60,000 records in it but I can't see why that would make any difference since the layout I'm in doesn't use any information from that related table. Any ideas to work around this?

Hi, Just wondering if there is a sample file out there, that I can pick apart. Im trying to recreate the "continue" button from the status bar on one of my layouts (which might also be in preview mode). I know I can Resume a script by attaching the resume command to a button, but can I program the button to appear (using a portal trick or something else) when a layout is paused, thus making my interface look alot more elegant? I hope someone can help, I really dont like the look of the FM Status bar I have FMP 7 and am using it both on Windows as well as OSX, any help would be appreciated. Cheers Jalz

Why dosn't this work:- Case(1=1;TextColor ( "Red"; RGB (255 ; 0; 0);"Black" ) It displays nothing But Case(1=2;"Black";TextColor ( "Red"; RGB (255 ; 0; 0) )) "Works" ie displays red in red.

Hello, I have searched this entire forum and I can't seem to track down a solution to a problem I am having with the if structure in a script. This is an example of what I am trying to accomplish: One field is called Car::Name the other is called Car::Color, I want to create a report on what the user picks from a listbox. If the car doesn't match the color then I want an error message. I want to setup if and else if's scenerios in a script that I define for possible color matches to each car. Example of both list boxes: CAR Ford Chevy Honda Nissan Color Black White Purple Orange Blue Purple OK, let's say if the user pi…

I want to copy a record from one table to another. I have been trying to figure this out for a while and any help anyone could give me would be muchly appreciated...(i also didn't know where to post this... : ) What i have is an item list containing all items (these are sortable by type and size) The other table i have a client I then have a middle table linked to both. (List items) From the client page i enter the list items page, which contains a portal to the items page, and a portal to the client page. To start i only want items to show in the items portal that are of a selected type, then size (i sort of have this working, i can get it to …

Hi gang, My Windows WSH VBS script works perfectly in FMPro 5 and 6, but fails in FM 7. (for those Mac folk, VBS scripts are like Applescripts) I want my Windows XP WSH/VBS script to start Filemaker and execute a FM Script. Under FM7, the Documents.Open script step fails on an error - "wrong number of arguments" Any ideas?? THANKS! -Cliff Sunday evening June 27 2004 Here's the VBSscript: Dim FSO Set FSO = CreateObject("Scripting.FileSystemObject") 'FSO is filesystemobject Set objFM = WScript.CreateObject ("FMPRO.Application") 'open FileMaker objFM.Visible = True ' show FileMaker. Hidden by default. ' ' NEXT LINE WORKS …

If you use the insert file script option to actually store the file within FMP in a container field, how do you either open the stored file or copy it out of filemaker? I don't want to store the reference path. I wish to store an actual Word doc. And then I want to either launch the word doc from within filemaker, or be able to copy to the desktop to open it. What am I missing here?

I have created a perfectly working image library database(each record has an image file in a container field and some other text fields). I am trying to make this available on the web using instant web publishing to create the pages. I have a button in my database that allows users to download the image to their own computers. This button is scripted using the export field contents function supplied. This function is not web compatible so the button is disabled when i make the web pages. This function is essential to the system I am creating, can anyone suggest another way of scripting it?

I am new to FM7. I am trying to create a program that will look at all my stored PDF files that I have scanned, or try and scan them into a FM program. Have any suggestions on how to view PDF's or scan into files in FM. Thank you for your help

Is there a script step or function that will place the cursor at the beginning of a field? Thanks.

I am making a small program to write Car deals using Filemaker, I want to put a Field called "Search" where I can type in the stock number, then have a button to hit to search the records for the "Stock #" field and bring up the matching one, if there isnt one lets say stock number 2124 if it exists it would display it, if it dosent exist it would create a new one. My question is how would I accomplish this?? I went to: Specify button>Perform Find> I click the Specify button, select the "Stock #" Field. now I need to put something in Cryteria, I was thinking something like: if Stock # = Search, how would I word it so the program can understand it, or is this …

Hello, I am working on a database to show sports card grade value. I would like the user to select the year and the company from 2 dropdown value lists and hit a button to show the report. I want the report to be sorted by year and just have a field on the report for each card that states the company name. I created 2 fields that would just hold the value the user selects, then I want to do a constrain found set on the year to find all cards in my database that match the year the user selected. Then I want the company name the user selected to be used to match the company criteria I have setup for card values. My problem is I can't figure out what to use to do the s…

There have been several posts here (and elsewhere) regarding the fact that there is no built-in way (in FP7) for the user to view documents inserted into container fields (I am talking about embedded documents, as contrasted with documents inserted with a reference to its path. The latter category can be viewed by a double click). Many people want to include their documents with their database instead of storing them elsewhere on their HD and using a reference. After some thought, and much help from the experts here, the solution is actually quite simple. In my case, it looks like the screenshot below. As you can see, I set up a container field. Below the fi…

I have been using a FM6 DB as a lab notebook for the past 3 years. I recently upgraded to FM7 and migrated my old files over to FM7. My layout has a date field that is set to auto-enter the current date upon creation of a new record. When I created the FM6 DB, I had my Control Panel:International:Date settings set to DD.MM.YYYY and the field format was set to be the same, but now I have both these settings set to standard US usage. So now in FM, I have the date field set to be formatted MM/DD/YYYY and I have the Use System Formats checked. My problem is that when FM7 does the auto-entry, it enters the date as DD.MM.YYYY and causes a validation error in that field (I …

A value list using values from a field, displaying values from a second field. You can type the first few letters of an item to scroll straight to that item in the list. In previous versions of FM, you could sort the list by either the first or second field and the "quick scroll" worked according to which field the list was sorted by. THE BUG: In FileMaker 7 the "quick scroll" only works on the first field even if the list is sorted by second field. If you've got a long list that makes for an awful lot of scrolling which is the whole point of the "quick scroll" feature. Please let me know if I'm missing something here.

Is there a way to temporarily disable a specific script step? As I recall, macro writing in Excel allowed you to change a line of code to a comment by putting something like quotation marks in front of the line of code. This way you could toggle the code to active or inactive by deleting or adding the quotation marks. Does anybody know of a way to keep the text of a script intact but temporarily disable it? Thanks, Jarvis

I must be blind. But I cannot determine how to sort a portal row outside of the preset sort. I want to be able to sort the data in the portal by the field names. Thoughts?? Thanks!!!

Is there a way to simultaneously share the same file that resides on a server? The manual seems to say it's not supported, but there is a menu choice to make the file a multiple user file. I have a system that is composed of 4 related files that I placed on a server. I'd like any of the work stations on my LAN to have access to these databases at the same time. Can it be done? If not, I think this is a serious flaw in Filemaker! Thanks for any help.

Only two of my customers actually have FMP installed - both V6. When V7 was announced, I told them to ignore it until V7.5 came out. Well, V7.0.2 or something has arrived and I suspect this is IT until V8. Customer A has one application only. They are most unlikely to want any others. (This is a dream business - simple 'product', no competition and no need to diversify, etc.) I can see no earthly reason for them to upgrade before they are forced to by the usual hardware/software cycle. Customer B has many applications. Their history goes back to V1. Their major application is quite complex and, although beautifully written , it could do with a rewrite. A…

I accidentally deleted the database in the relation definition. When I restored it as 'current file' I was no longer able to select to put a new field from the database table to the layout, the 'current file' selection was gone.

This should be simple, but can't seem to find the way to do it. In the header of the layout I have 3 label fields, each occupying its own line. I want the label field to be centered for each line. For example, like a letterhead-Name top line; Address next line and date 3rd line.If this were a word processor I would select the text and simply center the 3 lines on the page. I can't seem to do this with FMP. The only way to get this to work is to expand the label field the complete width of the page, and then go to -->format-->align text -->center. I would like to be able to just center the label field, not the text inside the label field. Please advise. Th…

I currently use FMP 5.5. I would like to have a button next to a field (container) in data entry, that would allow the user to see a pop-up "lookup" of thumbnails of photos in a related database. Then he could just pick the photo that he wants and the current database container field would be linked to (and display) that photo. In essense, a glorified "browse" button like everyone uses to pick/select/or save a file when using virtually any OS and application. This option is not available in 5.5 (that I know of). Is it available in 6 or 7? Also, I have heard that it is not real easy to convert 5.5 solutions to 7. Is that a valid concern? Thanks

Has anyone noticed that the text in filemaker for windows is bigger on screen since the 7.0v2 update. I have fields that fit a certain amount of text just fine but after the upgrade they disabled font smoothing and now the text gets cut off. The wierd thing is that if I print the page it displays just fine on the printed version. Shouldn't it be the same size on screen as printed out? Everyone complained about the fuzzy text in filemaker for windows when 7 first came out but I personally think that this is worse. It doesn't matter what font I use it always appears bigger on screen than printed. I can view the database at 75% or 125% and it re-enables font smoothing …

There is a serious bug in Filemaker 7's constrain script step. In FM6, if you did a find and then constrained that found set, you'd get fewer records. If the constraint resulted in zero found records, the result would be a found set containing zero records. Any further contrains would always result in zero records. Now in FM7, if a constraint finds zero records, it returns a 401 error BUT the resulting found set IGNORES the contstraint totally and actually contains all the records that were in the found set prior to the constraint!! This must be a bug! It is ridiculous! 'Constrain' is no longer constrain at all, it is constrain (so long as the res…

I am making a file using file maker, and No text from the layout screen carries over to the Browse field, and in layout I have to move the buttons and fields around a bit to make the text display. It seems like a horrible bug which is making this program useless in my eyes, How can I make a file with no text on the layout? Please tell me what I'm doing wrong! -Frustrated FM7 User

I am using Filemaker for a member database. I am looking to create a member directory in Quark. Last year, I exported the records as tab-separated text. I then went into Quark and hit return a lot (there are 10,000 records) and then went through and bolded cerrtain lines and italicized others. Its just a normal database, but the end product needs to be in this format: <b>Company Name</b> Person's name Address L1 Address L2 Phone Fax Home <i>Notes</i> Is there an easier way to accomplish this? I have been told that there is a way to export straight from Filemaker to this format. Then all I would have to do is edit, savin…

I'm trying to automate a script importing a daily delimited file but fmpro 7 keeps giving me an error when i specify the file and folder location. ie... filewin:/S:/*.sos I'd even live without specifying the extension if it would automatically take me to the appropriate folder and pick a wildcard "all files" view? Any suggestions on what i might try or am doing wrong?

Hi, I am new to this, and fairly new to FileMaker. I am using FM Pro 7 and am haveing trouble importing a database with multiple tables that are related. When I import, it is ONLY importing one table. In the docs it says to have the layout you want imported (the other table in this case) selected when you want to import that other table. All of this is coming from the exact same database, except it is a clone of the main database (used for data entry purposes, no chance of messing up the main database - data integrity). If anyone could shred some light on this that would be teriffic. Thanks, Nick

Hi, I'm looking for some advice pertaining to a PDF document storage database I'm trying to make. I'd like to be able to write a script whereby a reference to a PDF file would be placed in a container so that it could be viewed in filemaker and then the user could double click the file or something and cause that same file to open in Adobe Acrobat. Once I have that working, I want to add various text fields to tie this into my current customer service database so that I can scan all my paper invoices and contracts for each customer and relate them to the customers other records. I would greatly appreciate any advice from anyone out there. Thanks…

Hello, Here is the question. I would like to do a report that lists all the products for a certain year, but I want the report to do subs on a certain field and I want to change that field value in a script. Example - You have a database of all cars from 2000-2004 and you have a field for color. Your database is populated with color as white only, but there may be 6 different colors you want to report on. Like first I would like to list all 2004's with white in order of name and then list all the same cars with blue and then red and so forth on the same report. I realize I could do seperate reports and do a set field option, but is there a way to have the report auto…

I have a solution that I'm trying to work out the security. What I am attempting to do is users will have on their desktops a filemaker 7 file that will open the solution files from the server. Since I have multiple users, I would like to impose the security of the users only have the ability of viewing the records they have created. If they did not create the record then the records can't be seen at all to the point that if they do a show all, only records that they have created will be shown. I'm hopping that this is possible and I have a feeling it is. Can anyone point me in the right direction on where the security priviledges this might be done or is this…

Hello All, I am using FM7 Pro and was wondering is there a way that once I created a database, I can compile that database into an executable which does not requires FM7 Pro to be installed to use. TIA!

I would like to lock some records so that they can not be edited by user but only by admin. I have a invoice database and I would like to lock records as soon as they are printed, so that user cannot edit printed (sent) invoices and thus create a mess in bookkeeping department Any suggestions welcome!

I am still not up to speed very well in V7. Does anyone know if it is possible to dynamically reposition text on a printout? With some of the new features like changing the look of the text I thought there might be a way to define where on the page it would print. (Wishful thinking?) thx.

Hello: I need a barcode scanner for FM7 so I can scan ISBNs of 2500 books at home. Can anyone recommend a good scanner that they have used which worked well with FM7? I don't have a cash register or any POS system at home, so the scanner has to go straight to the Mac. Thanks for looking, PhilPhil

I would like to use hypertext functionality for going to other layouts rather than the buttons. I just don't like a lot of buttons and I think they look clunky if used in excess. I can "debutton" the button function so that it doesn't look like a button, by making the background of the button clear and setting the pen size of the button edges to none. I can also change the font to a different color (e.g. blue) and underlined. If I could give this a "mouse-over" effect so that my curson changes from an arrow (or any other effect to show the user that it is "hot"/hypertext) to say a hand when it goes over the "hot-spot" it would be complete. Is there any way to do thi…

Hello! In my old FM5 I used Troi-dialogbox plugin which make it possible do calculated text and valuelists dropdown inputs, and the useful barberpoole. Do anyone know if its possible in FM7? I have tryed with the input options in custom dialog box but I cant a drop down value list. Hope someone can help me. -Per

Hello- In the footer of my reports, I would like to display: Page No. "X" of "Y" where X is the current page and Y is the number of total pages. I have used "Insert Page Number Symbol" for the "X" value, but how can I display the TOTAL number of pages? Any ideas? Thank you in advance- you all have been great...

How can I see all the current database users? Is there a way to list the number of users as well as their usernames??

I have just recently started using FM. My background is MySQL and Perl, needless to say I am used to alot of freedom and SQL. Currently I am working on a database for a local swimming club. I would like to edit a tables records while I am in the layout for a different table or am I dreaming?

Anybody have any ideas on the best way to make a jeopardy like game using filemaker? I'm having trouble coming up with a reliable solution. Any help will be appreciated! Phil Hayes

While some brains are malleable enough to navigate the murky intricacies of FM7's relational realms, my brain skids and crashes noisily into unforeseeable barriers, shrapnel and debris flying everywhere, that sort of thing. More accurately perhaps, I feel like a 3-dimensional thinker trying to navigate in 5-dimensional mind-spaces. Perhaps a Queue-like superhuman can point the way once again! Two tables: 1) People - Person ID (auto-serial), Name 2) Places - Place ID (auto-serial), Person ID, Place Name A portal on a People layout contains a list of all places the person has visited, where (People::Person ID = Places::Person ID). Person #1 has visit…

The attached FM7 db demonstrates two failed approaches at something that is probably quite simple to someone more skillful and/or less sleepy than I am. I would be so grateful if someone could publicly humiliate me with a beautifully simple solution! The idea is simple: I want a pop-up list to control the contents of a portal. I know this can be done because I've seen it done (and grind my teeth at not having made better note of it!). Download the file, you'll see what I'm up to. Or read the specs here... the pop-up is a valuelist with 3 items: "All, Active, Inactive". Setting it should make the portal show: a) ALL records, : records with boolean "Active?"=1, or…

Hi. I administer a MS Access database at my place of work. I really wanted to give FMP a good shot (for many reasons... I'm an apple user, I like how FMP handles all multimedia files, accounts/privledges setup, etc.). So I went out and purchased Dev 7 (with my own money... $500, now that's dedication to apple!). I have been toolin' around with it for about two weeks and I have to say it's getting harder and harder to sell it to my boss. The main sticking points are as follows: (1) You can only have five internet / intranet connections (2) I read somewhere that you can't deploy run-time apps over a network (which to me, defeats part of why you want a r…

I have developed a solution in FM7 to use with IWP. However I did not realise that the server 7 had only just been released and hosting companies say in general it is going to be the middle of August until they are fully up and running with this! I need this working for July 12th - therefore is there a way of converting back from FM7 to FM6? Emma

Hi all, I am using fm6 and i have got more than one relational file. And now i want to upgrade to fm7. ho can i convert my files to filemaker7 file with tables. thanks Adam Djuby

Hi all, new to FMP. I'm creating a database that contains information on a group of research publications, each of which has various authors. Among these authors are some researchers in our local group. What I've done is create two fields: - an Authors field, which contains ALL the authors for each publication, whether the authors are in our local group or not. This is simply a editable text field. - a Local Researchers field, which is a pop-up list whose value list contains all the names of our local researchers (which are stored in another table altogether). Here's what I want to do. Currently, when one enters data for a publication, one types in the…

I have just started using FMP 7.0. The closet I have worked in is Access. Is there a way to mimic events in FMP 7.0? I was wanting to do an "Onchange" event. When a value changes in a field I want to recalculate the value in another field. Are the "Get" Functions the close as I can get? Thanks for any help. Bob Smyth

Hi I have a database with patient information. i want to make a report that sorts the patients into each of about 10 financial classes. I want it to then sort the totals for these financial classes by age categories. I was wondering if there was a way to do this without manually calculating the totals for each age category

I have a bound solution that works fine using Developer 5.5 and installing via Inno Setup. I converted the files to fp7 and bound the solution in Developer 7. It runs fine when launched from the folder where it was bound. However, when I compile it with Inno the installation doesn't launch. Same same with WinZip and Winrar. I get a spinning cursor for about 3 seconds and then nothing. I notice the USR files after binding still say Filemaker 5.5. What am I missing? Thanks!

Hi again! I'm trying hard to get a report to work - but I can't figure out a simple (?) counting problem using subsummary fields. It's hard to explain here but the example file illustrates my problem and I hope someone could look at it and if possible tell me how to make it work! I'll explain the attached file. It opens previewing a report that has an incorrect count for the number of people insured by a particular insurance company. All other counts are correct. It's that one incorrect count I'm trying to fix. Here are the details There are two tables related by OwnerID; one owner can own multiple cars: Owners: OwnerName, Insurer and OwnerID C…

HI gang, I have a question. I used an online DB that retuned about 1200 results, in an HTML table. I am trying to ultimately get this information into a FM database. To do this, I copied all the info, and pasted it into Excel. Everything looks great. The first colum (or field) is a hypertext link to more information specific to the result. When I paste the info into Excel, it retains this hypertext link. When I click on the link in Excel, it launches my browser and displays the info. To get it from Excel to FM Pro, I save it as a tab-delimited text file. I then inport it to FM. When I do this, I lose the hypertext link. The data contained in the field are instead di…

Hi all, I am trying to set-up a multi-warehouse inventory system. I haven't used Filemaker in ages and am well rusty. I have a file with 3 tables - 1)Warehouse Master 2) Item Master and 3)Item/Location 1 and 2 are self-explanatory, 3 will hold the inventory balance of each Item in each Warehouse. My problem is that I do not want to allow non-unique records based on both Warehouse code and Item code. I tried setting up a field that auto-entered - WhseCode & ItemCode - and then making it unique, but this did not work. Any help would be greatly appreciated. Thanks.

Im trying to add an incrementing number to a header in a table layout? any suggestions?

Can a script be initiated to close a host file while logged in from another box as a remote user. In order to make updates to a host pc i have to log in from a secondary machine but until the file is closed i cannot replace the file. Hope i explained that well. My scripting so far closes the files on remote but not the host. Can't figure out how to initiate it on the host though? Jared

dows anybody know how i can get my inventory from filemaker to my oscommerce cart. i have easypopulate installed but do not know how to run it.

Filemaker still requires you to link layouts to tables to access them. Example: Set Field( Table1::field, Table2::field) will always copy a blank value regardless of the field's content. Separation of data and design with a query language will always put Filemaker in a class with a standard spreadsheet program. I use Filemaker everyday to create elaborate SQL based front ends which make up for the endless relational deficiencies of Filemaker. Filemaker is a great program if used for what it can do. Calling it a relational database is just wrong.

Newbie Question #2: In Layout mode, if I click and drag a field it takes FM a long time to redraw the object making rearranging objects very tedious. I've seen other posts bemoaning this very slow screen refresh "feature". I can reproduce this effect in a brand new 1 table file with 1 field. HOWEVER, when I create a database from a "FileMaker Template" (e.g. Contact Management)... In Layout mode, the field objects are refreshed with incredible speed when they are moved. Mind you, this is on the same computer, same FM Pro 7, same session/time. Please see my earlier post "slow radio buttons" for more intrigue. Can you duplicate this effect? Do y…

I'm having a problem with one of my loops breaking, I've had no problems with the type of loop in FM6 (re-writing in FM7), I wondered if there was something I needed to do special in FM7. Basically what is happening: Script 1: - takes a found record set and loops through them. For each record it is supposed to search in one of two files to see if there is a similar record (two different scripts triggered by if/else statement). If I don't include the two scripts the records will properly loop through, so something in them (both of them, actually) is keeping the loop from going to the next record, so I've ruled out that they aren't properly sorted... Sc…

I'm trying to automate a script importing a daily delimited file but fmpro 7 keeps giving me an error when i specify the file and folder location. ie... filewin:/S:/*.sos I'd even live without specifying the extension if it would automatically take me to the appropriate folder and pick a wildcard "all files" view? Any suggestions on what i might try or am doing wrong?

I've been having some problems with some of my more complex scripts, and I've narrowed it down to problems with GTRR (goto related records). Apparently I can't even seen to pull off simple gtrr scripts. For instance: Two tables, "gps_assessment" and "significant_others". The relationship is gps_assessment::screening_id ----- significant_others::screening_id The relationship name is "gps_TO_sig_others_USING_screening_id" There are two records related to one of the files in the gps_assessment table. So on one of my layouts using the gps_assessment table, i created a test script that is just: Goto related record [show only related recor…

I have just started using FMP 7.0. The closet I have worked in is Access. Is there a way to mimic events in FMP 7.0? I was wanting to do an "Onchange" event. When a value changes in a field I want to recalculate the value in another field. Are the "Get" Functions the close as I can get? Thanks for any help. Bob Smyth

hidden objects with scripts attached? don't even show up in layout mode unless you know where to click... are you kidding me? seriously now... is this a joke that someone is playing on us newbies? no wonder i couldn't understand some of the examples. forgive the rant... it's monday.

i have a text field that i import emails into. the emails all look the same but the have different variables in them. i want to get only the variables into their own fields. how would i do that? i email looks like this, the bold parts are the Variables that i need. im not asking for a complete script i just need an example of the script step to move the variable from the "EMAILBODY" field to the coresponding variable field. like moving the book title to the "BOOKTITLE" field. thanks in advance Dear [email protected], Your Amazon Marketplace sale is official! We've deposited your earnings from the sale of this item into your Amazon Payments a…

I have a layout that I use to search for contacts in my database. I'm using a global text field to search for these contacts by last name. Works fine in filemaker but when i go to the layout through the web I can't enter the field... Anyone know why that would be?

What is the most simple way to extract a date from a number or text field that has the date with the year first? Larry

I have a checkbox value list and what I need are the values selected put into another field on one line separated by commas. I know about the Substitue script, but I need this automated so as soon as the user selects the values, the values automatically appear in the 2nd field. How would I go about doing this???

I have tried using the Data Merge Manager in Word X for Mac to merge fields from FM7. In the Choose a File window the FM7 files remained dim. The same procedure worked if I used an old FM3 file. Is this a FM7 problem or a Word version not updated for FM7? I am using Word 10.0.0 Any help is appreciated.

It seems that in FileMaker 7 on at least Mac with Safari, a URL with capital letters will be converted to small letters before being sent to the browser. Is it just me? Other browsers? Other operating systems?

using 7.02 on 10.3.4 There is still some kind of sliding bug. Yes, fields slide properly, and big variable-length fields or portals that span over into a second page if large do shrink correctly into one page if they are small... the bug is that lots of blank pages are printed, even if all the fields of every record fit onto one page after sliding! Identical records and databases in Filemaker 6 do not do this; they slide exactly the same but don't randomly print blank pages all the time. This is a reproducible bug. Make a report with one large field or portal spanning two pages, and set all fields to slide up and reduce. Make sure that the contents o…

Hi All, I have an actor's auditions database that I would like to display a running total of auditions for a given actor. This needs to be in the regular list view and not as a grand summary part, report or portal. It also needs to be global, not just for the found set. The current list view simply has the actor's name, audition date, location and type. I'd like one more field at the end of this row that shows how many total auditions that actor has. Just the total number of records with a given actor's full name, but I don't know if I need a self join or a get function of some kind. Thanks in advance, this forum has been a lifesaver for me.

Can anyone be so kind to tell me if Filemaker Pro 7 server supports the 5.5 clients? Thanks.

why fmp7 dosnt install in win98? what is the solution? --

On a served FM 6 and below file if one person is in a field all others are locked out of that record. As I convert to 7 and create multiple tables within a file, are people locked out of individual tables or is it still record level lockouts? Mark

Very obvious bug this one. I have a report including a portal; each line on the portal contains fields from a related record. Let's say there are 9 related records, FileMaker 7 always prints a blank line at the end of the portal - ie 10 lines all up! Exactly the same code in FileMaker 6 resulted in only 9 lines being printed. Any workaround / confirmation? Thanks - chris.

I have an application in which I'd like to hide the status area, using my own on-screen buttons for all user interaction. The problem is that this application has a report in which each record prints to more than one page - and I'd like the users to be able to preview this, and navigate from record to record and page to page, *without* needing access to the 'status' area. It seems like in preview mode it is impossible to have any active buttons. Scrolling the scroll bar moves between records, and not between pages; I have to click on the little page icons in the status bar to do this. Likewise the 'continue' button is necessary and that is in the status bar. …

Hi I am creating an invoice which include product name, qty, unit price, extented amount but I need to put a

I am having a major problem with using the PDF format within Panther. when the same querry is done on mac os x, the file size is very small. in Panther, it becomes 3+ M?