FileMaker Pro v7 – v11

I have a portal...which draws it's information from a 2nd data base. I would like to make 2 two scripts that do the following: 1) The first script I would like to make is one that goes to the second data base, but keeps the same insured ID. This is so I can add a line to the portal. The reason I do not add it directly to the portal is that I have too many fields...Only some are shown on the portal. 2) The second script I would like to make is when you click on a row in the portal...the seconf data base opens the the relating portal entry... Is is so I can view the other information not listed in the portal.... Can some one help me with both scripts..... …

A list layout with leading summary. When data are changed, the summary part won't update unless I leave the current table and come back again. What am I doing wrong here? Didn't remember having this problem in FMP 6.

Is there a way to run a script over the internet, to a host from a client to print at the host site, or have the host send out an email? Thanks JB

Why can't I change the date format? I find it annoying how in filemaker it won't let me type the date in any way i want, eg "saturday may 15 2004" or 2004/05/15" or "jan 22 2003"... In access you can do that, and I think it makes inserting dates easier. I beleive the Canadian date format is yyyy/mm/dd, so for people in Canada it sucks to have to use the year last. Is there a way to change this?

Hi, I have a layout showing for each record in the current table, related records from another table through a portal. Everything's fine except that the last row in the portal leads to the same record as the upper row. Besides, the last row is "invisible", i.e. none of the fields display anything (I set a picture for each row in the portal, that's why I can say there is an invisible row: the picture appears but not field values). The relation between the 2 tables is unambiguous. Any idea

what i am trying to do is build a database where i enter a name in a layout that is like a table. then that name is applied to a generated letter on another layout. but what i am trying to do is make it so that after the name there is a comma. so it would be like: Dear Anyone, what i would like to know is how can i get that comma there without having to type it myself so that the comma is there automatically? any help with this would be great. thanks in advance.

Is it possible to update your existing fm solution? For example: If I would make an invoicer solution with some features like products, addresses, invoices,...in one large database and only one window with many tables. Now when my client used database for some time and needs a feature to calculate firm travelling expenses. I many windows programs you get an update, insert disc and run update program wich installs you the new feature. Is this possible in fm or i would have to make solution in many database files like feature one, feature two, etc. and put them together in whole solution? Thanks Dean

Forgive me but I don't have the new 7 here at work so don't remember what it's called. There is an option in find now that will find part of a word - anywhere within the field. I played with it. If I set the find to INDA, it will find Linda - for example. However, I can't get it to work right. I established a global text field to hold the search criteria and a calculation (concentanated text) with FirstName & " " & LastName & " " & PhoneNumber. I want Users to type what they want in the global then use SetField - this calculation field - using a fuzzy find thing. But when I write this script, it won't work: Enter Find [] Set Field [ca…

I applied a little graphic design trick I know to my horribly fuzzy fields and it solved the problem. Select all of your text fields at on time (this is for speed, not a necessary step) then duplicate them. With the duplicated fields still selected, position them on top of the original fields and then nudge them, one pixel at a time. My fields came into focus with the duplicated field just one pixel to the left of the original. By the way, I did this with the original fields having a color fill and the duplicates having a transparent fill plus both fields have black text. Take care, Leslie Davidson

Is there any way to set up relationships that are inexact or "partial"? I'm sure I've gone through this with myself before, but I can't remember if I found a solution or not. To be more specific, I would like to create a relationship between two text fields (globalfield1<-->textfield2) that will act as a filtering relationship. If I put "c" in globalfield1, I would like all values in textfield2 to relate if they start with "c". This is, in effect, much like the way a type-forward drop-down list works. If I put in "ch" only values starting with "ch" are now related, etc. If I were in find mode, this would be the same as looking for "c*", "ch*" etc. …

Well, I'm not getting much feedback on my ActiveX issue, so here's another concern. I have been testing the file sizes of databases containing pictures. Each record has a PNG graphic requiring 8K to store on disk. FileMaker needs about 20K for each picture (after the database is compressed). Am I doing something wrong? Is there a good reason for this? Is it a bug? a weakness in the database structure? This occurs in FM6 as well as FM7. Using a new feature in FM7, storing files in container fields also has a size multiplying effect. Any comments will be appreciated.

Once you invoke the Adjust Window Restore position, how is this position modified? Seems that even deleting the script step still restores the data from the first time it was invoked. Rod

I can't seem to get the TextStyleAdd function to recognize styles when referenced from a text field, placing the style directly in the function works fine, but referencing a field produces no change. Am I missing something? Here's the Calc I'm using basically taken from the example in Help: TextStyleAdd ( TextStyleAdd ( FormatText::Txt1 ; Plain ) ; FormatText::FontStyle) Where FormatText::FontStyle is a text field.

FileMaker Business Tracker is a nice program, but I don't know if it is possible to do this: FMBT has invoice and products. When I input new items in product, I get to enter my inventory in "in stock." field. Now when I create an invoice, and input how many of this product is ordered. Can Filemaker automatically deduct the the inventory from the "in stock" field? Thanks Randy

I'm trying out FP7 and find its new relational database thing to be really awkward. I've been a database developer on Windows platforms for years. Maybe MS technologies have too much influence on me. But I really don't appreciate FP7's second-hand / amateur way of handling relational databases. For example, multiple instances of related tables make it so awkward and confusing to define calculated fields using relations. The relations are not directional. There isn't the concept of primary/foreign keys, which is pretty much the foundation of any real relational database engine. There's no cascading update. The "layout" based UI is clumsy and inefficient when you have a fai…

So... cool! I'm excited about the new release! But what exactly are "tables"? Are they related at all to the View as Table view? What is the benefit of having "multiple tables per record"? Version: Developer v6 Platform: Mac OS 9

Okay so currently I have a nice fairly tight filemaker 6 database. 1. Is it easy to upgrade this to .fp7 (simple file extension change) 2. Are there any annoying bugs that haven't been iron out yet. 3. I'm looking in to having a palm sync setup so is mobile version of 7 much better? 4. What main benefits am I going to get? 5. I'm currently working on organising the database from a one-to-many to a many-to-many will this version make my life easy for this? Any help or advice would be nice thanks! Simon

Hi from Greece... Sorry for bad English Some thoughts to share I hear and read about a questioning in screen redraw / screen flash from many Fm Pro users and developers. Questions like: -What can I do with my graphics to be lighter? -How can I make my database immovable if I have 3 portal /20 buttons and series of loops in my scripts? -My screen is always flashes... what can I do.? -The screen flash in Fm pro turn my solution in a nonprofessional look. and so on. The Graphical user interface in all applications belongs in one of 3 categories. 1) The Tools Palette Style Where we have a menu bar and the tools in palettes. The Document / Proj…

Is it possible that by using a script I can manipulate data in a related table without having to create a layout and include a portal for that table? I don't see such commands available in the script editor.

Hi - I'm upgrading from FMPro 5 to Version 7, and haven't used it in a long time. I'd like to find out if there is a way to have FileMaker "email" a given record(s) ... for example: We own a hosting company, and want to be able to send their 'hosting account info" emails ... something like: Dear <FIRST NAME FIELD> Welcome to our hosting solution ... your domain is <DOMAIN FIELD> and your UserID is <USERID>, etc. I'd simply create a new layout with this "form letter" and this is would I'd like to be able to send via email. I searched the FM knowledge base, and called pre-sales with no success ... I searched under "SMTP" assuming Fil…

I'm new to FileMaker but am very familiar with RDBMSes in general. I'm creating a database that includes both multi-table joins and self-joins. I've defined these relationships in the relationships graph. I want to show users on the detail screens for a given record other related records, either from other tables or the same table. For example, in the DEVIATIONS table, the REPORT_NO field acts as the primary key, and the RAD_LOT_NO and HPTC_LOT_NO are foreign keys from two other tables. I want to show the related REPORT_NOs from DEVIATIONS that share a common RAD_LOT_NO and HPTC_LOT_NO. So I add two portals to my layout and configure them. The related r…

I have a calculated field that is derived from three other fields, "Organization, Last Name, and First Name." The fields appear in the calculated result in the order shown. The calculated field might display as Organization or Organization / Last Name, First Name or Last Name, First Name depending on which of the composing fields have values. The problem is that a sort, even when including only the calculated field in the sort definition, seems to always be based on the contents of the Last Name field. I've been unable to locate any parameter in FileMaker which would produce this behavior, so here goes the old "Help"…

It seems that in FMP 7 a portal's scrollbar is only visible when the portal's pen pattern isn't transparent. I don't believe this is the case in FMP 6. Is there a way that I can show the portal's scrollbar only without framing the portal?

Hi, I was wondering if it is possible to add a new field into a record without it affecting all of the other records? Also - when I added something it didn't format into the layout I had created. In other words - the font and text box for the new field is in the standard layout - black text. Is there a way to fix this or avoid this? Thanks! - Suzanne

I need to have a TABLE VIEW type layout that puts field names in a column on the left and record values in a spreadsheet type grid on the right. In microsoft excel this is accomplished by copying a row of values and doing a "PASTE SPECIAL" command that would transpose them from being distributed horizontally to being distributed vertically. For example: The values in cells A1-B1-C1 would show up on the spreadsheet as A1-A2-A3. Is there a way to format a layout like this in FM7? Thanks.

The problem is the following: I'm parsing a txt file which contains color information in the format of a number from 0 to 16777215. I know that FM7 can deal with that numbers. For instance, instead of TextColor("Hi";RGB(255;0;0)) you can also use TextColor("Hi";16711680). I also know how the calculation is done: Red * 65536 + Green * 256 + Blue. The bad thing for me is that the txt files I'm parsing have interchanged RED and the BLUE values, which means that e.g. Red=255 and Blue=16711680. Is there any chance to reconvert from number values to RGB values?? If so, I could easily interchange R and B in a calculation afterwards.

Hello everyone, I have a field that I want the user to view but not edit. The field has a scroll bar. I also have a Data Entry Screen where I modify and edit the contents of that field. How can I allowed the user to use the scroll bar without changing the contents of that field. When I uncheck the box for Allow field to be entered in the Field Behavior, it does not allow the user to scroll down when there is more text to be viewed. Thanks for any help

I want to run a script whenever a user commits a record in a specific table. Now, I can place a "Save" button on the data entry layout for that table and have that button execute a script that commits the record and performs other steps but the user can commit the record without ever clicking on my button. Is it possible to trap events, like when a user adds a new record or commits the new record? James McIlwrath Mississauga, ON, Canada

Does anyone know if it's possible to create a popup calendar in FMDev 6 or 7 like in Javascript?

Maybe I'm not the only one to note this.... but on my mac (10.3.3) FMP 7 trial doesn't seem to be expiring. The expiration date just seems to move back every day so there are always 30 days left. I already own FMP Dev, but you would think FMI would want others to actually pay for a copy rather than just using the demo forever. (I also have a demo for winXP that actually does expire)

Over the years, we

Greetings, I was just wondering if there is a "Find Last Record" script in Filemaker 7? I need to be able to copy information from the last record in one table to a new record in another table? Thank you so much! [color:"red"] A.

Restore. I was wondering if anyone has a script that restores from an existing backup where the back up is created by script in a different directory and different file name such as filenamebac.fp I've been finding that the backup works okay one or two times and then tells me the file is locked.... I assumed it was open/ so closing the file before starting the backup process worked okay but creating a restore script has proven elusive since it doesn't seem to find the file directory or if it does the file is locked or in use... even though the script is closing the file. I have always just used windows explorer in the past and done this manually on the rare occati…

Filemaker Pro version 7 file with RGB codes, color display and hex code color.zip

I found that FM7 scripts run by ActiveX did not work in VB6 applications using Sax Basic (VBA clone, www.sax.net). The same scripts work fine in FM6. I never had a problem with ActiveX before. In order to have something FileMaker tech support could reproduce, I put together simple Ver 6 and Ver 7 examples using FM and Excel. These are attached; you click the button in Excel to create a new record in FM. The FM6 version works reliably; the FM7 version eventually crashes at random times. It might crash right away, or after a number of records are created. If you can't get FM7 to run again, check Processes in Windows Task Manager. The ActiveX capabilities of F…

Hi, I am new to this forum, and am not sure where to post this sort of question, so please excuse me if it's in the wrong place. I have been asked to assess whether or not it would be possible to build a solution for my company using Filemaker 7. Having looked at the application, I am very excited about what we will be able to do with it and the ease with which I will be able to develop our solution in it. However, I do have one real doubt about the application and that concerns its scalability. We will need to run at least 400 users on the application and it is conceivable that anything up to 300 users would want to access the application at anyone time. …

I learned about the text color function here a couple of days ago and it makes my head swim with new ideas. This took me to the RGB function where colors are represented by numbers. Is there some kind of a color chart available that corrolates the RGB number with the color? What would be really cool is to click on a color and have the number present itself. What would be cooler is to click on a color wheel and have the color selected trigger a script that put the appropriate values into a field box that could drive the Text Color Function. Can anybody direct me to something like this? Is this an example of a custom function available through Dev…

1.i want to know what do dlls of fmpro 7 directory do, one by one. 2.i want to have basic technical resources about fmpro 7 same as programming languge, background dbms, information capacity that support, speed of accessibility to data in large amount of 3.3.information, basic informatin about db structure of fmpro 7, how doas it support: xml, web publishing, remote access, odbc connetions, linux and mac platform, and so on. 4.i want some beautiful skin for fmpro 7 same as what is in manuals and tutorial of that. 5.can i add developer utilities capability to fmpro 7. can i do it using internet. i'm in iran and can't access to FileMaker CDs. can i order demo CDs from…

Greetings, I am trying to create a database that will automatically create a document number when the user clicks "Create New" button. To do this, I have created another table, which I will used as a counter of sorts. It will keep track of the last number used, and when the new document is created, it will up the number by one in both places. I am not sure how to access the counter from the scriptng page, though. There are more than one type of document, so it will have to be able to find the exact field I am pointing it to, and change it after the creation process is complete. If anyone can help me with this, I would be very grateful! Thank you, A.

I'm converting a multiple file application from FM5 to FM7. When leaving one file for another via script the screen is white for almot a full second before the new window is presented. I had a similar problem FM5 years ago and found that hiding the file I left AFTER entering the new file's layout solved the problem but such is not the case with FM7. After some experimentation I isolated the step that causes the white out: "move/resize current window to size XXX" for the entering file. I have tried re-ordering the script steps, (hiding current file first or second, doing the move or resize earlier or later or via the leaving file's script...) but I cannot escape the whi…

1.i want to know what do dlls of fmpro 7 directory do, one by one. 2.i want to have basic technical resources about fmpro 7 same as programming languge, background dbms, information capacity that support, speed of accessibility to data in large amount of 3.3.information, basic informatin about db structure of fmpro 7, how doas it support: xml, web publishing, remote access, odbc connetions, linux and mac platform, and so on. 4.i want some beautiful skin for fmpro 7 same as what is in manuals and tutorial of that. 5.can i add developer utilities capability to fmpro 7. can i do it using internet. i'm in iran and can't access to FileMaker CDs. can i order demo CDs from…

1.i want to have basic technical resources about fmpro 7 same as programming languge, background dbms, information capacity that support, speed of accessibility to data in large amount of information, basic informatin about db structure of fmpro 7, how doas it support: xml, web publishing, remote access, odbc connetions, linux and mac platform, and so on. 2.i want some beautiful skin for fmpro 7 same as what is in manuals and tutorial of that. 3.can i add developer utilities capability to fmpro 7. can i do it using internet. i'm in iran and can't access to FileMaker CDs. can i order demo CDs from iran? 4.is there any plug-ins that create exe application from my fp7 …

i want to have basic technical resources about fmpro 7 same as programming languge, background dbms, information capacity that support, speed of accessibility to data in large amount of information, basic informatin about db structure of fmpro 7, how doas it support: xml, web publishing, remote access, odbc connetions, linux and mac platform, and so on. i want some beautiful skin for fmpro 7 same as what is in manuals and tutorial of that. can i add developer utilities capability to fmpro 7. can i do it using internet. i'm in iran and can't access to FileMaker CDs. can i order demo CDs from iran? is there any plug-ins that create exe application from my fp7 files. …

I've gone back to modify some folder tab images in Photoshop for my website. These images were created months before I installed FileMaker 7. Like an idiot, I rasterized all the text, so now I have to re-create it to make the changes. The font was 10pt Verdana, but I'm unable to match the anti-aliasing of the existing text. Each setting in the new text (sharp, crisp, strong, smooth) is much more dramatic than the anti-aliasing of the existing text. The anti-aliasing steps actually resemble those of FileMaker's, in that each step just gets darker and more illegible. Though I highly doubt it, these different levels of anti-aliasing may be exactly how they were before. …

Hi, I am working on a DB Solution that is PROJECT BASED, You create PROJECTS ( JOB ORDERS) in the MAIN JOB FILE and then you add various other info through different tabbed layouts which appear under the JOB INFO at the top half of the layout, for example You add a job, and then related to that job you can add many Quotes, Purchase Orders, Invoices etc. Each JOB ( Project ) can have more than one INVOICE, QUOTE or PURCHASE ORDER, I have Set Up the Relationships so far using the "SEPARATION METHOD" and the Table structure as such.. JOB ORDER ---> INVOICE MAIN ---> INVOICE ITEMS JOB ORDER ---> QUOTE MAIN--->QUOTE ITEMS JOB ORDER ---> PURCH…

I found one for FM6 but it does not work very well in FM7... What I need to do: I would like to make a broker call log -- meaning when I am on a file (a brokers company) I want to hit add a call...this should add a space on a portal that I can type in...it should auto enter the date too...it uses the child / parent relationship... Does FM7 have anything like this...or does anyone for that matter...:

Hello from Sweden, I have followed the discussions in this Forum as in the Swedish and a lot of people say that they wish they havent upgrade. Its a lot of problem with the new 7. Many people dont agree they have to upgrade the platform to at least W2000. How is it? Is it woth all the money to upgrade or is it so many people who dont like it so Filemaker have to make changes before they accept? Should I keep my FM5 solutions and buy used licenses for the future or should I upgrade? I have a big solution consisting of 50 applications for the travel agency as backoffice program and its a lot of work reprogramming everything. Hope you can help me. Best reg…

I have read about the advantages of separating data and interface files. Can someone point me to an example solution using this technique?

In FM7 when formatting a field for a value list , when formatted as popup list the response is extremely extremely slow but when formatted as a pop up menu the reponse is very fast. Why the slowdown... anything to do with the anti-aliasing.. Anyone else experiance this problem?? Stu FileMaker Version: 7 Platform: Windows XP

I know that repeating fields and their shortcomings have been the subject of many posts, BUT I dare to ask - Is there a way of using a variable to nominate the nth element of a repeating field so a loop structure can progressively fill the repeats - ie - get a count of the active repeats, use this to set an 'array' variable which can then address the individual repeats as array is incremented in the loop?? ie instead of RepeatField[1], RepeatField[2] being hardcoded, use RepeatField[Array]???

I have a layout which extends past a page break - I have colour fill in the body and a header with graphics and text - when in preview mode, the second page has no header, and the body fill extends all the way up the page, but the field which crosses the page break starts the correct distance down as though the header is there - messed around for some time trying to find the problem before taking out the fill colour - presto the header re-appeared on page 2. Tried the same layout in FM6 and it works fine - is this a bug in FM7??

Hi all: I just recently purchased FileMaker and is awesome! Now, being a newbie, I haven't found a way to do the following: I created a db with text fields. In one of them, called "software" I'm using a value list. I chose the field format checkbox set and "include 'other...' item to allow entry of other values". This works great, but no I can't find a way to make this to print the extra information I add in "other". Thank you for your help and cudos to this forum. Amazing!!

I would like to create a unique serialnumber on each of my clients. I would like to use the three first letters of the companys name and then have three numbers that will increase with one number for each client whos have the same first three letters. Example: client.1 McDonalds, NewYork = MCD001 client.2 McDonalds, Miami = MCD002 client.3 Seveneleven, Ohio = SEV001 client.4 BurgerKing, Dallas = BUR001 I have tried to make this but i used the auto-enter serialnumber funktion, and this will not work as i want it to. Then, for example, client.4 will have the S/N BUR004, and that not what i want. When the new client is created it must look on what …

I am using Business Tracker. For some reason or another it will not allow me to input information on my Contact Details Location section.... WHY!? I cannot seem to get this to work. It seems like a wonderful solution, but editing it is a pain in the rear! Please help me soon!

I have a portal on a layout that uses a pulldown menu to populate the first field of the record. Once one record is in, though, it won't allow me to use the pull down menu again...I have specified that the relationship can be used to create records, so it isn't that. Is this just a wierd FM7 quirk or am I doing something wrong?

Whats the best way of storing tables in FMP 7.0? I know you can now create one file which contains all the database tables for the solution as opposed to creating a separate file for each table. So which is the best for a case where I have: one table with 200+K records (yearly increase of about 300-700 records) three tables with 20K records ( yearly increase of about 20k-30k records each) one tables with 8k records ( yearly increase of about 8-10k records) There are other tables with less data and a lower yearly increase, but all the same they are currently in one file. I know they said that FMP7 can hold terabytes of information, but how does it perform? I'…

I have run into a problem over the last couple of days. I am building a solution and I needed to delete a field I found obsolete. I opened up Define Database. select the field and hit delete... then the defined database dialog just konks out. So I went back to Define database and see the field still there but now when I try to delete it, FMP 7 says that the data definitions are being edited by someone else (ie me!) Now here is the weird part... After this happens, my scripts will not execute. I start a script and it just hangs on the first step -- I have to cancel the script to exit it. (FMP doesnt crash and the DB appears OK in all other ways) Al…

I just got the new Tasks 2.0 solution that is being marketed by FileMaker. Anyone know how to add new layouts and have them used via the databases in the solution? They did not include a layout to print a complete task with descriptive body and comments. Any advice would be appreciated. Thanks, Rob

Was I dreaming or what? I thought I read somewhere that there was a built-in 'chatroom' feature in FileMaker 7... Abbe Lougee Oregon State University Corvallis OR FileMaker Version: 7 Platform: Mac OS X Jaguar

I want to be three copies of FileMaker Pro 7 for a small business. The software costs a lot more in Europe than the U.S. I need to know that if I purchase in the U.S. can I legitimately install and register the software in Ireland. If I buy online from the U.K. each copy will cost me $435.44. If I order from the Irish Apple Store it costs $498.19 per copy. I can buy online in the U.S. for as little as $220.00 per copy. If anybody can offer any advice I would appreciate it.

Simple question...How large can FM (Megs) before it gets unstable... ie: Access can not get to large b/c it get unstable...How about FM6 or FM7? Thanks

Well, Using the trial version works but it seems slower than version 6. I like all the features they have added but they missed the biggest feature of all, Panther style graphics and buttons, They still have the 80's style buttons and graphics for scroll lists, buttons etc. its hard to make the databases look modern and reflect the current GUI's, They should of incorporated GUI design elements from either MAC Panther and or Windows XP. I was hoping that they would also have some sort of TABBED BUTTON Design elements but they didn't! Have a look at check boxes and scroll boxes, they are still 80's ugly!!! Also, In this new version I was hoping that you…

I recently downloaded the FMP 7 demo and was amazed that the Tutorial was so basic. Is there someplace else you can get a FMP 7 Tutorial with some meat to it? I don't want something expert, but something more than this! Thanks for your help

I am needing help creating the exact database I want to track customers and orders for a small business' phone orders. My specific questions: - Can I add information to one record without making the change across the entire database? (as in adding orders to returning customers' record - but not changing anything in the other records?) - Is there a way to add a "notes" field to store any relevant information for customers? Thanks!

Is it possible to move a field (or better, a group of fields) from one table to another in the same file without just deleting them and recreating them in the other table? (I thought I had posted this last night, but it's never showed up, so I must have done something wrong. Sorry if it is a dup. post; if so, tell me where it went!) Decker

Hey, How come I can scroll through my list of records with my scroll wheel? Anyone else have this problem?

Hi! I have a database of patient surveys that I have upgraded from FM 6 to FM 7, and am having trouble producing accurate reports using subsummaries. Normally, calculations work fine with subsummaries--if, for example, C = A + B, then I could write the following formula: C = GetSummary(A, break field) + GetSummary(B, break field) HOWEVER, if a calculation contains a formula, then FM 7 will show an average of ALL surveys (i.e. not doing a subsummary) For example, the following formula would work in FM 6, but NOT FM 7 (as far as I can tell) C = Average(GetSummary(A, break field), GetSummary(B, breakfield). Similar results occur with other f…

Hi I have three tables in my database. I would like to duplicate a table 2 more times and rename it . Is that possible?

I have just a little question to ask: Is it perhaps possible that Filemaker Inc didnt insert some new functions in the new FMP7 simply just because of the fact that they will interfear with some of the plug-in-companies excisting products? How much influence does theese companies have on Filemaker Inc? I would never go and by an expensive plug-in just for one function, then i would consider of changing the software to, for example, Servoy. But i am not a developer, just a simple user for a smallsize company (15 people). I am pretty new to Filemaker, and i have not yet desided if i should use Servoy instead of FMP. I really hope that this is not a fact…

Is it possible to create a field that is only visible or editable when another field has a certain value? I.E. If a radio box field has the 1st item selected the field beneath would allow another radio box field to be editable otherwise it would be unavailable. Thanks, Rob

I am redesigning a database from FMP6 which will handle > 10,000 images. Currently, I am storing a reference to the images as a text string, which I then use AppleScript to manipulate (eg, 'Tell application "Finder" to select file <<FMP field>>'). I am thinking of using file references in FMP7, since they seem designed to solve my problem, but I am afraid of finding out some bad consequences of this decision later and having to undo a lot of work. Some questions: 1) What are the rules for displaying a file reference? I tried making a reference to a large TIFF file and it appeared that FMP7 had to parse the entire tiff every time it showed the record in…

my client is a slow typer and needs to make selections from longs lists in several pop-up lists. she wants the list to jump to 'Connor' so she presses 'c' then 'o', but the time she takes to do it means Filemaker jumps from Callaway (the first name that begins with C) to O'Brian (the first name begging with O). Is there any way to set the program to 'wait' longer?

Hi all, I was trying to find some way to read a directory and get all filename and file path information into text fields. However, it seems like Fm7 limits that functionality to only images, movies or text files. Does anyone know a way around it to make fm7 read file name and path information for all different file types? Thx, H.P.

I just looked on the homepage fot FM7...that do not even have 7 listed for any updates...Can anyone tell me what is the newest version...v1?

how can i change the main fmpro 7 window title - "FileMaker Pro"?

I would like to have two fields which I have dubbed "Account" and "Date" and I would like to have the first identify the account responsible for the most recent change to the record and the second to identify the date (and possibly time) that the change was made. I'll readily admit to be a "newbie" to FileMaker and will readily accept "you dummy, its right there in the help" kind of responses. But I've not been successful, at least so far, at incorporating the desired behavior. Suggestions and such leading to a solution will be most appreated!

I have been using FM6..In my data base I have a Parent/child relationship Portal... It works well...When I hit Add it brings a new line (Vertical) in so I can type a note...it stores it on a nother data base (child)...but I can see it on the Parent.... I just purchased FM7...the parent /child relationship does not work very well..is there a new feature that I can use do something like what I had that works better???

I am looking for a real elegent way (in ver 7) to assign multiple tasks in a third table to a second table (the join file) so the people in the first table could be assign the same task. As each ask is added it will dissapear from the third table portal. The sample I made breaks when a person is selected and does not have any tasks assign to them (phil in the sample) , the selection portal relation ship breaks and goes blank. I'm sure there is a cool rearangement I could do but am not seeing it. The funny thing is that is this was some one elses post the answer would be clear. Note this is different than cobolt sky's example of a list manager in that items need to …

I have a database that is essentially an address rolodex of all of the Vendors & Venues I use (event planning company). I have created a somewhat strange join table in the same file that will hopefully allow me to add a list of preferred caterers for each venue. (The caterer records come from the same Vendors & Venues table, so I only have 2 tables but three table occurrences). Looks like: Table One: Vendors and Venues, multiple fields Table Two: Caterer Join, fields Vendor ID and Caterer ID Relationships: V&V to Caterer Join; Caterer Join to 2nd occurrence of V&V that I've named Caterers (Unique ID = Vendor ID; Caterer ID = Unique ID). …

I was excited to begin taking advantage of all the new features in FM7 so as soon as I recieved my copy I began to experiment. One of the first things I tried was to put fields inside a footer part when choosing view as a list and that seemed to work ok. Next I placed a portal with a scroll bar in the footer part and the portal data displayed fine until you tried to scroll the data to view the remaining related records. As you scrolled the screen either repeated the last record or was filled in with black. I've also noticed that objects placed in a layout that were drawn with the layout tools displayed intermittently when switching between layouts. Sometimes they app…

I'm trying to do a simple calc multiplying 2 fields. Qty X price Every time i set the price to a decimal say 2.5 it round the total up. 10 x 2 = 20 But 10 x 2.5 = 250 Last version i used was 5.5 and this worked fine... what is going on?

Hi all, Just wondering if it's possible to display sub-summary info in List view - browse mode? So far, I'm able to display sub-summary data under Preview mode only. This is how I want it to appear in preview mode: Category Item Application 1. Ms. Office 2. Ms. Word Music 1. Cd 1 2. CD 2 Thx. H.P.

Hi everybody

can i make my fp7 files independent of FileMaker Pro 7 environment? is there any plugin to do this?

I am use to using an underscore '_' for all fields that are for programming but with FMP7 (or osX) all underscores are sorted to the top of the list instead of the bottom. This is a drag because when the client is exporting or adding a field to the layout they now see all my junk first. Has anyone found another way around this other then custom sort.

I'm currently planning a solution that will be used to create very complex reports, the reports are highly variable, and use a high number of tables and joins. The primary concern is 1)Flexibility, 2)Ease of Use (for the user, of course). What I would like to create is a "wizard" that will walk the user though a series of questions, offer checkboxes and text fields, switching from layout to layout for each questions, then "remembering" the answer, then finally using a FMP Script (no applescript, sorry) to run the queries, build the report and present it in one big-*ss layout that the graphics person can copy and paste into Quark Xpress). I'm not sure how to go a…

I am new to FileMaker and am very impressed but am having a bit of trouble. The online application form for my writing workshop generates a tab-delimited text file, and I import that into an FM database. Then I manually add information in certain fields -- for example, whether the person has been accepted or put on the waiting list. And I correct mispellings and typos entered on the Web form by the applicant. All that works fine. The problem comes when a new application has been received and I want to import it into the data base without affecting the existing data. When I choose the option "Add new records," the manually entered and corrected fields on the old entries ar…

I have a table that has a field call Constant which defined as a calculation with a calculation of "1". I have another field in the table called RecordID which is defined as a calculation with a calculation of "Get(RecordID)". When I import records into this table, unless the "Perform auto-enter options while importing" box is checked, these calculations do not occur so the fields are empty. This was not the case in FM6 and below. Any thoughts?

Is there anyway to have a graphic element on a layout which acts as a field, in that when a user clicks on a certain area of the graphic, it returns a different value. For example: A line on which the user indicates a point, and that returns a value ie. a visual analogue scale or A picture of the bowel where the user can mark the position where a tumour occured and that would return a value. Any thoughts much appreciated.

I downloaded 7.0 demo and played with it until it timed out. I then purchased 7.0, put the disc in, doubled clicked the FMP icon, entered my name, company and the codes that came with it. But when I try to open it or any 7.0 file. I get the message that 7.0 has timed out, just like it did with the demo. I trashed the demo before installing the new one. What gives? Thanks for your help, Bill FileMaker Version: 7 Platform: Mac OS X Jaguar

HELP! I am new to FM and I am having some MAJOR issues with the business tracker solution. I added a field and although I can see it I cannot put data into it (despite the fact that I checked the box in properties!). If anyone knows what I am doing wrong.. please tell me! Thanks, [color:"purple"]

I have to build a solution that can handle two type of contacts. Between the two maybe 60% of the fields are common. What do you think is the best way to proceed with the db structure. 2 completely separate table (contactA and contactB) 2 separate and 1 common (contactA, contactB and common) break all commons into separate tables (phone table, address table, email table) FileMaker Version: 7 Platform: Mac OS X Panther

First time posting but long time user. I am looking to do multiple substitutions in fmp 7. I was told that it could be done but I have been unable to get it to run. My script is: Go to Record/Request/page[First] loop Set Field[completed_template; Substitute(template; "the_item_name"; item_name)] Set Field[completed_template; Substitute(template; "the_item_id"; item_id)] Set Field[completed_template; Substitute(template; "the_item_case"; item_case)] Go to Record/Request/Page[Next; Exit after last] end loop item_name, item_id, item_case, completed_template are all text fields template is text global The script runs but only substit…

Is it possible while using a runtime solution created with Developer 7, to have access to the layout mode? And/Or just a few selected files in the R.T. to have access to the layout mode? I mainly want this so that our clients can move/change fields around the page for printing purposes. I never figured out a way to do this with V6, and after researching it, determined that it wasn't possible. My hopes concerning this may be rekindled with this new version. Of course, the trial download of V7 couldn't address this, and any research I've done with the FM website has turned up unanswered. I just want to see if it can or can't before investing the money into…

Heavenes - I have converted all the FM6 files to FM7 files. They are fairly simple structures right now so I have not found any problems yet. The question I have is there a way in FM7 to combine all the files different files into one file that holds them all? ---or--- Is there a third party utility that will do this? Any assistance will be appreciated. Thanks In Advance.

Help Me !! I use FM5.5 to publish by web on my network a base of given on 8 stations. I have tested FM7, because it has more possibility on Web interface but unfortunately it is limited has 5 stations whereas FM5.5 authorizes up to 10 stations, why this regression in the new version of filemaker?: I do not hope to use FMSERVER for only 8 stations , because I must also change my system , Windows 2000 pro to Windows 2000 server for extend the Web publication from 5 to 10 stations. how to make to extend the user number without using FMSERVER. Thank you.

Computer: eMac OS: Panther 10.3 IP: Static I downloaded Business Tracker from Filemaker website, and enabled Instant Web Publishing. But when I go to my other PC and launched it from IE, all the buttons and functions are screwed up, It's unusable. At the time I thought it was a Windows issue, but when I went home and tried to use it at home with my G4, same problems. Following are some of the problems: - Home page is the catalog page instead of the main home page. - "Return to Products" button disappears. - Can't log out, log out creates red "x"s and sometimes crashes network. - All buttons on the top that should read "Home, Companies, Contac…

Hello everyone. Im currently looking to redevelop a software package and I need your knowledge. Right now the customer im working with has 2 databases softwares for his business. 1) a custom program that stores data etc.. (This database just stores customer information and rates) 2) a advanced webpage that uses perl DBM databases (3+ gig) (this database holds all the different zipcodes in the USA, Has the distances from one zipcode to another, timezone info etc...(basically advanced like a the ups site). My customer wants to combine the 2 into one big program. Heres my question.... Should I A)create everything in filemaker and wait till serv…

Hi, im looking for a way to store the X,Y,Z Dimesions of serveral objects on one layout by dynamically creating fields (or rows of fields) as needed. E.g. i would have a row that has 3 input fields for myObject1 X1[...] Y1[...] Z1[...] All 3 fields are individual values. When there would be a 2nd, 3rd, 4th etc. Object for this sheet - id like to have a button [bUTTON] that will create a further row for myObject2 X2[...] Y2[...] Z2[...] beneath the 1st row and so on. Is there a way to do it ? I only know "repeating fields" for multiple values but that doesnt work for me. Thanks a lot for hints / tips !! tdmf

Hi All, I have an event database that contains school and student information. I'm trying to make a form where the data entry person inputs the school number and the school information will be populated via a relationship to the school database via the school number. The school database has links to other tables, in this case the region and management databases. The problem I'm running into is that after entering the school number on the events form only the fields that are from the school database are filled in. Fields from the region and management database remain empty until I leave the record and then move back to it. There are some cases where I have to do …