FileMaker Pro v7 – v11

I have been updating all our machines to v8, fixing my value lists to not show id values, and using tabs to slim down my layouts. Everything seems great... One thing I've noticed is a significant slowdown in the display of subsummary reports in preview mode on macs. Sorting and calculating the subsummary values is the same speed, but displaying the pages on a mac is much slower than v7. It often takes several seconds to move from one page to the next with v8. I've observed this on three macs all with 10.4.2 ranging from 533MHz to 1.5GHz with the same results whether with a local file or on a network. Not a dealbreaker, but definitely irritating. Anyone …

Hi all, Quite new to FM and still using the demo of v7, but I have a few questions before I actually purchase it, including which version to get... Am I correct in assuming with FM8 Advanced that I can create a database that runs stand alone, and that others can search through and edit? For instance, I'd like to create a contact database that our advertising staff can search through and add records to WITHOUT having the full blown FM package installed? I could just create it initially as a stand alone, then pass it along to them to populate with their data? Then I'd like to create yet another one for our sports department (we're a small newspaper) to p…

I have used FileMaker 6 on my computer without problem. I am trying the FM8 Trial version and it is overall very snappy interface, except when I use the Layout Mode. Then, if I click and hold on the Field button and start to drag the little outline of a field onto the layout to place it, the CPU meter maxes out and the interface behaves like molasses. It is very slow to respond and even when I stop moving it, a long as I keep the mouse button held down the CPU remains maxed. As another example, I try to move a field or label that I've clicked and it takes over a second for it to catch up to where I moved my mouse, and usually not quite in the right place. It makes it f…

Today for some reason I can not fathom, when I go to use the Show Window, the wrong file opens. We have a small network and the issue occures on all machines, including the server. I've tried repairing the permissions, trashing the preference file and double checking the reference files. Any suggestions? Thanks!

I hope it is an ommission, but while adding scrolling in FM8, right clicking in a record for some simple commands (duplicate, copy, etc) was deleted.

I downloaded v8 and ordered v8 Advanced. I have a lot of cases where I use a Popup Menu (in Win XP)through a script which sometimes does nothing more than refresh the portal, but sometimes performs some really useful behavior (like changing a layout, etc.) This use to work fine in v6 (I skipped v7 for lots of resaons), but blows up and FM dies and I find myself back at my desktop. Has anyone had problems doing this in v7 or v8? Methinks they have a real bad bug. Steve

How do I insert a photo into the Body field in FM 8 using the Email Campaign Management template that came with it? I don't want the photo as an attachment. I want it in the body of the email on the right side with the size being 2" square. All of the text needs to be wraped so that it is on the left side of photo.

I have just used FileMaker 8 to create my monthly invoicing pdfs. Usually these are two pages of text per file (including one small PICT graphic) and come in about 300K. In FileMaker 8 they are a massive 2.9MB. To double-check I swapped back to v7 and produced them from there - no problem, they came out at 300K each. I PDFed another report in v8 with just text and it was still 10 times bigger than one produced in v7. Anyone else getting massive PDFs? (Mac G4 10.4.2). Ian

Hi Opening an existing solution in FM8 I came across the following problem. In FM7... My table has a number calculation field 'Max(lines::value)' - it returns the maximum value of a field in the related table. The calculation is unchecked for 'do not evaluate if all referenced fields are empty'. Therefore if there are no related records it returns a 0. My script searches this calculation field with the criteria '<1' which therefore returns all records without related values in FM8... Opening this file in v8 the zero's have disappeared from the calculated field, thus I get no results with my '<1' search and have to do an '=' search to get my fou…

I was told FM8 allows up to 5 users to access and modifiy a single record concurrently. I cannot find any information that supports this claim.

I have a couple of questions about FM 8 networking. THE PREAMBLE: My cabinetshop right now has the following licenses: Computer 1: FM 7 Server on dedicated Imac G5 (OS Sharing OFF) Computer 2: FM 7 on Imac G5 (Stores PDF FIles)(OS Sharing ON) Computer 3: FM 7 Developer on Imac G4 client station(OS sharing ON) Computer 4: FM 7 on Imac G5 Client Station (OS Sharing ON) Computer 1 drives the network for everybody. Computer 2 is where we store cabinet drawings. These drawings are available to the client stations as a referenced file that is stored in a container field. Computer 3 is the main interface computer in the office. Computer 4…

Earlier I thought I had a corrupt file. But the recipe for losing recently-created related records has nothing to do with my particular file: (1) Create two tables related via a key. The first "main" table needs only the key. Second "Details" table has a Details text field, and also the key. Draw Relational link between Key fields, and edit relation to allow creation of related records in Details table. (2) Make a portal on main layout to the related records, and put the Details field there. (3) Go into browse mode, generate a record in the main table with any ID#. (4) Now drag and drop text from another application onto the Details field in the portal. It *see…

In FM 7 if you ran a print script on Windows, it would either not print or revert to the default print settings. You could overcome this in certain circumstances by asking for a dialogue box to come up, however this was not an ideal work around. I was just wondering if this had been fixed in FM 8?

Using FM7. My dbase has about 15000 records, all of which have been imported from various sources, some Excel but mostly earlier versions of FM. There is a date field where the date displays correctly for all except for about 700 records where it shows up as ? ... Have tried all different date formats but still ?... back at the source, the date format is correct. Any suggestions? Cheers, Bapak

Hi I just wanted to let everyone know that I was having issues with all buttons that were embossed with a hairline point line. In FM7 the buttons look fine. However in FM8 these buttons now look flat and ugly. The embossing is still on them, however, I had to change the line to 1 point from hairline to make it look like it did in 7. I havent tried it on the mac because this company doesnt have a mac, so I am not sure if it is only XP specific. Figured I would post it because it was such a pain in the butt to ungroup each button that I had on every layout that I had, in order to change the line point on them...

FM8 claims to be compatible with Entourage (as did FM7), but I have never been successful having the send mail script step send an email through Entourage. It opens Entourage, and that's it...no new message. Anybody else have this issue? Mac 10.4 & Microsoft Office 2004

Just wondering if FM8 is capable of changing printers through script steps that are performed without dialog? 7 was supposed to and never did. Did they fix this in 8?

Boy am I happy I bought the maintenance on the volume license we got this winter.... Of course I just bought a 10-seat network license for Dacons MenuControl too : Oh well, we'll be using 7 until Server Advanced comes out for 8 anyway, so I'll get a few month's use out of it.

For the life of me I can't figure out the supposed email merge features in the new FMP. Help! When the ads say "multiple messages to all your customers" it suggests merging information between stock text and fields of a record to unique addresses as one needs to do in email campaigns. Read the new print manual. What it says about email is "see Help". Read "help". It says have a report in browse mode, go to file/send email and make selections. Well when it comes to message text, it allows ONE field from the layout OR an imported text file, OR a calculation field. If one selects calculation field there's no help if one is to be using this and <<>> o…

The new tab control looks good, I was hoping it would drastically cut down on the number of layouts I use.... where I have a layout that is duplicated depending on whether the user is viewing, editing, creating or deleting a record. I was hoping to do this using tabs but I cant see if I can validate data entered before they can switch tabs. E.g if they use a tab to switch to a view where the fields are accessible to edit and then change to another tab can I trigger a script that checks and validates the data before it goes to the new tab?

Along with the rename of Developer to Advanced FMI have provided an upgrade path for users like me who are not Developers but would love to get our hands on the custom features in the Developer versions. I paid an extra £70 to have the upgrade to 8 advanced rather than 8 and I think FMI should be congratulated for following up their reasoning for a name change and making it possible to move up.

The Go To Related Record bug still exists in FM8. This is were the layout name does not stick or shows "unknown" for the GTRR script step. This only happens when the table being referred to does not exist in the current file but a related file. Go to Related Record [ From table: "{Inventory}"; Using layout: ] [ Show only related records; New window ] This bug has been discussed in a previous thread: Thread #132012 It is a shame that this was not fixed.

I've create some tool tips and I can see the little yellow flags when I'm in layout mode but nothing shows up in browse mode. Is there something special I need to do to activate these tips? Thanks, Jarvis PS: These control tabs rock!

can someone explain this to me...i could see where it could be useful...but i don't know how to set it up or how it works

I recently upgraded from FM3 to FM7. The new functionality is excellent, but I'm seeing flashing or flickering when manually selecting text in a FM7 field (Windows XP). This makes the text selection process appear very jittery, unsmooth and unprofessional. This is happening in every database and in every field using the desktop version of FM7 Developer. Text selection is very smooth, though, when working in an IWP version of a database. This was never an issue in FM3 for me. I notice that in FM3, the selected text appears in a black background (selection bar?), as it also does in MS Word; however in FM7 Developer, the selected text appears in a bluish background…

Hello all I' not sure if this is the right place to post this topic, but anywho. My status functions are not working. I'm using filemaker 7

I am new to Filemaker. I have my main database (about 60,000 records). I want to search for matching records on company name using an Excel file that has 500 rows (or Filemaker file with 500 records) How can I pereform this without having to type in 500 names into find mode.

Drop Down Lists and Popup Menus are much faster. (back to how fast they used to be before 7)

Hello, I'm not sure if this is a bug or a feature, but here's how to reproduce it. FYI, this is also a regression from 8.0v1 beta. 1) Create a layout and put a single field on it. 2) Define the Field Behavior so that you *cannot* enter the field in either Browse Mode or Find Mode. 3) Create a test script with the following steps: Go to Field [] Go to Next Field In 7.0v3 and 8.0v1 beta (Client) the test script would place the cursor in the field, as expected. When using FMP Advanced 8.0v1 (final), the cursor is *not* placed in the field. Can anyone confirm this? Is this a bug? Regards, Sean Mills

Is it possible to use tabs in list view? That would be great! Thanks, Michael Reade

Does anyone know if FMI stopped shipping FMP 7?

Is it just me, am I missing something? I thought 8 had now given us the ability to scroll up and down a screen? I have locked down the status area, but I'm not scrolling anywhere : Don't tell me they've only given support to the scroll wheel to scroll up and down to Mac's... :cry:

We have a FMP 7.0 v3 Database with about 700 records. Yesterday morning, the window was open on the desktop (with a record showing), and my wife closed the window with the "X" in the upper right corner as usual. Her computer runs Win 2000 Professional. An hour later, I double-clicked on the database and it opened with "0 Records". ALL of the records, and scriptmaker scripts, were gone! The layouts were all there. The file size was 24K, previously 1.6MB. There was nothing in the trash, and ScanDisk showed no errors. Anyone know any possible way this could have happened? Last backup was a few days older than we would have liked... I have used Filemaker…

We have this FM8 database that we've spent the summer taking patient data on paper and putting it into the database. The database was developed by a national organization. Our goal is to better understand what we do for our patients, so there is some data analysis required. My gestalt so far is that Filemaker is not the best to create complex reports of data analysis. First, I'd like opinions on whether this is true. If it's true, then I'd like to use Excel for analysis. The bigger issue we have is with the design of the database. Several parts of the database use repeating fields. Exporting these data into Excel creates single columns where all the repeating f…

FM8 has added some new reserved symbols to the list. { } $ In FM7 these were allowed now they are not. This will hurt me a lot as I use the { and } symbols in my relationship names (i.e. {Customer} Address ). The strange part is all the relations and scripts, that I created in FM7, work fine in FM8, but when it comes time to edit their names or code, filemaker puts up a warning. When you try to add one of these relations to a calculation, filemaker will not recognize the relation or field and will not let you add it. So I have to go through all my relations and rename them. This brings me to my real question. Can FM8 Advance do a bat…

Is FM8 capable of generating complex reports or are their other programs focusing on report generation from an existing database the way to go. I have a database with relations to several other databases, and would like to do some statistical analysis of the data. Also, is there a significant difference between FM8 and FM8 Advanced?

Hoping that version 8 addressed FM lack of ability to name the file while exporting the contents of a field by using a field value. rather than relying on OS scripting or plug-ins Anyone know if this has been upgraded ? Thanks, filemorf

humm, why not??

Just downloaded a trial copy of FM 8 and it would'nt install on my Windows XP Pro. Major probem is that its looking for Service Pak 2. We have not installed SP 2 because it renders older software inoperable. How am I to get around this other that installing SP2?

How soon are they actually shipping FM 8 Advanced? I placed an order on Monday and the website says the order is in process but I have not yet received a confirmation of ship date. Are they just inundated with orders or is this vaporware? I know I am just being impatient but I'm so excited about all the cool stuff I keep hearing about. Nobody has answered tsepper's question about OSX phone dialing. As I recall we could that in FM 6??? I'm hoping I will open it up and find that it has built in charting. Some drag & drop GANT charts would be really groovy. Tabbed buttons??? Can you tab from a field to a button then back to a field? Can y…

Hi, Does anyone know if 7.0 to 8.0 will be a simple update or yet another rewrite like with 6.0 to 7.0? I'm just finishing up migrating to 7.0 after holding off for about 6 months (due to seeing 7.1, 7.2 and 7.3 appear in the meantime) and as it would require a lot of rewriting en retesting. Now 8.0 is announced, and I am weary that it will require yet another rewrite. Not to mention the fact we wasted some money on getting update licenses for 7.0 that we will use for only 2-3 months (out of which I spent 1 month rewriting). Please say it aint so...

Since we now have script variables, and they can have repititions that are referenced dynamically, I guess we have real arrays now, and don't have as much use for "do it yourself" ones that use pipe-delimiters etc....

I've noticed a quirk between the Windows and Mac OS X versions of Filemaker Pro 7. I have a database where I have three different windows open at the same time to show three different layouts of the same database. On a Windows version of FM I can click a button and have it work right away even if the button is not in the active window. On the Mac, clicking a button in an inactive window does nothing except make the window the button is in active. I then I have to click the button again to make it work. I like the way the Windows version does it. Is it possible to make the Mac version do it the same way?

Does anyone know if FM8 supports dialing under OS X?

Dear Readers, ISO FileMaker Magazine has released a concise list of new features found in both FileMaker Pro 8 and FileMaker Pro 8 Advanced. You can find the list of features at http://www.filemakermagazine.com You will find descriptions of each feature and how it has been implemented. As a community resource, the same list has been posted to the publicly edited FM FAQ at http://faq.filemakermagazine.com/index.php/FileMaker_8_Features Matt Petrowsky ISO FileMaker Magazine Editor

One of the articles described new features for "many to many" relationships. I can't find any info about that on the filemaker.com site. Anyone know the details?

I see that FM8 IWP lets you customize the iwp_home page. Anyone know if FM8 IWP handles popup blockers better than in FM7 ?

Filemaker 8 seems to have some interesting new gizmos. I am hoping someone can answer a few questions about its compatibility with Filemaker 7. 1) Will FM server 7 host databases written with FM Developer 8? 2) Will client stations that are licensed under FM 7 be able to open & interact with files generated by FM Developer 8? Can the data flow from FM8 to FM7? The stuff that intrigues me is the exporting to excel, PDF printing and the concept of tabbed layouts. I had expected to see more about Runtime but then again the reviews I have read are pretty cursory. Can anybody aim me to a discussion of the new features of FM 8 and compatibility i…

Link Link

With multiple users (Peer or Server) how does FMP deal with simultaneous writes? Does it lock records/tables? Does it throw an error? Thanks in advance.

I'm speechless!!! I can now use my damned scroll wheel!!!!!!!!!! ~cries of happiness~

In a peer sharing (or FMP Server) situation how does FMP deal with globals? In particular if two users are using the same layout, but different records (in the same table), then can there be a race condition on a global in that table? Thanks in advance.

New FileMaker Pro 8 – The Easy Way to Manage and Share Information -- Available Now Company also ships FileMaker Pro 8 Advanced with enhancements for advanced users and unveils the new FileMaker 8 product line Phoenix, AZ (FileMaker Developer Conference) - August 29, 2005 - FileMaker today announced the immediate availability of FileMaker Pro 8, the newest version of the most-awarded desktop database, featuring new ways to work faster, share and manage information of all types, and be more productive (full details at http://r.vresp.com/?FileMakerInc./5b39012686/389011/f5d1156b39/83f1240 ). The new PDF Maker in FileMaker Pro 8, featuring the Ado…

Does anyone have any info in "Dynamic Document Creation"? I am trying to do something where we have a image of a sign and whatever the user types into a filemaker field will show up on the sign. They can also specify letter size and letter color and letter style and it will "update" the image as they make their selections. Can this be done in filemaker? -Tom

Help. I am using FMP 7.0 v3. I have a database with several tables. When I attempt to delete a single record in one table, FM deletes all records from that table. Performing the same operation on other tables within the database, only the highlighted record is deleted. The issue is teh same whether the records are sorted or all records are showing. Baffled why the impact is only one one table and how to fix this problem so I can properly delete appropriately selected records?

Has anyone come across any FileMaker Pro based online discussion boards or forums? There's a group at work that would like to implement something along these lines, and our IS Manager is very hesitant to introduce any new software, such as SMF, Slash, or PNphpBB2. The group that wants this functionality wants to basically use for keeping various teams informed as to projects statuses, schedule, etc. So, anyone have any suggestions? Thanks!

I was looking for a bit of advice...is there a point when it is better to have seperate files instead of more tables. What I mean is...is it better to have one file with 50 tables or 5 files with 10 tables each? I have a fairly large db (300000 records) I am rebuilding.

How can I disable the quick mode switch on the bottom of the window? I thought I remember a post about it a few months ago but I could not find it. TIA.

Due to a recent meltdown, I've lost contact info for everyone. I may have a project to pass on, and can't contact any of you. Please email me your contact info off-list so I can get in touch with you for this or future projects. Thanks, David Kachel Codemasters Workshop Custom Software Developers Publishers of "AutoNavigator" for FileMaker Pro™; An incredible time-saving tool for Developers - Build tab-sets up to five levels deep, up to ten layouts per level; hundreds of layouts without writing a single line of code. To learn more, visit our web site (below). email: [email protected] web site: http://.codemasterswork…

Just a quick question guys, how reliable does filemaker become as the physical size of the database is increased. The reason i ask is this: Im making a database involving the storage of pictures for deployment on server, but while i would like to store references the d*** head network guys tell me i can't map network drives off two of the person(s) computers (and so im assuming the referenced files cant be accessed). Over time this database will become increasingly large, and the pictures will take up a lot of room. So yeah i ended up with 3 questions: a) am i missing something in terms of how the reference files are accessed by the client machine? …

Hi folks, We're having this weird issue where a person will have a copy of FileMaker Pro 7 on their machine complain about licensing, even when no others are running (we DO have a few identical licensed copies installed that are not volume licensing, but we are planning on getting a volume licensing--this is just for prelim testing. If this sounds like the issue let me know...I just can't imagine that a version of FileMaker installed but not running would be recognized...) on the network with the same license. It only happens after we load the db via 'open remote' (we're running FileMaker Server 7). At that point, it will complain that another machine is confl…

Hi, is there an add-on / plug-in / feature for Filemaker Pro 7 which would allow us to use it as a diary / calender solution. We currently have a database in Filemaker with all our clients and details on it and ideally we would like to integrate a diary / calender with that database. Is that possible? Or do we have to get someone to create one for us?

I'm finishing up an app that will be turned into a runtime program and while trying to hide the status area, etc. I can't get into layout mode anymore. I created a script to run at startup (by selecting it with File/Options) called , 'Startup' which does the following ... Close Window [current window] Show/Hide Status Area [Lock; Hide] etc. It flashes something for a split second, then appears that the database is closed (I can't go to Scriptmaker, Layout Mode, etc.) I suspect the Close Window statement is causing it, but can't seemed to find a way around this. Any ideas?

Hello, new here, hootie hoo! The test file below lays it out in detail, but basically I need a way to overcome the limitation of global containers not saving network user changes. I'm trying to create a "flag" to let different users know that a message is in there message box, this flag will be triggered by a button and it will have to be on every layout, this includes unrelated tables. I have a test file for you to play with: Usernames (no passwords) Admin, Moe http://www.joelcardinal.com/_notes/redblue.fp7 I don't want to be a butthead, but if possible please give a working example of the solution--I will probably not understand the theory of …

I don't know where to post this so I thought I would start here. I have a bunch of FM7 files in my trash, and when I try to empty the trash I get an error message that says: "The operation cannot be completed because the item FMStrs.dls is Locked". Near as I can tell, the message is alluding to something related to Filemaker. Any suggestions? Jarvis

I just moved from FMP 5 to 7 and have encountered some bugs. Are these normal? One thing: In one layout I put text in a field and realized that I wanted that text in different field found in a different layout. when I went to the desired layout and field, when I tried to copy the text and paste it, the text came through incorrectly. It copy totally different text from a another field totally unrelated. That's one problem. The second problem that I have encountered is that I just tried to export some records. There were only four fields. It brought in the information incorrectly into excel (exported as a cvs file). There was information missi…

I have a script that runs a report with one record to a page. I would like to create a Table of Contents that includes the Title of each record and the page number of the report it is found on. Does anyone know the easiest way to do this? thanks for any help.

I'm drawing a blank on how to accomplish the following: Table A contains two fields, call them customer & job number. Each customer can have multiple job numbers, so the data looks like something like this: Acme 12345 Acme 12346 Acme 12347 Beta Inc 88899 Beta Inc 88900 Table B contains more information about a given job, and there can be multiple records in Table B for any given client and job number set. I'd like to set the main layout in Table B to have a pop-up menu for the user to select a client, and a pop-up menu for the user to select the job number. I'd like the job number pop-up menu to display only job numbers applicable to the chosen …

I recently created a v7 file for a client with several tables - Inventory, Clients, Invoices, etc. They've spent time inputting all the data for the Inventory (their most important table). Two days ago while using the file, FM Unexpecttedly Quit on them. Now, all the data (except for one record) is apparently gone - so it seems. When the file opens it shows 447 records in the Inventory. However, all but one record appear to be empty. All of the "blank" records lock me out from selecting any fields - as if they were locked. I can't see or enter any information into any of those records. Some of the other tables contain related records that have information …

Let's assume an ordering database for t-shirts, sweatshirts and other "wearables." The "ordered items" table includes a Product_ID field, as well as fields for multiple garment sizes (small, medium, large, and so on). For eample, let's assume there are three line items. The first shows an order for 20 small sizes of Product A. The second shows an order for 10 medium sizes of Product A. And the third shows an order for 10 medium sizes of Product B. My need a summary layout showing the products and sizes. So in my example above, the summary would show: Product A: 20 small, 10 medium Product B: 10 medium Thanks, Jeff :(

I'm not sure if there's a script for this, or if there's a better forum to post in, but here's my problem: When creating a new record for a project, an estimate needs to be generated as well. the 'project' and 'estimate' are two different layouts of the same database which share a serial number and client code. We have a script (and a button) that will generate a 'projcet' and 'estimate' at the same time when it is run, but the problem is people are hitting 'command + N' to create a new record. This generates a 'project' with a unique serial number if you are in the 'project' layout, but does not create the 'estimate' at the same time. Is there any way to create…

Using the Inventory template that comes with FMP7, what I want to do is this: When the user selects an Asset and hits the "check out" button, they are brought to a list view of the Contacts. From here they normally scroll down the list and click to select the appropriate contact. This Contact ID is then added to the History file in the Assets database. Nice, straightforward, it already works. The Contacts at my university all have student ID cards, and I have a card reader which will enter their unique Contact ID when swiped. So I want to be able to hit "check out," then slide a student ID card, and use that Contact ID to find the correct record and enter it…

In case of doing a file recovery you read a lot of different things, but one thing is not clear to me: After doing the recovery, is it really necessary to export all the data into a text format or is it safe enough to use the recoverd FileMaker files to import the data into clean clones? The first way means the hell of a work, especially afterwards when importing data and matching all data to the correct fields!

I want to go to layout, enter preview mode and print but it never goes to the correct record, always goes to first record. I seem to remember reading something about this in 5/6 but can't seem to locate it. Any help? r

How do I do this in 7 ? There is a get function for record count, and found record count. But there dosn't seem to be one anymore for CURRENT record count. I want a calc that says, "You are on record 3 of 45 found (total records 111)." TIA Jerry

Ok, for better or worse I moved my 4000 field DB over to 7.0 v3. I have a few relational DBs connected primarily to moved scanned PDFs out of the main DB (storage purposes). After having crashed a couple of times, now, upon reestablishing the relationships "scans" for unused blocks EVERY TIME. Wasn't doing this trick the first month after I converted, but it is now the normal course of action. This totally sucks as it takes like 30 minutes to cycle through it. Considering moving the scans to a new DB and renaming over top of it. Any thoughts would be appreciated. Wes

I am posting graphics into a container field and also directly into a layout and they don't print out very well. Any suggestions?

Not sure if i'm posting this in the right place or not but here goes: I've seen comments and didn't quite understand what's with all the "what platform are you on". The solutions I work with are such that I'm providing maintence on existing code. I've been working with filemaker since version 4 but didn't really understand it well and start doing some hacks till about version 5/6 and now have some users on version 7 with our solution. So my question is this, what are some of the big differences in how scripting works between mac and windows. Is it mostly when it comes to modules (the applescript/windows scripting) or are there some differences with script maker …

Hi all, I'm relatively new to FMP7 and building my first solution. I'm wondering if there's a way to lock a field (from edit) based on some condition. I have a field in my main table, "grade", that should be locked based on a date range of two global fields in my user interface table. I have the global fields "grade_begin_dt" and "grade_end_dt" set to the date range when the field "grade" should be open. If the current date is outside of that range, I want to lock the "grade" field and prevent any edits. Any thoughts appreciated! -Heather

Please help, I randomly had Filemaker Pro 7 crap out on me on a PC running Windows 2000. The program has run fine for months, and out of nowhere, it nows freezes the whole machine while starting up (cursor moves, but remains an hourglass). The splash screen has paused on 'Initializing' and also 'Building Font Menu.' I've since done a complete uninstall, clearing out the registry and doing a clean install of FMP7 on this PC, and still it freezes on 'Building Font Menu.' I've tried emptying the Temp Folder as well as deleting what I believe were third party fonts (I could use more font advice though). Please help me!

( I think this a well worn topic and I thought I was on top of it but ...) I want to be able to print to different printer drivers - a fax program and PDF printer. I understood that now in FM7 it is possible to set the Print Setup paramaters, including the printer, in the Print Setup script step. I have created the following test script: Go to Layout ["whatever"] Print Setup [Restore; No dialog] 'use printer B Print [] Print Setup [Restore; No dialog] 'use printer C Print [] Before running this script I set the filemaker printer to printer A, However the windows default printer is D. When this script runs the f…

I have a db that works great on WinXP, my creative team, all running Mac OSX, is having a hard time with some value list pop up lists - it is set up so that in field one, a job number is chosen via a pop up value list, then the 2nd field is populated with the corresponding job name (also a value list). On the PC, no issues, on the Mac, the job number part works fine, but it won't populate the 2nd field, unless the user clicks off of that field, clicks on one some other fielde, then clicks back to the job name field, then it fills the name in. Any one have any thoguhts on this? Thanks...Kim!!

Thought I might just ask this question to some of you that have a fair bit more experience than me with FM. I am coming to the point of completion on a solution I have been working on for some time. It has turned out to be an absolute monstrosity though. About 60 odd actual tables, literally thousands of fields and even more relationships (the gragh is almost impossible to make sense of). Hundreds of value lists, and I have to scroll down for 30 seconds or so to choose a layout from the bottom of the list. I am preparing the reports now and have worked out that the only way to produce one of the reports is to create a further 338 calculation fields, 169 relationships…

Has anyone else had this problem? When in the browse mode in FM7 (w/ Mac OS 10.3.9) usually the cursor is half a character off, sometimes about eight characters off, occassionally right on. I did not have this problem with FM6. Any suggestions would be much appriciated. Thanks. (Btw, I'm a totally low level, one-person-office user.)

Hi gang, I just upgraded my pc and now when I am in my solutions, I get a "Blinking", on certain layouts. It seems to be refreshing at a rapid rate. On some layouts with graphics it can freeze up and blink for a long time. Is this a setting in FM or in Windows? How can I solve this? Any help is greatly appreciated. It's driving me crazy. Thanks

I'm currently working on a Filemaker 7 solution that contains about 6000 records. The solution keeps information on books and includes information such as authors, title, description, and so on. The title field is set to index all, and searches on the database occur very quickly, both using Filemaker client, and via the web with CWP with XSLT. The problem I'm having is when I attempt to sort the records. If I want to sort all of the records in the database the sort can take up to about 30-40 seconds, even if I sort on the title field (which is set to index all.) Why does it take so long to sort this many records even if I'm sorting on an index…

I am in the learning curve of the FileMaker 7 power. One great thing from this new version is the ability to have more than one window open at the same time. And in my solutions I used to define some globals. I perform validation through a script using the data that the user inputs. This way data can be modified before the record is created. With earlier versions there was no problem since every file had it's own globals. Now, with version 7 and all the possibilities you have in the relationships dialog box it is entirely different. I am still trying to recreate the same way, so: 1. I create an extra table with all my globals(defined as globals so they can be acces…

UBB16-ML-167720-ML- This has nothing to do with the Version being used

Okay, recently we converted our bases from FileMaker 5.5 to 7, because there are greats improvement. However, it gives me hours and hours of readjustement, some functions does not work exactly the same way as before, and etc. But now, since our users begins to use the database, there is a huge problem happening at a lot of places in our databases : A message complaining that there is another user reserving a certain record. The point is, when an user makes changes on a record from a portal, and then use a button that is automatising tasks, the script complains that the record is used. And sometimes, a script is used and the user can't do anything without quittin…

UBB37-ML-167666-ML- We have a topic area for Bar Code questions

Sorry for posting this under General Discussion, but I wasn't sure where to put it. About 2 years ago, someone created a Filemaker database for me using FMPro v5. It was set up so that I could access it across the network at my office using a web browser. The web pages were generated using HTML files titled "default", "error", and "results". Now I'm trying to get this same database working in the same manner using FMPro v7.0 on my own, and I'm running into problems. I've managed turn on Instant Web Publishing and have successfully accessed it across the network. But this doesn't seem to be what I need, since it displays the data in a Filemaker-esque view ins…

I have a data base containing several tables. Each table represents hardware on our network, clients, servers, printers etc. Each machine is assigned a unique asset code. I would like to be able to define a search where an admin can come into a layout, enter an asset code and find the related hardware. this requires me to search on a single criteria across multiple tables. How is the best way to go about this? I was going to create a layout with one search box (for the asset id) and then several portals into each of the tables? Any ideas as to this working and or any better way to go about this. as always thanks in advance for any help

Background info: Mac OS X 10.3.9. Trying to install Filemaker Pro 7. I'm a web developer who is overly confident on PCs and Unix-based systems but this new gig has me working in a cubicle on a Mac and I'm losing my mind (what's with only one mouse button? Weird). Anywho, trying to get a trial of FMP7 on this computer so I can debug an application I wrote. When I go to install this trial version, I get to the page where I have to specify Custom or Easy Install. Whichever I choose, on the next page when it is doing the actual installation, it stops a little bit into it and takes me back to the page where I have to specify install type. I have tried both custom and easy…

I have a FMP7 file that was initialy developed and in use while I developed a second component independent of the first. Is it possible to merge the two into one file or should I continue working with two separate files? It definitly is not aas clean as one file with additional tables.

I am newbie with FM and trying to print labels ( this I can do) but I want to group data. e.g I have the following data in two different rows: J2 1-7-2005 CS-00000367 Acuvue 2 BC 8.7/DIA 14.0 PWR: -5.00 1 Mr Jones , 123 smith st J2 1-7-2005 CS-00000367 Acuvue 2 BC 8.7/DIA 14.0 PWR: -5.25 1 Mr Jones , 123 smith st I would like to print ONE label if the CS number is the same containing different PWR fields. e.g LABEL: CS-00000367 Mr Jones , 123 smith st J2 Acuvue 2 -5.25 x 1 J2 Acuvue 2 -5.00 x 1 Is it possible do something like this. Do I need to write a script? any help would be greatly appreciated. cheers

I have a customer that is having regular problems with duplicate serial numbers in FMP 7. They have multiple users creating new records at one time and they are getting as many as 3-4 duplicates a day. Serialization is set to occur on record creation. In FMP 6 I scripted record creation and put users into a que while a different user was creating a new record. I've come to believe that duplicates shouldn't occur in 7. I've change the field to serialize on record commit for now (hoping that will help.) Has anyone else had any experience with this? Thanks much.

"Error 1723. There is a problem with this Windows Installer package. A DLL required for this install to complete could not be run. Contact your support personnel or package vendor." Just to make sure we didn't get a wacked download, I transferred it to my computer (win xp) and upzipped it and installed it there, no problem. I've searched all over the net for any information on this error. Any help would be appreciated! Thanks!

Hi, I'm not entirely sure that this post is being made in the right topic, but here goes. I'm trying to design a database that takes care of daily and weekly production data for a TV show. Anyway, using two layouts I am able to take care of daily calculations (such as total tape recording time) with ease. However, because we handle operations, we only allocate some things on a weekly basis (such as total studio time). Using a second table to track this stuff is no biggie. However, I do have problems when I want to compute that for a given day we have used x% of our weekly studio time. So my question really is how can I have a calculation from the weekly…

Hi everyone, I created this database that allows me to track where a certain item has moved to and on what date. Therefore, there are many date fields for a specific item. What I want to do is print out the item, where it is, and the most recent move it made. Does anyone know how to do this? I don't want all the dates and places it has been to, just the most recent. Thanks.

Hi, I've had an issue with FM7 and FM7Dev on my Windows XP PC for a little while and now it's become a real problem. When I select field contents and copy, either by Ctrl C, menu Edit|Copy, right click|Copy, or by script, the copy randomly fails, leaving a null field in the clipboard. In other words, it writes over the previous clipboard contents with a null. I was gnashing my teeth and working around this for a while, but now I need to use the Copy function in a script. Something in the back of my mind says it may have something to do with Office and how it uses the clipboard. And, I have the fewest problems after a reboot, then it gets progressivl…