FileMaker Pro v7 – v11

Hi All- I am brand new to FileMaker, although I have a broad, nonDB programming background. I am creating a test DB modelling the following - A list of Presentations, each with One Author, a Person, and Several Documents associated with the presentation. I have a good start on this, but am confused about the Docs. In the enclosed example file, I have a relation to get the Person data, data entry layouts for the 3 source tables, and a pretty display layout for a final product to an audience. I am not sure how to make the List of Documents show up in the final display, nor how to make the list of docs known to the Presentation. I am trying to list the docKeys in t…

A little feedback to share. I downloaded the FP7 Trial Version and ran into trouble converting my 6 related files, i.e. maintaining the relationships, dealing with the security system, etc. Upon further inquiry I found that the "migration" to FP7 will take some time to facilitate, as per the pdf on "planning your migration". My boss is already up in arms with the cost of upgrading each of our networked licenses whenever Filemaker comes up with a new version, and now he is outraged that the upgrade isn't streamlined enough for easy conversion. I have been doing my best to keep his costs down by managing to network with the compatible versions 5, 5.5, and 6 and have been an…

If you

Using 10.2.8 and FM 7 upgrade to 5 and updating a 24 file solution. With FM5 one layout = one window and hiding made window management easy. With FM7 there can be multiple windows. Instead of using hours to find the best way to keep windows from multiplying like rabbits in springtime when going from one layout to the next, I decided to come to the forum. So far I discovered that I should make all my windows new at the opeing of a file, format to a "no access" layout, and hide them. When navigating the layouts and using the solution, I hide the current window and select the desired (previously hidden) window and format it for the appropriate size and layout. (I…

Hey kids, I've been playing around with a two-file system: one multi-table data file, and one interface file. Putting all scripts, layouts and value lists in the interface file is very easy; the final piece is the calc fields. While this is also easy enough, a problem arises when you want to show a calc field in a list or portal view. For example, when viewing a single invoice by way of the interface file, the total can be shown with a Sum ( lineItem::amount ) calc field. However, if you're looking at a list or portal view of invoices, how do you show the total for each invoice? The answer is probably "The data file will still need some calcs". I was j…

Hi all, I am studying filemaker business tracker. Nice program !! I found something strange that I can not explain. On the layout settings you have a portal for modules. Although the vertical scroll bar is marked on, it does not appear. Can someone explain this ? FileMaker Version: 7 Platform: Windows XP

http://www.filemaker.com/upgrade/techbriefs.html I am downloading it now...I've been looking forward to reading this. Dana FileMaker Version: Dev 7 Platform: Mac OS X Panther

Hi All, This is my second (frtustrating) day with FM 7. I've been using FileMaker since the original version and I gotta say this is the hardest upgrade yet. Anyway, I posted a question about problems with Time Formats on MacIntouch and someone was kind enough to tip me off to this forum. Thanks! I'm trying to learn 7 by converting my "DisCollection" database of CDs and vinyl. I have a relationship of Tracks to Discs. The Disc layout has a portal with the Track "line items". I want the track numbers to be inserted automatically as I add each one. In the past I've used the Get (PortalRowNumber) function and had no problems. In version 7, however, the value r…

What happened to type-ahead selection of items in popup menus? I often used large popup menus for selecting values for fields in Filemaker 3 thru 6, where typing the first few letters of an item would scroll to that position in the list (given that they were displayed sorted on an indexed value). It doesn't seem to be working in FM7. FileMaker Version: 7 Platform: Mac OS X Panther

Does anyone know a way to capture the position of the cursor(insertion point) and/or the mouse pointer? It seems like we should be able to do this as in Layout mode, if you have the Object Size dialog showing, anytime you click gives you the coordinates of the mouse. This would be useful for positioning windows based on a mouse click. FileMaker Version: Dev 7 Platform: Windows 2000

I need to know where to download filemaker 7 pro for win 98 & win xp verison Thanks in advance

Hi everyone Actually I am testing File Maker Pro 7 and his capability to put database in the Web. The preliminary results are really promising. However I still have a problem

Maybe someone can help with an up grade problem that I have with going from FM6 to FM7? In FM 6 a text field would recognize the text within the field and not slice the word at the end of the line (just as the text is done in this field). Whereas in FM 7 the same text in the same field is now sliced up at the end of the field (right margin) and the words are not respected as a word but not are just characters. I'm sure there must be a simple solution this this upgrade problem. Any help would be greatly appreciated. FileMaker Version: 7 Platform: Windows XP

I have a solution, written in Developer 7, that uses the new windowing scripts. On a Mac, the windowing is perfect, but on a PC, when a script places me in a new window, the window in the background looses it's maximization, and the Windows border shows. This makes the solution look awful. Has anyone seen this, and how can I work around this issue. I have tried the "Freeze Window" script step, but to no avail. Any thoughts would be warmly received. FileMaker Version: Dev 7 Platform: Mac OS X Panther

I have noticed a strange problem in FM7...one of many unfortunately. When I try to move any graphic (image, field, text) I can move it only a short distance then I get a black circle with a slash through it and the move doesn't work. I also have seen graphic elements change to diffeent layers after such a move...requiring the elements to have to be brought back to the foreground to be seen. Each time I drag an element, the screen flashes and frequently gray boxes appear. These problems are noted in addition to the fuzzy text, fuzzy graphics, slow layout response, etc, etc. I don't know much about programming, but it seems to me that the entire grpahics "engine" for FM7 ne…

I've encountered a screen redraw problem when scrolling a long list of records. There are actually two. In the first, the screen does not always redraw correctly with the result that in list view one record appears overlapping a 2d appearance of the same record. This is somewhat sporadic, but it happens enough to be noticeable. The more serious problem is that when scrolling a long list of records (1,069 in this case), the further down one scrolls a blank white space begins to appear at the top of the window which gets progressively wider until by the time I scroll to record 1,050 the entire screen is white with no records at all showing. I've been able to repro…

After upgrading to version 7, I noticed that Filemaker would beep for questionable spelling mistakes on any words that had a comma. Also when It would catch a word that was indeed misspelled and then replaced

I'm trying to get the toolbars to show up on my layout. I started out at VIEW>>>TOOLBARS and all options are checked. Standard, Text Formating, Arrange & Tools options are all selected. But they don't show up on the layout?!? Can anybody help me here? I am running Developer 7 on a MacIntosh G4 OSX Panther. Thanks, Jarvis FileMaker Version: Dev 7 Platform: Mac OS X Panther

I need to automate a search. I have a Donations layout with donation date, donorName, donorID, amount given, etc... I need a search that will show all records based on amount given every year for last 3 years from user inputted amount. So, the query would automatically check current date and then look back 3 years, and display everyone who has given say between $100 and $500 every year since 3 years ago. So all the user would input would be the $ parameters of the search, like amount > $500 and < $1000. I hope this makes since. I would greatly appreciate any help in this task. FileMaker Version: 7 Platform: Windows XP

I have a complicated database to track my photos, and I have been putting off upgrading it until I could get my hands on FMP7. Having just spent the last week working on a new version of the database, I am seriously considering putting my new copy of FMP7 on the shelf and continuing using FMP6. I love the new features of FMP7--although the scripting environment is so mouse heavy that I am getting stress pains in my right hand. And my solution seems to be coming together quickly. However, I am experiencing "bit rot" in my files and it has me so worried that I think I shouldn't continue using FMP7. The first relations I built worked just as advertised. Then I star…

Hello All: I was wondering if one of you FM genius' out there could answer a question for me. I travel frequently and I read a lot of travel magazines. I was wondering if there is a solution or template out there that would let me keep track of hotels, restaurants, bars whatever that I read about or visit. For instance, let's say I read an article on the best bars in Chicago. I would like to be able to enter them into FM for example and then if I am on my way to visit Chicago I can go into FM and sort by: Bars>Chicago or something like that. Is there a solution out there that will allow me to do this? I would appreciate any help you could provi…

Any insight on the fastest way to copy (some of) the fields from one table to another? I have the need to create a table with the same data as another table's found set, within the same file. You might think that the "import" function would work, but it doesn't seem to support the idea of importing from the same file. Of course, I can just write loops in a script, but ugh, that's slow. FileMaker Version: Dev 7 Platform: Mac OS X Jaguar

Is is possible? I saw an online ad in another forum for some software that would take filemaker TO access, and some that would take access to filemaker for windows, but how about the mac version, is there any way to import structures and relationships from an existing access database into version 7 for mac? or would i need to analyse and reconstruct every relationship manually, if there is even one to one configuration compatibility? FileMaker Version: 7 Platform: Mac OS X Jaguar

Something is wrong with the merge field operation in my application. I don't have a clue as to why they don't work. I have relationships set up correctly.... other basic fields using these relationships work...it is only the merge field operation that does not work. This is a new occurance. existing merge fields that used to work ... now do not. in browse they return a line that looks like the merge field in the format mode. except the time is added in the line. I have tried to work and rework this to determine what if anything has changed. I copy an existing merge field that works correctly and paste it... the paste does not work. I could use s…

I may be brain-dead, and I hope I am, but there seems to be a major, major hole in FM7 security. I have database.fp7, with the non-full-access account user_1, who has access only to several fields in table_1, as well as execute-only access to several scripts. If I'm the end-user who normally logs in to database.fp7 as user_1, and if I create a new, empty database and add a file reference to database.fp7, I can do the following: 1) add an occurrence of table_1 in the Relationships window of my new database. If the password for user_1 is stored, the occurrence will show up automatically. If not, I can enter it in. And I would know the password because that's …

I am at a loss with this one! Please help! I have a solution that has File1 and File2. File1 has a portal in it to create records in File2 via relationship. When I run a script to insert the date into a field in the portal (thus creating a new related record in File2 with an ID number as the matching field), for some reason, my lookups in File2 don't happen. And worst of all, it is intermittent. If it doesn't lookup data the first time, I delete that record from File2 (deleting it from the portal in File1 or directly in File2) then run the same script again, and it's fine - lookups occur in several fields. The lookups are quite simple - just getting data fr…

Hello, A collegue has used FileMaker to create a system of handling client information. Contacts, status, notes, that kind of thing. We would like to use the design and programming in FM that they have already done, but do not want his data. Is it possible to separatly get the functions and programming, and not the actual customer data? I'm sorry if that is to broad a question. We are not yet FM users, but if we can make this work, we soon will be! Please ask if you need more details. Thanks much! Chester Platform: Windows XP

In my initial brief look at FM7, the one glaring thing I have noticed is that text on layouts is horrible. Text is fuzzy and appears out of focus. Trying various options to make it more acceptable, I can find no suitable option that gets the fonts to look like they did in FM6. Am I missing something, or is this design intent. If this is design intent then in my opinion this will probably make FM7 layouts useless for a significant number of people. I have several users with less than perfect eyesight and it will be hard for them to read the new text. Echo

I thought I read that FMP7 was going to provide field formats for such common uses as Phone Numbers, Social Security Numbers, etc.. I've search through my demo version and can't seem to find this. Any ideas? BTW - I love the ability to relate files more than one relationship away, the new live security, the visual realtionship chart and the conditions you can put on realtionships. But - now that I'm getting cooking - I have to wait for Server to actually use these in the settings I work. Version: v7.x Platform: Windows XP

Can somebody help me please, I'm going crazy. I have recently upgraded to V7 and find that a summary field is not giving me the correct result. I am working with two database files and the summary field (from the master file) is returning the value for one record only rather than the group of records. The summary field is placed on a layout in the related file. I did not have this problem in version 5.5 and can't fathem why it would change. Any comments would be greatly appreciated. FileMaker Version: 7 Platform: Windows XP

Forgive me if this general question has been posted before. I'm interested in knowing if FileMaker 7's web capabilities are enhanced from previous versions. Specifically, and in a nutshell: 1. Does anyone know what "server capabilities" that Advanced Server 7 will utilize making it more robust than before (utilization of Apache directly, security, etc.)? Is it truly more robust? 2. $2,499 price tag seems steep. Is Advanced Server 7 the only FM product capable of utilizing custom interfaces/HTML/etc. Does the price imply services and security that FileMaker's never produced before? I'm interested in using PHP for web interfaces and I'd like to uti…

Anything to Dial Phone in Mac Os X? It wasn't possible in FMP 6. Now, It's still impossible in FMP 7 Nobody made up something? Unbelievable !! FileMaker Version: 6 Platform: Mac OS X Panther

Hi! I'm a Navy Chaplain, and am looking for a FM solution. I teach in a school, and want to put student's info, class information (including lesson plans, powerpoint files) in a database accessible to up to 7 or 8 individuals on a network (probably not all at the same time...) the network is WindowsNT. I need the individuals to be able to input information as well... Also, I would *love* to be able to create a calendar (either in FM or in another calendar program, outlook? which can talk to FM...where I can list a class period on a certain date on this calendar, click on a class hyperlink, and open FM to allow me to access the following on a screen: class roster, c…

I have scoured the user and support forums for information on this problem and have found nothing, so it's possible that I'm the only one experiencing it. When viewing a layout - any layout - in Preview Mode in FM7, it appears to be perfectly normal when viewed at normal size, i.e., Zoom at 100%. However, if I Zoom In to the layout the image appears to be pixelated as if enlarging a 72dpi raster image. This is not the behavior on FM6 and earlier where the image scales properly. Because of the problems with associated with Postscript fonts, I've insured that the layouts I'm using incorporate only True Type typefaces. I've tried this on two different Macs, both ru…

Hello, I'm trying to create a product catalog for my tea company. The catalog is a vertical list of each product with a name, description and price. Some of the descriptions are very long, some are very short. I've had to make the Body Part in the layout very long as well as the description field, and this is resulting in a lot of dead space. Is there a way to get the height of the record to adjust based on the amount of data in it? Thanks! Andrew FileMaker Version: 7 Platform: Mac OS X Panther

I have a calculation for a user account to only show records that meet a certain condition. Problem is, it shows a record with the message <no access>. I'm looking for a way to suppress any display of a record that does not meet the criteria. I don't want to have the 50 records that meet the condition shown and 2000 records that don't meet the condition showing up as <no access>. Thanks. FileMaker Version: 7 Platform: Windows XP

Hi, My Tea Company is attempting to create our product catalog using Filemaker. Everything is going well so far, just this one hang up... What we are making is basically a price list consisting of 5 or 6 different tables, each table for a different type of tea (green, white, black, etc). So what we would like is a graphic saying "Green Tea" and then a list of all the green tea records, then a graphic saying "black tea" and all the black tea records and so on. By the way, there is a "Tea Type" text field in each record that says whether it is green, black, white or whatever. So I have no problem sorting the list by the tea type and then printing, my problem is …

Hi, I switched to FM7 and now I am trying to build up a database of experiments (each experiment has results in a spreadsheet format). I found the table feature in FM7 very nice and I would like to create for each experiment a table (all having the same fields) in one file. Is there a way to copy a table including the fields(!), so that I do not have to define the fields for each table (experment) again and again? Thanks for any help! FileMaker Version: Dev 7 Platform: Mac OS X Panther

I am using Filemaker 7. I have a client table that has my client information. I have another table that has many items related to that client. I have a third table that maps a unique client ID with the many unique Item IDs related to that client. What I want to be able to do is while I am inputting the client information, save the unique client ID and then while I am inputting the related items in the other table have that unique item and the client ID item put in my mapping table automatically. How can this be done? Rob Blau FileMaker Version: 7 Platform: Mac OS X Jaguar

As I wait for FM to get the fonts and graphic right... Is there any way to make the status area wider in FM7 (Windows)? I thought I saw a screen shot on the FM site showing a wide area. Am I missing something obvious? FileMaker Version: 7 Platform: Windows XP

In the FileMaker Business Tracker, when you set Preferences::gSelectedReport to a report number, the Reports::Preview container field updates with a preview of the selected report. To see this, click on reports, then click on each of the reports at the left of the screen. I'm lost. How does this work?? FileMaker Version: Dev 7 Platform: Mac OS X Panther

I'm currently exploring FM7 and must say that I'm *VERY* impressed. I definitely plan on migrating my current project to 7 in the near future. What I'm wondering now is if FM7 will help me with a piece of my current project. I need to create a rather simple schedule database. I don't need group capabilities, nor do I need the ability for one user to schedule another user's appointments. I need a basic time-grid in week view showing that user's appointments. Am I still stuck writing hundreds of relationships to populate the time-grid (time-grid in one file or table, appointments in another), or does FM7 introduce some new tools/tricks that might make this process…

I'm setting up a FM7 solution to replace an SQL db. Customer street addresses have been entered as: "145 River Road" I'd like to modify this imported data to split it into two fields" Street Num and Street Name eg "145" and "River Road" Naturally there will be a wide variety of prefixes in front of the street name, including street numbers, apartment letters, perhaps no numbers. Can anyone suggest an automated solution for cleaning this up ? One idea is to convert the last two words in the field to "Street Name" and assume remaining characters refer to Street Num. This will provide incorrect data where street has double barrelled name eg "69 Rose …

The new relationship and Table setup is very simular to our old foe. See Snap shot. This is not intended to drag out the Access vs FM arguement

I have 2 Not for Resale copies of FMP7. I was going to sell them but I'm worried I could get in trouble for selling them. Of course I would charge full price. FileMaker Version: 7 Platform: Mac OS X Panther

I'm really struggling here and I hope someone can help me. I'm working on a solution for my cabinetshop and I can't seem to get past this current roadblock. I need a script which will copy a value from the previous record and paste it into a similar field in the current record. Loosely stated, the condition would be: IF Quantity of Doors is >1 Set Field (DOORSIZE) to be equal to (DOORSIZE) posted in previous record. I guess what I want is something like a conditional LOOKUP, but I want the LOOKUP to only occur in the event of the trigger QUANTITY >1. Can this be done in Filemaker 7 or do I need to try Developer 7? Thanks for…

Am I to understand that FP 7 will not install on my computers running NT 4? If so it must leave many thousands as irate as will be if I have to add costs to upgrading my small 10 man business. FileMaker Version: 5

Hi all, I am new user of filemaker, using filemaker 7.0. I am trying to design a small database that manage projects for a company. I have problem displaying field with specific criteria. My database contains the following entities: Project {projectID, projectName} Project Role {roleID, roleName} Staff {staffID, staffName} And a joint entity: Project Staff {projectID, roleID, staffID, assignmentID} There are several roles such as Production Coordinator, Graphic Designer, and Manager I would like to display on separate areas on the form staff names related to different roles, such as : Production Coordinator and Graphic Designer. I…

hi all, i'm having some difficulties understanding the functions of tables in FM7. obviously, i'm a newbie for FM7 here and hoping someone could tell me in plain English about these tables as well as the advantages, disadvantages of these tables, when to use, when not to etc... cheers, FileMaker Version: 6 Platform: Mac OS X Panther

I'm in the process of setting up a new inventory/invoice system for a clothing company.I apologize in advance for the crude example. I'd like the look of the invoice to be as follows: style size 32 34 36 38 J455 cargo pant olive 1 2 2 3 J456 cargo pant khaki 2 2 2 2 As opposed to: J455 cargo pant olive 32 1 J455 cargo pant olive 34 2 J455 cargo pant olive 36 2 J455 cargo pant olive 38 3 J456 cargo pant khaki 32 2 etc... My main goal is to avoid multiple pages for an invoice while also being more coherent. I realize this post is a bit vague, but if you have any bit of advise it would be greatly app…

Hi, One field in my database shows a list of text options, but 95% of the time the entry will be the first option. Is there a way to get the field to default to that text when I create the record? Thanks! Andrew FileMaker Version: 7 Platform: Mac OS X Panther

Is there any way to use the new commit dialog to trigger a script? What I really want to do is perform a script when data is changed in a record rather than to rely on a button to trigger that script. FileMaker Version: 7 Platform: Mac OS X Panther

I would like to display information about a button when the mouse pointer is over the button. For example, say I had a button that was shaped like a right arrow. I would like it if when the pointer was placed over the right arrow, a small text box would appear and read "next record." This is similar to the feature of some applications called "help bubbles." Is this possible with fm and does anyone know how to implement it? thanks everyone! melish FileMaker Version: 7

I can't figure this thing out! In file1, I have a text field that has data in it that is a phone number. The data was entered by two different people, so some of the 600 fields have verdana size 12, some are verdana size 10. In file1, why can't I force the formatting to be a specific font size? And, in file2 which is related to file1, when the phone number shows up in a field or a merge field in a layout of file2, the data formatting is variable as seen in file1 where the original data lies. I want it to be a specific size - but I can't force it to be! Help! I hope there's an easy fix for this! Under FMP6 it seemed that just file1 had the variab…

Does anyone know if FP7 works any better with SQL Server than FP5? Are you able to insert or update back into SQL nicely with FP7? We have used FP5 vs SQL but only in a retrieval situation. We were hoping that FP7 might address this issue. We would like to start building front end apps vs SQL backend databases using FP7. Just wanted to know if anyone has tried this. Thanks! John FileMaker Version: 5 Platform: Windows XP

I'm not exactly sure where to post this question so I thought I would start here. Is there a way to increase the font size or magnification of the various dialog boxes? When I go into the define field mode and start to enter a calculation, the screen is so tiny that I have to get real close to the monitor and squint. My eyes are already weak and getting weaker from this effort. Does anybody know of a way to zoom in on these dialog boxes? Thanks, Jarvis FileMaker Version: 7 Platform: Mac OS X Panther

I have an unconfirmed rumor from a highly placed FSA member that the 50 file limit is gone. This member has stated as having had 105 files open at once time. This memeber later confirmed that this was 105 FILES and not tables. Sadly the limit of 1 million tables per file is still in place. FileMaker Version: 7 Platform: Mac OS X Jaguar

Hi! I'm working on a text archive and want to print a report with several merge fields in one text block. The report differs from just one up to ten pages. How do I make the text block and the layout part (body) to slide up, avoiding empty pages. FMP Help states you can, but doesnt tell how. Thanks in advance! FileMaker Version: 7 Platform: Mac OS X Panther

I am trying to do something with a container field that goes beyond my expertise (meaning it requires AppleScript). I would be grateful for any assistance you experts out there might lend. Here's what I am trying to do. I have a container field that contains an embedded PDF file (not just a reference). Right now, I have a script to import the file and another script to export it back out. I would like to simplify the "export" process if possible. What I am hoping is that I can click a button to launch a FP script that will export the file and then automatically launch an Applescript to open the PDF in Preview. If anyone could walk me through this process…

When I call My Films DB I can no longer see the fields content. I read <unrelated table>. I In the Finder the file is 6 MB so all the data should be still there, but I am not able to see it at all. Opening Database>Fields, all the fields are there: all the text, number and date, although they don't appear in the browse mode, while the calculation fields don't work anymore as the "table" got either corrupted or I don't know what. I can't export anything either as the Export command is not available. I created other tables but they contain no fields. I am lost. How can I get this file to work again? FileMaker Version: 7 Platform: Mac OS X Panther

Here are a couple of issues i have with ver.7 list boxes. First Has anyone noticed a subtle (but anoying)change in the way drop down lists work in ver.7 compared to ver.6 and before? When I tab into a firld formated as a drop down list I used to be able to press the "down arrow" and get the first item highlited on the list then I just hit enter and the item was placed inthe field. In ver.7 although nothing appears to be highlited when I tab into the field by preessing the "down arrow" as before I now get the 2nd item highlited. Although not insurrmountable problem it is annoying. What I would really like is to tab into the field and have the first item already …

With FM6 I've found that "Text" fields are limited to 64KB of data. Does anybody know if this has been expanded with FM7? Thank you. Garry FileMaker Version: 6 Platform: Mac OS X Panther

Decision of the record which does not use the global field, and the method of cancellation FileMaker Pro Ver3.0->7.0 Please download and check a sample. http://www.ne.jp/asahi/office/momo/upfiles/CommitDB.ZIP I am pleased if it becomes your reference. FileMaker Version: 6 Platform: Windows 2000

I'm looking into doing a database that will use Tablet PCs for people to be able to write handwritten notes as well as use popup menus to enter data. Is there a way to have filemaker store these handwritten notes in a current record? I have no experience with the Tablet PC - perhaps the operating system knows how to stuff a TIFF graphic of the notes into a FM container field? Thanks, Rick FileMaker Version: 7 Platform: Windows XP

I was wondering if anyone has successfully run multiple instances of FMP Pro using Mac Os X (Panther) fast-user switching? I'm imagining a scheme where one user logs in to OS X, launches FMP Pro, then another user switches to their account while leaving the original user logged in, and launches FMP Pro again. Does anyone know if FMP Pro will handle this gracefully? I'm thinking of FMP7 but comments regarding FMP5 and FMP6 are also welcome. The reason I ask is because I know that running FMP3 in Classic and FMP5 in Panther on the same machines breaks things horribly. FileMaker Version: 7 Platform: Mac OS X Panther

I am not sure if I am seeing a bug with the new Replace contents command or if I am just doing something wrong. I am trying to replace a date in a master table with the max of the dates in a related table. Using the replace contents function either from the menu or in a script results in a number being entered into the field, it looks like a Julian date or some other internal representation used by FM7. Trying this with the Set Field command works fine. I have attached a sample file. What am I missing? Echo Version: v7.x Platform: Windows XP TestDB.zip

I'm puzzled. From FMP 7, I explicitly insert a Word document in a container [the document, not a reference], and it opens fine from IWP screen. But if file is pdf, Acrobat Reader launches after I say Open, then says "There was an error opening this document. File does not exist". ANyone know what's going on? FileMaker Version: 7 Platform: Windows XP

Just have to get hsi one out of my system... I love that new ability to set any field to a calc field to format the field. I've got a bunch of users that are used to DOS bases systems where they get to type "T" into date fields to automaticaly insert Todays Dates. They also are in the habit of typeing "T+3" to get the date for three days from today, among some other formulas like this. Now I can use a text field with some fancy schmancy calculations to give them that function. AND.. I get to set the settings to accomidate all those who still hit ENTER or RETURN to move from field to field. (I used to have to do all sorts of fixes to get rid of unnecessary…

has anyone seen a good example of 'type ahead' with FMP7?

I am the client of our company database which is hosted in our eMac (small business). This week I changed my hardware (from PowerBook G3 Lombard to PowerBook G4 15") and all O. Systems to Panther 10.3.3. Excellent in all sense. However a problem raised. The database is appearing in my computer not as a full screen one, as used to. Is there a way to restore the full screen size? Thanks in advance. Jaime FileMaker Version: 7 Platform: Mac OS X Panther

I tried to open a file and got the following message: "Access privileges have been damaged or tampered with." I recovered the file and still get the same message. Any suggestions? Thanx!! FileMaker Version: 6 Platform: Mac OS X Panther

Hi if I lookup a field the inserted text has the formatting of the field that was looked up. I dont know how to deal with that. Thanks Version: v7.x Platform: Mac OS X Panther

I have a database that opens a window for editing a record. I have an OK button that commits the changes, and a Cancel button that reverts the data. I would like to be able to turn off the committing when a user clicks outside the field. If I turn off auto-committing, it asks the user to commit the changes. I don't want it to even do that. I would like the layout to ignore the clicks altogether. Any suggestions? Version: Developer v7 Platform: Mac OS X Panther

Hey guys! I have a(nother) question which I am hoping someone can help me out with. Is it possible to, on the first time the database is opened, show one Layout (as in a "help screen") but on every other time it is opened (2 - forever) it shows a differently Layout? I would imagine that would be accomplished with a script and perhaps a global attribute? I don't know though how to go about it really. Thanks as always Version: v7.x Platform: Mac OS X Panther

I want to display one adress at a time of a customer record I've created a relationship that links a "location" field located in the customer table to a "location" field inside the "address" table. A script dynamically changes the address displayed by simply changing the content of a "location" field inside the customer table... HERE IS THE UGLY PART : The related address is displayed only when at the end of the script I go from Preview mode to Browse mode ! Tell me I'm doing something wrong... It worked perfectly in v6... Version: Server v7 Platform: Mac OS X Panther

Is there any way to dynamically set the path and name of an exported field content? With the "export field contents" it is static. Version: v6.x Platform: Mac OS X Panther

I think I have come across a couple features of the new "Specify print options" option in the Print[] script step that are good and bad: The Good: We can now specify multiple Page Setup and Print options within the same script. This means that when we want users to choose their own layout in a report, we can change the page size and orientation without calling external Page Setup scripts. The Bad: In my test in OS X Panther, if you "Specify print options" to choose" Current record" or "Records being browsed", the script will override the user's default printer choice and use whatever you, the developer had selected for a printer when you set the Print optio…

I realise that topic of font appearance has been mentioned several times already in 7 But it really is aweful and renders applications un-presentable. Does anyone know anything that can be done to improve them. Also is is even slightly possible that Filemaker will issue a very quick update that will turn their anti-aliasing feature off and revert to the OS. There was nothing wrong with the fonts in ver.6. It needs as much pressure as possible to get this "feature" turned off. How did they "miss" in the testing? Version: Developer v7 Platform: Windows XP

FM7 seems to have bugs in layout mode - or just be extremely slow. When I try to drag anything in Layout mode, it takes about 4 seconds before I get any reaction from FileMaker. Then, once I've positioned the element, it takes another full second for FileMaker to recognize that I've released the mouse. In short, it feels like I'm wading through molasses. This happens both on my home computer (XP Pro, 1600x1200 resolution) and my work computer (W2K Pro, 2560x1024 resolution). I've tried re-installing FM7 but still have the same problem. Has anybody else noticed this? Version: v7.x Platform: Windows 2000

I am trying to finish up my first project for a deadline and am stuck on one part... I hope this is possible. I need to display a "product rating" for each record. I want the output for the data to be a graphic ( 1 - 5 stars for example). How can I have the user do this? My idea was to present a set of Radio Buttons which they could choose one of the five options. Now how would I get their rating to display as a certain graphic in a Layout / Template? Anyone on tonight... I could sure use the help! Thanks Version: v7.x Platform: Mac OS X Panther

we are installing a new ISDN30 phone system (see link below) which can intergrate in to databases for phone dialing but im not sure how this is done in filemaker has anyone got any information on how this could be done / via plug-in?? IP Office Version: v7.x Platform: Windows 2000

Does FM7 (or earlier) offer any functionality for managing two displays in OS X? Or should I just plan to carefully position two windows, one on each display? Here's the desired functionality: I want a simple file of: EntryTime Score Event Competitor and a related file with: Competitor Name Picture On the one display (the laptop screen) I want a list of the records in the first file such that you can trivially enter the next score (EntryTime is auto-entered). On the other display (an external screen hooked to the laptop) I want to divide the screen into 4 quadrants (one for each event) and display the competitor number, score, name, and pict…

It seems the only script that runs is the very last window open. via the File Preferences. There is no way to close a window with the CLOSE or [X} and perform a cleanup script. Version: v7.x Platform: Mac OS X Panther

I just discovered that comments can be inserted into calculation fields. The syntax appears to be /*comment*/

Hi, Any chance that FM7 will allow fields/items to be blocked/invisible under defined conditions? This feature would be enough for me to switch to 7.0. I don't understand that this was not available even in 1.0 to begin with... The 7.0 Trial I have running locally takes about 5x the time to do something as my 5.5/6.0 over a server. Is this a restriction built into the Trial version or something? Jim (very eager to try out the new features which might make my life a bit easier).

Hi all, Could someone please explain what are the advantages of the multi tables feature now available as opposed to related files in v6. Apart from the obvious less files to deal with! A customer has asked me for the advantages of upgrading to v7, I don't really know enough to give a sufficient answer yet so I am just doing my research before I reply to them! Many thanks Ed Version: v6.x Platform: Windows 2000

I asked this question a while ago but it never got answered, and I haven't been able to find documentation for this feature. It appears that FM7 (not server) can save a copy of a file while other P2P FM7 clients are connected. FM6 could not do this. Is this a feature of the new architecture, or is it a bug that only I have noticed? Thanks Version: v7.x Platform: Mac OS X Panther

http://www.filemakermagazine.com/ a video about 7 by matt petrowsky - worth checking out

I have some older dbs that I don't want to convert to 7, but instead rewrite them. But I like their layouts. But when I Select > All (and copy) and try to paste into 7, they become graphics instead of layout objects. Must I convert them to use their layout stuff? I have nice icons I'd like to grab. Linda Version: Developer v7 Platform: Windows XP

If anyone is interested, I have attached a file demonstrating one way to do horizontal portals in FM7. By defining multiple portals horizontally next to each other, each one with only one row and setting the initial row larger each time, a horizontal portal is created. By creating a key that can be scripted, scrolling can occur. One must be careful with the sorting though so pay attention to my sort records in the relationship definitions. It did not seem to work as well when I sorted in the portal dialogue. CHEERS. Version: Developer v7 Platform: Mac OS X Panther

In the past I've usually connected all of my solutions' files to a "variables" file where every file relates back to the variables file. The variables file contains a single record and a bunch of globals (the variables). Not uncommon. Here's my question regarding FM 7: is it possible to do this without relationships in multi-table files? It seems that it is. In other words, can I create a Variables table, not relate it to anything, and still access its global fields from different parts of a multi-table solution? I just tried it and it seems to work. -Rob Version: Developer v7 Platform: Mac OS X Panther

So the upgrade price to v7 is $149. That's what we paid full-price for v6 from MacMall. Shouldn't the upgrade price be cheaper than what we paid for the full version of 6? Did they raise the price? Am I missing something completely obvious? (And yes, I'm using FileMaker Pro 6.) Version: v6.x Platform: Mac OS X Panther

There are many different design approaches since many times form follows functions but also there is a good argument that forum should precede function and putting on a different mental cap when developing sometimes when you come to a cross road as to where to put the priority. I have in the past developed the standard solutions where the user goes from a menu to a list view to a form view. Then on the form view - sees portals to other tables. they can click on the portals and go to the related table. Other times I have done the other method of going from list to form to a related list of data. Now with multiple windows of any size is it is not always …

graphically speaking I will miss the option of colouring a grayscale graphics with the text colouring menu.

Now that I've had a few days to explore 7 Developer, I'm starting to think about how to migrate my current project. The project was started in 6 and hasn't been deployed in any form yet. It's about 25% finished, at best. So, the way I see it, no time like the present to move to 7. Now that FM files can contain multiple tables, what's the incentive to relate individual files vs. using a single file with multiple tables? I'd be very curious to hear anyone's thoughts on this as I'm essentially starting this project over...so I can take any approach I'd like. Without going into too much detail, the project I'm working on is for a school. It handles student reco…

Although I'm sitting at a stand-alone XP (with cable modem) after converting a mult-file solution, I received the "exceeded license" error message and FM7 quits! when I try to open one of the files. The other 5 files open just fine. I still have Dev5 installed--could that be it? I've tried converting the single file, and still get the message. So, right now I've gotten 95% of the solution converted! (BTW it looks awful, but you knew that). Any ideas as to why I'm exceeding the license? I'm totally legit in the install, of course. Brand new dev7 package. Version: Developer v7 Platform: Windows XP

Hi all, This may not be specifically a FileMaker 7 question, but it has presented itself to me because of a new 7 feature. Something I'm working on would be great to have a new popup window open to allow a user to do a find - however, I'd like to not have the toolbar visible. All the find - and after find functions - like new request, omit, sort, etc. will be triggered by buttons. This works well, except that with the toolbar hidden, the user can't see which records they tagged as omit in their find. Is there any way to indicate to a user - with the toolbar hidden - that as part of their search, say, the 3rd record of criteria is tagged omit? The …

I have some questions that relate to screen ergonomics. 1) Is there a way to increase the font size at the DEFINE DATABASE dialog box. I have a 20 inch Apple flat screen monitor and the resolution is pretty good but I still struggle when changing calculation formulas, etc. Is there a way to make this a little easier to see? 2) Is there a way to increase the space available for layout names at the left menu bar? I have a series of layouts named: SECTION 1; SECTION 2 etc. The layout menu only displays the 7 characters in the word "Section". 3: I look forward to being able to use the NEW WINDOW feature. Is there a way to reproduce these views…

Hi we currently have a FM5.5/6 network solution with a copy running on a server as a host. I also access it remotely via ADSL. We need to upgrade with extra licences (I guess that means to v7). I am confused as to the benefits of using FM server as distinct from the solution we have now. Of course Server v7 isnt even available yet. At the moment we are using about 5 licences but think will need to have about 8-10. some thoughts or direction to a web page that discusses it would be great Version: v6.x Platform: Mac OS X Panther

1st sorry , this is a duplicated in another forum. But ........... Am I the only one who is still having trouble loading the FM7 OSX installer version? Here's what I have Stuffit Expander 8.0.2 to open it on Mac. If I try on PC to send to Mac. The Mac can not read installer , however the folders on PC go 2 or 3 deep. On the Mac it only goes one deep in the folder. Here the Mac in ? Get Info says Format:Mas OS Extented (Jornaled)10.3.3 Capacity: 9.36 gb Available: 1.5 gb Processor: PowerPC G3 Speed:366 SDRam:128 I have tried downloading it from differnt places , such as FM and other users who have Installed it on macs. What…