FileMaker Legacy fp3 and fp5

OK... In scriptmaker there's a 'print setup' script step, which lets you specify certain settings for the print setup dialog box, and then save them with the script to let you perform that script step without showing that dialog. However, how do you store the settings from the 'print' dialog? Everytime I flash up the print dialog it can give users the opportunity to print the script and field definitions. In my particular case here, when I set the 'print' script step to perform without dialog, it always seems to default to the print script definitions options, and print to file. No matter what combinations of replacing the current print setup etc I go t…

Hi, How would I do the following: populate a field (Project number) with elements of a last name field, the date, and a sequential number starting with 1. For example, the first project for SMITH would be SMITH_050304_01, first project for MICKIEWICZ would be MICKI_050304_01. Then if there was already a project number with that code, it would add "02" to the name. Is this possible? Kathy Maine Historical Society

Need to create a bid sheet from a supply list and supplier list. Using the supply list as the rows and the suppliers (columns), I need to match each suppliers bid for the supply on a table. Not too sure where to go from there. any help would be appreciated.

Hi, this is probably an old topic, but I couldn't find an answer in former postings ... anyway: I made some files in a Mac and burnt them in a CD. When I try to save them from the CD to the desktop of a PC (Win XP), it shows the message "cannot copy file: cannot read from the source file or disk" Any ideas? Thanks in advance!

I have cards: Field 2nd-Field 3rd-Field -(sliding: Up) I would like to have the next card start after field 2 if field 3 is empty... Can I do this? Thanks!

hello everyone... i hope i can make sense here. We have an extensive database of personnel saved into filemaker with all their information. Many of them are filed that they recieve our newsletter...however we cant easily find who they are. Is there an option somewhere that can just pull out the list of people from the database of the ones that recieve the newsletter? Thanks, Alex Version: v5.x Platform: Windows XP

Hi all! Hope u can help me with this problem! I have created a Portal that shows information, but I would like to for each row to be able to show more information about this row in another place in the same layout. Can I do this? How can I make FM understand what row I have selected and how do I make it show more information at another location? Plz help me and have in mind that im all new at this Regards Joakim

Hi, I've got an odd problem and wonder whether anybody has an idea how to prevent this happening. In an invoice file (related to a product file and line items file), the users use the keyboard short cut for sort a lot (apple S), sometimes by mistake they type the keyboard shortcut for duplicate (apple d) and an invoice gets inadvertantly duplicated, throught the autoenter function it gets a new invoice number and if nobody notices it, it gets then treated as a real invoice, when in reality it is only a duplicate. Is there a way to either disable the shortcut for duplicate, or to integrate a script which does not allow for the creation of a new record unless confirmed…

Using FMP4.1 How do I make this happen? I created two fmp DB's. db"A" contains forms/layouts called comments. db"B" contains the comments. When in a field in db"A" I want to type in many codes that represent the comments in db "B" example: I would type in A03 A44 C24 up to 60 of these codes. I would click a button that would replace the above codes (that are all in one field) with their related comments from db"B". Can someone point me in the right direction? Version: v4.x Platform: Windows 95/98

Hi folks, I'm modifying a customer's application in FMP 4.0 and am stuck on an idea that just doesn't seem to fly. Basically I start the application by clicking on file1.fm3, on one of it's forms there is a button that calls script1 to open file2.fm3, when file2.fm3 gets closed I would like script1(file1.fm3) to do a re-lookup based on a particular field and can't seem to get it to fly... I tried this in script1(file1.fm3) 1 - open file2.fm3 (file2.fm3 auto runs a script to display one of it's forms that has a close-file button on it) 2 - go to a layout 3 - re-lookup, no dialog, a field Step 1 works but the layout does not get focus, w…

I'm trying to find documentation for the upgrade path for a FileMaker 2 (not PRO) solution. Does anyone know what the most recent version of FMPro is that would convert those files? TIA, Yvonne FileMaker Version: Dev 7 Platform: Mac OS X Jaguar

Hi, I've always used a program called Nutshell/Ultrapls which Claris (1989)at one time produced etc. I tryed to up grade to FileMaker Pro and got Ver 3. But found that the Browse Mode would allow anyone to hit a key and change the data at will where as Nutshell/Ultrapls would provied a pop up warning advising you that you had to be in Modify Mode to do so. I could also then lock out that Mode if need be. Well I am trying out FileMaker Pro again and I still can't seem to figure out how or if I can do this. Thought maybe all the brain power on this site may have so help for me. Thanks, Ed...

I am using Filemaker Pro 6 on a G4 Mac OS9 that is used from remote computers. I have attached photos (as a reference) from a folder to various containers throughout the database. When I go through the database, all of the photos are visible from my G4, however the other two computers in the network do not display the pictures in the container fields. The containers show the link text, like house.jpg or whatever, so I know it has some knowledge of the pictures, but the photos do not show up. I have checked the box "Store Compatable Graphics" on all of the computers on the network and it doesn't make any difference. What am I doing wrong? Fil…

Respectfully request assistance/advice to see if its possible to create a field which will allow users to add comments and save them with user name and timestamp. Therefore, a field within a field if you will that allows you to capture a comment and then protect it. Then add another comment at a later time to that same field (or container) and then protect it. As such, creating a comments field that shows all of the comments that have been added over time. This is being used as a contact dbase and I would like to be able to add comments without overwriting or appending the old ones. Instead, it adds an entirely new comment to that field each time and saves that entry…

Anyone know where the FileMaker username value is stored? Is it a consistent location or would it vary between installations, computer/network user names and between win2000 and winxp? All our users are using FMP5.5. I've had a dig about in the Documents and Settings folders, Local Settings and Application Data but found nothing. I'm therefore assuming it must use the registry but where abouts? Just thinking that I'll be able to write a script in windows, not filemaker, that can display a dialog, then edit the registry. Obviously the registry key would have to be the same for every installation. Any ideas?

This is surely possible... We have a contacts database with each company having a company id which is a serial number. Obviously when a record is deleted, there is a gap in the sequence of serial numbers like 0098, 0099, 0100, [deleted record], 0102, 0103... etc Is there a way to return a list of the serial numbers that aren't present?

Do anyone create the Statement of Account before? hope anyone can help! Thank!! I have 3 database files: 1.Invoice 2.Invoice portal 3.Office Receipt I need to do the SOA for my customer, how should I basic start for step of SOA? If anyone have any reference file, pls attach to me!

I have made a report and would like to find out if there is a way to print only the fields that have been populated. The entire report is one page if filled in completely, but for many records in the found set, only 2 or 3 different fields may be populated. Instead of a found set resulting in a 60 page printout with many blanks, I would like to print out a 3 or 4 page report with only the blanks that have been filled. Does this make sense? Is it possible?

I Was wondering if there was a way which i could have a customer sign a pen tablet and that would input there siganature onto there workorder in filemaker. Or if any one knows of any plug-ins that could help me with this.

is it possible to place a field in the header as a pop up? Help or solution would be appreciated.

I would like to upgrade my companies system of forms and tools to help the managers increase their productivity. I was hoping I could gather a sizeable collection of "Tips&Tricks" and things to look out for and things to consider from the community here at FMForums.com ... The system is a collection of forms to use for historical purposes, Drawings Transmittals, Fax Cover Sheets, etc... and right now I am planning something of the following: Create a central database holding contact information and have the remaining information fill in itself automatically when the company name is identified (say in the Fax Cover Sheet, all you have to type is the company name)…

Can I import a Q&A 4.0 database into Filemaker Pro 6.o?

Does any one know where I could find the FMP 5.0.3 Updater for Windows? I could not locate it on the Filemaker site? Thanks for the help. DSW FileMaker Version: 5 Platform: Windows 2000

Hi, After having a good look around I can't seem to find the answer to what seems a simple problem. I need to count the number of unique occurrences in a field (especially after performing a find for a report). For example, if the records show customer1 customer2 customer1 costumer2 I need filemaker to calculate that there are actually only two unique entries in this field. I've tried the count function, summary fields and calculations but haven't gotten anywhere! Any help or suggestions would be greatly appreciated. Thanks Darrel FileMaker Version: 6

When I tab within a report that already has data, the cursor always appears in the field AFTER the last character. Is there a way so that when I tab from field to field, the cursor appears at the beginning of the field? Before the first character? (I know there is a way to make the entire field be selected, but that wont work for what I need to do). FileMaker Version: 6 Platform: Mac OS X Panther

I have 3 fields: PatientID, deliverydate, ethnicity Delivery date is for babies. I need to come up with a count, by ethnicity, of how many deliveries there were. Big problem. The guy who wrote this did not limit the input on ehtnicity so I have things like Cau, cau., cauc, and so on. So I can't just say "count how many are "CAUCASIAN"" What I need is for the count to be grouped by ethnicity and then output a report of each ethnic group and the number of deliveries sorted on ethnicity. I've tried numerous ways but I seem to just keep getting the total.

Hi there all I have filemaker database that I need to make some changes to, but although I've spent a couple of hours trying, I'm failing at every turn. Not sure if it's OK to post asking for specific help with a calculation. Hope so ... What I would like to do is change the "invoice number" from being incremental, as it is currently, to a calculated field. I would like to do something like: [mm][yy][incremental] so, for today this would read something like: 0404005 and next invoice would be 0404006 when the next month comes around, the "incremental" element would be reset and process starts again, so first invoice for new month would be: …

I am using FMserver on a Windows 2000 network. When I connect using mt Windows xp machine I am getting a database that is not responding. This does not happen on other machines only the Widows XP machine has anyone any ideas? I do not know where to go next I have just reinstalled FM6. I have never had a stability issue with FM before. FileMaker Version: 6 Platform: Windows XP

Is there any possibility to input Month & Year only into Date Field without knowing the day? e.g; when I enter 05/04 will be displayed as May, 2004 FileMaker Version: 6 Platform: Windows XP

Hi Folks, New user, Long time programmer, new to FM. Kenneth2k1 (back in 2003, msg #83872) mentioned that Bob Weaver had posted a technique to generate an analysis of an application without the use of DDR and/or "FM Developer". Can anyone point me to that article, I'm having trouble finding it. I'm trying to modify a client's application which was developed by another person and need to determine what the dependencies are as I seem to break more things than I fix Thanks Marc Champagne Montreal, Canada FileMaker Version: 6 Platform: Windows 2000

I have set up the server and the created a database using the filemaker. I created it in something called Dragon Web Serveys. I can change everything but I can't access the server from anywhere. Any ideas why the server is not letting me in. I am using Sever 5.5. FileMaker Version: 6 Platform: Windows XP

I have FileMaker Server 5.5, and FileMaker Pro Unlimited 5.5 running on a Mac OS 9.1. When I chose open remote from another computer running FileMaker Pro 6 it finds the database on the server. When I go to the Mac to open the remote database there is nothing listed. I thought this was funny because the database is sitting on the Mac but I can't even see the computer. What's the deal? Mark FileMaker Version: 6 Platform: Windows XP

When trying to use the updater for upgrading developer 5.5v1 to 5.5v2, both in the classic environment as well as a native started OS 9, I get an error after the installation has just begun. Error message is 'Resource was modified'. Anybody a clue? My system is Panther, the current Filemaker (Developer) 5.5v1 is running smoothly there. The updater asks to go to classic. Thanks in advance. Harry FileMaker Version: 5 Platform: Mac OS X Panther

I need a way to reduce the full first name to the first initial or first two if the last name is the same. ex. Smith, John Smith, Jason Need to show Smith, Jo and Smith, Ja Any help would be appreciated. FileMaker Version: 5 Platform: Windows 95/98

I am a novice user of filemaker so you anyone out there who can advise me on this. This calcution is to simply determine the monthly payment for a loan scheme with the (amount loan) and the (payable periods) of 12 , 24 ,36 or 48 months with an (interest) of 3.5% or 5%. Finally, the results would then be the (monthly payment). How would I go about stating the script? Thanks a million for those who help me out. FileMaker Version: 5 Platform: Windows XP

Hi Folks, Does anyone know if Bob Weaver's "SoftDoc" has evolved since it's first appearance sometime around Oct 2002 ? The Thread Are there other ways to get a FM project analysis/dependencies if one does not have DDR and/or FM Developer? FM seems very popular but it lacks constructs that would make modifying someone else's work a lot more easier I think. Thanks for any help. FileMaker Version: 6 Platform: Windows 2000

I'm having problems with a database solution with online access locking up. I have a Win 2000 server hosting the database with FMP Server 5. I am using a second Win 2000 server running FMP Unlimited 5.5 connecting to the server and using FileMaker Web Companion. I only have one license for FMU and am holding out for FMP Advanced Server 7 so I can't setup a RAIC. I thought it might help if I use FMP WSC to allow IIS to publish the web pages and let FMPU and FMPS focus on the database operations. Will this help or am I wasting my time? I think I have setup up WSC and IIS properly. FMPU is setup to use port 591. I was able to successfuly add the databases to the WSC con…

I have a layout that is for invoices with several calculations. The layout is in categories, each category has a quantity and a dollar total based on that quantity and a grand total of the quantity of all the categories and all the dollar totals. I also have a layout that is a grand yearly total (summary) of all the invoices in the first layout. What I would like to do is find a way to create a new layout that separates the invoices by month so that I can get a total for each category AND the grand total for each month (We have to hand in monthly reports and I cannot figure out how to do this without creating a new database for each month). As you can probably tell, I…

I've created a database using the company version of Pro6, and can't work out how to e-mail a record! I've been printing out copies of the records to send to people, and would like to be able to email a copy of the record, with all the field names and with the same layout. I've tried copying the record and pasting to word & outlook, but can't see how to retain the field names and layout. Anybody have any ideas? Thanks, Derek FileMaker Version: 6 Platform: Windows 2000

I am using FileMaker 6 on windows xp and FileMaker Server 5.5 on a mac with OS 9.1. I can't find anything that tells me how to hook the two together. I have installed both products and I can remotely connect to the server but that doesn't get me anywhere. I don't know how to get my database from filemaker to filemaker server. I'm not even sure if I have set them up correctly. THe documentation that comes with the products is useless and I need help. Thanks. FileMaker Version: 6 Platform: Windows XP

I'm baaaaaaaaaaaack. Here is the situation. There is a date that needs to be entered under certain circumstances. The date has to be within the last year. That is no problem. HOWEVER, what has come up is people entering the date when they shouldn't and since there is a verification by calculation on the date, it won't allow them to delete the date. So I'm trying to figure out how to set the verification up for EITHER blank or within the last year. I tried IF(IsBlank(theDate),'',figger it is in the last year) But it just told me that I had to enter a date. Any suggestions? FileMaker Version: 3 Platform: Windows 2000

I saw that some people using a PC had this same problem, but has anyone had the same problem on the Mac? I am using TCP/IP to host a Instant Web Publishing database, have no corrupted fonts, but still when trying to launch FMP it goes through the whole process, even says "TCP/IP successfully loaded" but just sits for about 4-5 minutes before getting into a state where you can work with it. And it is when I open the FMP application (even when I am not opening a particular file in FMP.) Below is the closest solution I've seen for the PC, but not applicable to the Mac. Please help!! ------ Re: FileMaker hangs on launching #26193 - 08/22/01 02:31 PM For what…

I have a simple sales report. Each line item summarizes the sales activity of a given dealer. There are no Body parts in this report. The summaries are sorted by dealer, then by total sales -- best performer at the top. Viewing the sorted report in Preview mode, the report works perfectly, with one maddening flaw. When (and only when) there are more than 500 to 510 records in the found set being summarized, the TOP dealer on the report shows incorrect summary totals-- Switch to single-record Browse mode and the correct totals are displayed! But go back to Preview mode and these first-summary totals are way smaller-- but as I said, ONLY if the found set is over 5…

Anyone know how to put the total number of pages in a footer on a report so that it reads: Page X of Y (ie. how do you put/calculate "Y"?) Thanks FileMaker Version: 5 Platform: Mac OS X Panther

Hi, folks! Under Mac OS X, FileMaker Pro 4.0 (and I imagine other "classic" versions) have layout problems. I read in the posts a couple different kinds, one of which is the dragging of fields/objects and their resulting duplication instead of relocation. It's as though you are OPTION-dragging them but you are not. To get around this, I have been moving objects in layouts with my cursor arrows, and although this works, it is an exercise in patience to say the least. If you have found a better solution/workaround, please tell me. I have a nifty 17" G4 PowerBook but cannot boot in Classic. I am working on a couple low-budget web projects and going to use FMP4 for…

HI can anyone help, I'm trying to create a pop-uplist based on a field full of words seperated via a space, looks a little like brown cow field milk calf (you get it!) I'm doing a string count into another field called key1 (leftwords(keyword,1) and another in to a field called key2 (leftwords(keyword,2) then defining a value list which allows me to specify from key1 and also include key2 but thats as far as it allows me to go in the html file im using valuelistitems [FMP-if:currentdatabse.eq.picture.fp5] <select name="keywords" size=1> [FMP-valuelist:keywords, list=keywords] <option>[FMP-valuelistitem] [/FMP-valuelist] [/FMP-if]…

Thank you for your help about ways to do the project below. Could someone kindly now help me estimate the magnitude of the project? The goal is to combine the information from 24 files into a single FileMaker database. Almost all source files are in FileMaker Pro 6 (.fp5) except for three files in Word, one .htm file, and one .pdf. Among the FileMaker Pro files, the same fields do not always have the same names. Also, fields that are present in some files are absent from other files. Where the source files have different information about the same record, all information is to be retained by adding new fields to the resulting record to ho…

Is it possible to configure FMPro to automatically open a certain database when you start the application? For example, I created a one-layout database with several buttons that script to opening their respective databases. What I'd like is to set up our computers to have this database automatically open when a person starts FMPro. Then they can simply jump to the database they wish to use by clicking a button. FileMaker Version: 5 Platform: Mac OS X Jaguar

I am running a script that essentially looks like this: Go to Portal Row [select, Last] Set Field ["transactions::account_number", "12345"] All field types are text. What happens is that instead of "12345" being inserted into a new record in the "transactions" portal, a value from a completely different field ("company_number") is inserted instead. It dosn't matter if I change the "12345" to reference a field, it still sets the "account_number" field to the "company_number" value. If I take out the Go to Portal Row [select, Last] script step, the Set Field step works like it should. The problem appears whenever the script tries to create a new record.…

I have to solve this today. How do I put a JPG into a container field?? I created a simple database... number, first name, last name, and picture (a container field). All fields are on a layout... viewed as a list... I've entered a few records... all the data went in just fine... the container fields are all blank. Now, I want to put a small JPG into the container field. The JPG is sitting on my Desktop right now. I tried dragging it and dropping it on the container. Nope. I tried right clicking on the container, selecting Insert Picture..., and then in the dialog selecting the JPG file. Can't, the JPG file is grayed out... even though I am allowing A…

Here is a new one on me. I have a calulation field with a numeric result. It is a simple If statement that uses two indexed numeric fields within the same file. FM 5.5 will allow me to turn on indexing when I define the field. BUT, FM converts the indexing status to Do not store as soon as you quite define fields. I only noted this because when I would try to search this field it would have to index first. Open up define fields and there it is, an unstored calculation again. I have rebuilt the file several times. Again, no global field, no summary fields, no related fields and no unstored fields are used in the if statement. FM has no problems allowing me to set …

Hi, We are developing a system using FM to record quality management systems for our business. We have created unique batch numbers, within which each item has its own number code. The batch id has 2 fields which identify the lowest and highest individual item number respectively. On another layout, we use the item number to assess characteristics of that item, but we want to automate the other fields which relate to the parent batch. For example. Batch 001 has item codes 1000 to 2000. The batch was created on 11/04/04 and originally came from site A. This is in Layout called Intake QC. On Analysis QC layout we want to input item ID 1500 and have the details of d…

Thanks for any help! I've created a sales tracking tool for auctions and am looking to output a report for my clients. What I'm having trouble with is creating a script to find all items with an end date (a calculated field) of Today or later. Then I can show the clients what auctions are still live and some details to go along with them. Ideally I'd click a button and run a script to find these items, sort them, and Preview them in a particular Layout. Thanks for any suggestions. FileMaker Version: 6 Platform: Windows XP

I am running a G4 OS9.1 and using Filemaker Pro 6. A client supplied me with a file that, when opened, gives me a log-in screen to a remote host over the internet. The problem is that I can access the host from 4 other Macs on the same network, all with the same builds. I have reinstalled FMP, then I reinstalled the OS with no luck. I have checked to make sure that TCP/IP is selected and that it loads successfully. All the Macs can get to the internet(meaning they can surf the web). I do not receive an error when it fails to log in, it just brings me back to the log in screen. As far as I can tell the Macs are running with the same extensions and programs. Which remind…

Hi - I'm sure there's a simple answer to this but for the life of me I can't figure out this program. I'm new to databases generally and fm i particular. I'm trying to export an fm text file. I need to add a tag to the beginning of each entry in each field before exporting so that I can upload to another program. So, for example, I would like to add "tag1 " (with a space) to the beginning of every entry in Field 1, then add "tag2 " to every entry in Field 2. How do I do this -- using monosyllables if poss?! Thank you! FileMaker Version: 6 Platform: Windows 2000

Is there a way to alphabetize my layout titles so I don't have to browse through each one? FileMaker Version: 5 Platform: Windows 2000

Hello, I am using FMP to generate an HTML page using data from fields to fill in paramters and image names. Although most browsers are forgiving and do not requite the quotes areound parameters I do like to follow the HTML spec by using them. FMP will not allow nested quotation marks, so my question is: how do I get a calculation to output concatented text and field data with quotes in it (example: <td height="25" align="center" valign="top">). Thank you, Robert TMR Design FileMaker Version: 6 Platform: Mac OS X Panther

I need to convert a number to a text string that is appended to a text file. If I convert the number 9.12 it comes out as the correct number 9.12 If I convert the number 9.00 it comes out as 9 when in fact I need the number 9.00 Can you help me with this? Thanks FileMaker Version: 6 Platform: Windows 95/98

I have an older 3.0 file that contains a ton of data I need, but the file has reached the size limit and will not open. What can I do to retrieve the data in it? FileMaker Version: 3 Platform: Mac OS X Panther

I use file maker pro on Windows XP. Opening up a web page does work. However, the link does not open in the foreground (e.g like a introduced in Excel) but in the background. Is there a way to set XP or filemaker to open up all links in the foreground? Thanks for help, Daniele FileMaker Version: 4 Platform: Windows XP

Hi guys. I'm trying to find a method of creating a link that takes you to the folder that a file lives in. Essentially a field that becomes a hotlink like on a web page. Clicking on it would take you to the desktop and open the folder for you. I'm sure there's a way to do it but can't dig it up at the moment. thanks -andrew

Help!! I am in the process of converting an Access database to Filemaker. In Access, you can use "Dlookup" to have the contents of a field automatically show up in a form. I know this is similar to the "Look-up" function of Filemaker, however, the lookup I need to occur is based on two matched fields (vs. the one matched field you set up in a relationship). More specifically, in one file I have a list of accounts with balances in each of those accounts by year. In the second file, I need to allocate that balance to different departments for that year. I would like the balance to automatically come up in the second file based on the year and the account. Please …

HI guys bit of a newbe to the forum here, so let me know if im off topic. right here goes, I've been putting together various web pages for viewing data entered into an FM6 database. I was wondering if anybody knew if it was possible to construct a CVS output function so users could download the info they'd pulled up off the browsed web page? or do I need to start looking at java or something? Anyone got any ideas or could point me in the right direction would be most appreciative. FileMaker Version: 6 Platform: Mac OS X Jaguar

Problem: I need to create a date calculation for a simple invoice solution I am working on. I need to be able to calculate a date 45,60 days from today. When I try it, I get a returned result with "0001" as the year. Any thoughts? Thanks! Mark FileMaker Version: 6 Platform: Mac OS X Jaguar

I am trying to make a script to make a change to a found set of records. I find the customer's job by name, and then I want to change the "Shipped" field from either a blank entry or NO, to "YES". There can be several entries for each customer/job. I get hung up trying to pause the script to find the customer (it keeps wanting to find my last find). I know I then need to do a 'replace', but I again get hung up navigating to the "Shipped" field to make the change, and then how to do it! Any help would be appreciated. S.D. FileMaker Version: 5 Platform: Windows XP

I'm using the Filemaker Framworks Solution template found on Filemakers website. I'm having a bit of a problem understanding one of the buttons in Invoice.fp5. The button chooses contact information from the People.FP5 and regenerates this info into fields located in the Invoice.FP5. When I opened Scriptmaker in the Invioce.FM5 to figure out how it's regenerating the info the script has several subscripts that states: perform script [sub-script, External: "people.FP5". There no way that I know to edit the

anyone can tell me what is the best way to "refresh" a screen?: I have a layout in which you input values for several fields and at the bottom of it (after gathering the information typed in by the user and the info in other DB) it gives a total. (the fields "set" are setup in a portal: each portal row gather info that is use to calculate the final value.). when I'm done inputing the date in the portal row, and I click anywhere outside the portal and I get the updated final value, but wanted to set a button/command which the user can click on to update the value (instead of having to figure out that the value will be update if they click outside the portal). I tried it wi…

The first upload didn't work FileMaker Version: 5 Platform: Mac OS 9

PHOTOS: When I insert photos as a reference to the file on the server computer I can see them there in the container field, but the photos do not show up on the other computers on the network. Am I forgetting to check a box somewhere, or should I just go ahead and put the photos directly into the database? SHOW OMITTED: When I do a "find" and then "omit" certain records from that find, and then "show omitted", I see the records I just ommitted as well as the original records that were passed by in the first find. Is this normal? What I want to do is do a find, and then omit some of those records and then show just the ones I omitted to make a report. Any sugg…

Hi, I am new to FM and will like to know how can I link to other files. In other words I have a layout that has subgroups which list other subgroups that when selected accesses other files outside of the file. Any help is appreciated FileMaker Version: 6 Platform: Windows XP

Hello, I would like to create a field that will 'know' if it is the last record. I have been posting with regard to using a database to generate HTML output for this application I need to know if a record is the last one so I cen generate the appropriate closing HTML tag. Thanks, Robert FileMaker Version: 7 Platform: Mac OS X Panther

Good afternoon, I want to be able to perform operations or or calculations only to record numbers (could be any field) that are divisible by a certain number. In this case I want to have a particular snippet of appended to and record that is a multiple of 4. How do I do this? Thanks, Robert FileMaker Version: 7 Platform: Mac OS X Panther

I

im trying to build a contact management databse that can draw common addresses from a linked file. i want to be able to add diferent address, then use them as a basis for the main database - saving time on multiple entries with th esame address. Ive been getting help from a friend who has suggested using an ID for each new address, making each entry unique - which would stop any problems arrising from two company names being the same. The problem im having is that as the top line of the address is the company name i want to referance the file im getting th eaddress from via the ID - not th ecompany name... but i want to only show the company name and address in the port…

A friend has several versions of the same FileMaker Pro 6 database. The versions were completed at different times. Much of the information is the same in each version, but some is unique to one file or another. The record layouts are not consistent. The same fields can have different names in different files, and some fields are not found in every file. There are over 1000 records per file. What are some practical, efficient ways to take all the old versions of the database and use them to create one new combined database, which will contain all the data from the many existing files? Thanks for your help. Brad …

Hi I am new to publishing FMP files on the web. Until i can find a good cdml resource i am using the "web companion". Anyway - it does'nt matter which "view" i choose from the pre-established FMP pull down (gray, blue-yellow, lavendar...) when i view my DB through the web browser on a mac or pc, the form elements, specifically the input boxes are partially cut off or missing altogether - especially on the submit a new record page. Any one know what i could be doing wrong? thanks in advance. FileMaker Version: 6 Platform: Mac OS X Panther

I am wondering if anyone has had any problems running Web Connector on Windows Server 2003? Thanks. Justin Grewe

Is it possible to execute a script when the user hits the enter key in a layout? I'd like to create a "default" button in a standard layout if possible.

I have been working on a complex job tracking solution for a couple of months now. Its my first solution and I'm pretty proud of it. Its working, and I'm using it at my job but I'm afraid that I could have built many parts of it more simply or done things more effectively. If anyone is interested I'd love to get some feed-back on it. If anyone is interested in helping me out pro-bono either by e-mail or in person (I'm in NYC) it'd be greatly appreciated. Thanks FileMaker Version: 6 Platform: Mac OS 9

Hello, all. I need to be able to hyperlink non-HTML text from one field to another within a single document, or from one field in one document to field text within another. I've been searching for a solution to this for weeks. Can this be done? If so, can someone walk me through the steps? I'm not a programmer and am not familiar with the more advanced features in FM, such as portals. I'm on FMP Unlimited 6 on a Mac running OS X 10.2.8. Thanks. Regards, Nicole FileMaker Version: 6 Platform: Mac OS X Jaguar

I have three Mac iMac with OS 9.2 running FM Pro 5. On two of the computers they work fine as far as my problem in the Layout Pop-Menu is concern. However, one of the iMac is not working like the other two. Here is my problem. I have 15 layouts, when I click on the layout menu my option goes to the bottom of the list and I get scroll arrows at the top my pop-up menu. What I would like to happen, since my layout is at the top of the list with a check mark, is for all my layout to show at once without having to scroll up to the top of the list. On my other two computer when I click on the Layout Pop-menu ALL my layouts show with no scroll arrows. I hope that there is a set…

I'm a novice user trying to develop a distribution database for the free magazine that I&#8217;m working for, and I&#8217;d appreciate some advice on adding some functions to the database. I've managed to make the database handle the venue, contact and quantity information that I want, but am struggling to make the db track changes over time. The magazine has monthly distribution and I would like to be able to compare distribution quantities from month to month both for total distribution and for distribution within each venue type. I put this together starting with the contact database template included with FM 6 and I would appreciate any advice on ho…

My setup is as follows: FMP Server v5.5 running on OS X v10.3.3 (G4 tower) FMP Client v6 running on OS X v10.3.3 (2 iBooks and 1 iMac) My problem: When trying to open a file with FMP Client v6 being served by FMP Server v5.5, I get unexpected quits. The crashlog file generated says that a "EXC_BAD_ADDRESS" AND "KERN_PROTECTION_FAILURE" has occurred. If I open this same file directly with FMP Client v6, it opens properly. If anyone has any insight into this problem, it would be appreciated. FileMaker Version: 6 Platform: Mac OS X Panther

I have a networked solution at an Elementary school using Macs with systems 8.6 through 9.2. The software was built on FM 5. They are buying new computers which will have OS X installed. They are also using FM Server software which is not OS X. What problems am I looking at in keeping them in operation with my software?

Can someone please share better way on closing a main database file plus any other related database files used? I have a database that uses/rely on 10 other different databases. My document is set to run a script when closing the main document to performs 10 different Closes [ ]; is there a better way? TIA -Deo FileMaker Version: 6 Platform: Mac OS X Panther

I am running Server 5.5 on Windows 2000 Server. If a user login to check backup schedule from FileMaker server console, he won't be able to see any schedule at all. (But he can create a backup schedule but it will disappear when he logs back in) But i can see all the backup schedule if i log in as administrator. Does anyone knows how to make a non-administrator privilege person to see/edit backup schedule from Task scheduler in FileMaker server console??? Thanks in advance. FileMaker Version: 5 Platform: Windows 2000

Okay, I'm having some difficulties with some statistical calculations I'm working on in FP5. Anytime I try to do an exponential calculation (field^2, or field*field), any decimals in the existing numbers are removed. I've tried setting the number format to the proper number of decimal places, but I can't seem to find a way to make it work. Actually, I've had it work with ONE field. I was making a field that had a result of another calc field squared. This one seemed to be okay, but I've not been able to get correct results for more complex calculations (e.g. 1/field^2) Is there some setting that I'm missing, or is FP5 just incapable of accurately computing a…

We're starting to move some Mac clients from 9 to 10. I just saw a case where the option key does not bring up the password dialog! Anyone else seen this? Anyone have a fix? FileMaker's site doesn't mention it (that I could find, anyway). Thanks, Jeff FileMaker Version: 6 Platform: Mac OS X Panther

I am trying to insert a link to a PDF file in my database. But when I check of "store only a reference to the file" and click ok, I don't get the PDF file icon, but I get a miniature pic. of the first page of the PDF file. Is ther any way that I can get a link to my PDF file? I am using FM 5.5 and OSX. Thanks FileMaker Version: 5 Platform: Mac OS X Panther

Hi all, I've been in the final stage of developing a database for a collector friend of mine, the files feature a summary page where all the statistic information can be found, ie totals for each category, historical cost and current value etc... everything seemed to work very smoothly until now, i'm faced with a reality that with a set of 8000 records (potentially more), this summary page takes more than 10 minutes to generate the numbers. the majority of the fields (about 90) on these page are just calc fields with sum(relationship::field) the computers which i used to test this were powerbook g4 400 with 384mb Ram, PC Pentium 3, 700Mhz with 256mb Ram. …

I'm newbie on FMP. My problem is any idea or info for statement account? about the date amount calculated. Pls help! FileMaker Version: Dev 6 Platform: Windows XP

Greetings, I developed a large database system (40 databases) for my employer. They are now opening offices in the USA and they want to keep the 2 database systems separate so they asked me to duplicate the solution. Those 2 database systems will be served on the same LAN by 2 different servers. Obviously it is very important that the US and Canadian database systems don't get mixed up. My first though to avoid confusion was to rename the files but then I realized I would have to re-specify the several hundreds relationships not to mention all the Open database script steps and calls to external scripts and such.... hours and hours of work. I am afraid…

I have inherited a Filemaker Pro system which drastically needs updating. I want to be able to link 2 fields together so that when one value changes it immediatly updates the value in the other field. However, I have not been able to do this using the 'if' function as you would in Excell. Does anyone have any tips on how to do this? FileMaker Version: 4 Platform: Windows XP

Using V4 over the web. Unfortunately, I have a "colleague" who insists on inputting and importing at the server, which most times results in an error message when trying to use the database on the web. Can I lock the database without requiring a password on the web? Can I lock the computer down? Hope someone can help! [email protected] FileMaker Version: 4 Platform: Mac OS 9

What's the best way to pass data automatically to another user's database? I am trying to construct a tracking type system where one user creates a user record and another user picks up on that record to create a job ticket...some kind of script that runs with something like a save button? What's the best way to store a customer's info so that items can be added over and over? I'm having a little trouble visualizing how the structure should be

I'm having a problem with creating a self-join. I must be doing something wrong, but I can't place my finger on it. When I create the attached self-join file, and then reference the relationship, it's showing blank records where the original records have been omitted... I'm sure it's really obvious, but I think I've been looking at it too closely... Any help would be appreciated... Thanks, FileMaker Version: 6 Platform: Windows XP test.zip

Is it possible to have a script play a sound that can be heard on each computer running on a network? (for a message system) Thanks for any comments. FileMaker Version: Dev 6 Platform: Windows XP

I am working on a project that tracks orders. I have a field which stores the USPS Delivery Confirmation number, however I was wondering if anyone has experimented with a inexpensive bar code reader setup that would automatically input the Delivery Confirmation number, rather then manually inputting it for every package. Any ideas? Thanks!

Lost the password to a database that hasn't been used in a while. It was made with and is being opened with FM Pro 3.0. I saw a post mentioning a 'default password' but I do not know how to reset this. If anyone can help me get back into my file, it would be appreciated. Thanks Rob Version: v3.x Platform: Windows 2000

I am having a problem at one of my customers. They are set up in a FileMaker Server environment with up to 10 workstations. The problem is that at random times one of the workstations(not the same one everytime) will get a "Sorting" dialog box when they are not on a screen that has a sorted portal and are not running a script that performs a sort. When this random sort dialog appears, it appears to be sorting all the records in one of the files. Also, it basically ties up the other workstations when it does this. The other workstations get the squiggly line. Any thoughts. FileMaker Version: 5 Platform: Windows 2000