FileMaker Pro v7 – v11

I know in previous versions of Filemaker you couldn't use scrollbars in a checkbox field. Has this been fixed? If so how do you do it?

Does somebody know the portnumber that filemaker client uses for network connections? thnx already!

I have a look up happening between two databases that is troublesome. When I create a new record, the look-up doesn't happen. If I move on, define fields or something (haven't found trigger) and come back, the values are then populated. I have other look-ups happening using different relationships that work fine. Anyone have any ideas why these won't happen. BTW the relationship is an indexed calculation with a value of 1 between both databases. Like the cartesian X value between relationships.

Hi all I'm trying to understand the way some templates of FMP 7 work, e.g. "Resource Scheduling.fp7" or "Task Management.fp7". In these files, I see in almost every table, a field named "one", calculated, value = 1 and also relations based on that field. I understand that it always, in every row of every table that contains it, it equal to 1. Can anybody explain what is this field? Why and how it is used and what we can wait from a relation between two tables based on a field like that? Thanks for your time NLo

Hello, I have a problem of import data from another table in same file. I have a script to import data from Table B to Table A, I used filemaker network path "fmnet:/192.168.1.11/testfile", because this is a sharing database. However, when remote user run this script, their FM7 crash and quit. Only host can run this script with no problem. Is it a FM bug or I used a wrong file path? Please help! Damon

Ok, this is the same database i posted about before. It is something for me to keep easy track of the PCs (and other related equipment) in my office so that i know which ones are next on the upgrade cycle. I basically have a table that lists all the different pieces of equipment. Due to the fact that certain things like monitors and scanners will be attached to a particular PC, i made a relationship back to itself. Equipment::Attached_EQID <==> Equipment::EQID That part seems to work perfectly (well as perfect as my skills will allow). What i am stuck on is trying to generate a layout for report purposes. I would like the eq, which are attached …

which one is better? if i make my db app with one INTRICATE fm7 database file or split it to many fm7 file if most importatnt factor is speed of operations?

I can't figure out how I to create a relationship between two different files, I only see an opportunity to link between tables in one file.

I'm trying to set up a web page that will be able to perform a search and then download a CSV or excell file to the web user. Anyone know of a plugin or trick that will help to do this using FMP7 Server Advanced?.

How do you clean out the "most recent" file? Mine is getting cluttered. I have downsized it to show only last 2 entries. I wanta to clean it our because I am getting duplicates. TIA Ivan

Hello all! I've been working with MySQL for over a year now, and it works great for the online development I do a lot. But now, I've been contracted by a major research institution to do database work in FMP7. I've never used FMP before, and have been teaching it to myself over the past week while trying to complete this invoice. This invoicing system has the following requirements: 1) Needs to be able to place 4 different products with 4 different quantities on the invoice, preferably with a single drop down menu for the product (with a value list linked to the products table), a single numeric edit field for the quantity, and a "add product" button so that…

I know it would be unsupported but does anybody know if there is a way to override the restriction on installing FM7 to an NT4 machine? I have a client ready to upgrade to 7 but would not be able to upgrade their network. I'd just like to see what would happen with 7 running on NT4. Any help appreciated A. StrawClutcher

I've worked with an excellent third party''s FM database for a number of years, currently operating under a 9.2 environment with Mac G3's and FM4.1V2. We purchased the product with a number of user licenses. Unfortunately, the owner/developer of the database software has moved on to other ventures and has not upgraded their product to operate in an environment beyond FM5. Preparing for a migration to a G4 or G5 (ideally) machines, with OSX.2.or OSX.3 environment, I set up a X.2.8 and FM7 testbed. Converting files was successful and I could launch my database in FM7. The following problems were encountered and I would appreciate any suggested specific or general reme…

Hi All, I'm a DBA but new to Filemaker... We're thinking of using FM7 to make a quick contact management app. I'll need to be able to enter people and companies, and various fields for each. The relationship from people to companies is many to many. Creating the tables/fields and relationships is easy... but I'm having trouble with the layouts, and how to create a simple interface for a many to many relationship in FM7. I guess FM doesn't seem too intuitive to me, but I'm pretty new to it. Should I be using it for this type of thing? The help files do a great explanation of simple things, but there are no complex things explained. I've looked for boo…

Anyone know of a way to connect with TCPIP/Telnet with Filemaker 7? I need this to talk to a software that tells the distance from one place to another (kinda like a map quest(but its software Ive bought that uses tcpip)) Unfortunatly this software does not use odbc Just TCPIP

Hello, I am very new to FMP 7, and I recently attended the "Magnificent 7 " tour in PA. I have been working with the business tracker software and I remember seeing on the tour that files such as PDFs could be attached to invoices etc. But I can't figure out how to do that. Any advice? Thanks!

I'm writing an application to track health history for athletes. Essentially each student fills out an on-line health questionaire to which they answer yes or no to each question. If yes, they fill in the details. There are 90 questions on the current questionnaire but it needs to be modifiable by an administrator. I only want to retain the "yes" information for that student. So far i have a Student table and related Health History table. How should i set up the Questionnaire table so as to avoid lengthy scripts?

I am trying to create a relationship that will display all my sales files that have not been shipped. Setup: Table Occurences: "Sales" - source table is sales "Sales_Open" - source table is sales Relationship: "Sales_Open" - self join relation, relates back to the same "Sales" file. This relation is link between two fields the 'shipped_n' and 'constant'. Fields: 'constant' - global number field that only contains the number 1. 'shipped_n' - number field that can be 0 or 1. ) for not shipped and 1 for shipped. I want a portal on a layout, based at the "Sales" table occurrence, to show all the sales that are not shipped. Pro…

Hi, I did a search for this but probably got my wording wrong. I have a new field, called 'avtive record'. I want all of my 400 records to have the value of 'yes'. I set it up so new records default to 'yes', but how can I make all existing records take on that value? Is there a way similar to Excel, whrer you can have one value at the top of a table, then Fill Down to all the other records? If I need to make a script, could you give me a quick skeleton of what I will need to accomplish this? Thanks for the help!

How do I perform a Find on a checkbox field? Say I have Completed Date field displayed in my layout as a checkbox. How can I search for everything unchecked? I tried not checking the box but I get prompted with the "No Records Found" dialog. Thanks...

I have a main database with relationships to 3 other databases. After converting these to FileMaker Pro 7.0v2 the main database no longer "finds" the related files. When the related file is called FM7 gives an alert message that the file can't be found. When I click OK, it lists all the files in that folder & I can choose the file that should be opened. After doing so the main database file will relate to this target file fine until I quit FM7. When I restart, the same alert message appears. What did i do wrong? Or what changes do I have to make in the scripts, etc.? Sure would appreciate any help you can give me.

I recently upgraded to FM7 from FM3. I have a small business that I run with FMP, consisting of 3 files - Contacts, Invoices and Products. I believe these came as templets in FM2.1. They are linked together via "lookup" (sorry for my lack of proper FM terminology) and worked perfectly until FM7. The file I am having problems with is Invoices. I had a repeating field that via lookup would bring over product name and price when I entered the part number. Once I converted it to FM7, only the first row would lookup the requested info - the other fields no longer filled in. I was told from FM tech support that this no longer worked in FM7, that I would need to use a porta…

I am recreating a solution in FM7, and I have to say I am about to pull my hair out. My biggest issue is it has turned my once super-duper PC, into the equivalent of an old 256 (or worse.. the old Apple II i used to have). WHAT THE - nothing drives me more mad than the slowness that has occurred with the shift to FM7. When dragging objects in layout mode i have to wait forever for the item to catch up with the mouse. lets not even start on the font rendering. Has anyone heard anything of a patch coming out anytime soon? I've just convinced them in my last project to convert from access to filemaker... Doesn't look too good!!!

Hello all. I'm sort of new to FM (used it quite a bit a long time ago). I'm working with FM 7 on a project and want to use a popup to select a value from a foreign table to assign an FK value in the current table. I can get this to work but not cleanly. The example would be say you have two tables, Company which has basic information about a company and a unique key value of type number and a name of type text. The second table is called Contacts with a primary key value as well, a contact name, and an FK (foreign key) value to store the Company key value. Now, I have a popup that allows the selection of a company which currently displays the company key along…

Have been reading about FM7's ability to separate data from interface. I have been looking over the FileMaker tech brief doc "techbrief_fm7_foundations.pdf". In there I found a section regarding the interface and data file separation. They not only talk about these two file layers (data and interface)but a third (business logic), They say that the business logic layer file should contain derived-data fields, summary fields, value list that change, reports, etc. Its benefits are for quick re-purposing the file for other solutions. A few examples they gave: Invoice line item file has the data fields - product ID, quantity, price. While the business log…

How do I do a "Find" in one table and then have that found set be displayed in a related portal? For instance: One table named Client, another Jobs. Jobs has a field "Status", and I want to show all of the records that are Status=Closed (or user-definable from a pop-up menu) in a portal on the Client's table screen. How? Thanks! -T

I'm certain I'm just missing something but how do I set a specific repetition in field1 based on the value in field2? In other words if field2 contains 6 I want to set repetition#6 in field1 to value X. I've browsed this board and searched docs/etc. but all I've found is the Set Field command which requires a hard-coded repetition #. I could make that work with a brute force sub-script but I'm certain there's a better way and I'm just being an idiot. Thanx! CharlieD

I'm working on a solution for scheduling patient appointments on a layout that shows seven days at a time. I created a unique relationship for each appointment slot for each day of the week so that when appointments are made, the patient's name is displayed next to the appropriate time. This makes it easier to see exactly which appointment slots are available and how much time (space) is between any two appointments. A button is then assigned to each slot so that clicking on the space calls up the layout for creating appointments in a new window, or shows the appointment if one exists for that time. Okay, so the problem I've run into is that creating new appointme…

I don't understand this problem yet. I have a file, and when I create a portal (with scroll bars) and place it in the header or the footer of a document, the portal is nearly unusable because of redraw problems: when I scroll using the arrows strings of bits stream across the portal, when I scroll by a page (clicking above or below the "thumb" of the scroll bar) most of the records are not updated on the screen. (You can see this because when you select a portal row, suddenly the "real" data in the portal is shown. Changing the size of the record w/in the portal changes what goes wrong, but in every case the portal always shows the wrong data after being scrolled. …

I have looked for a good thirty minutes in the online help and been through all the menu choices (I think) but still can't find it. Setting defaults (for formats): 1. My label fields always come up 9 point, bold, arial and I have to change them individually after the fact. 2. My text fields come up with effects-embossed; don't want that. What do I do to set my preferences accross the file--not after the fact, but before I add the field to the layout? Also, while I am on the topic of making field characteristics uniform, is it possible, once all your fields are on the layout to apply a uniform height? I find that after I resize fields the heights are not uni…

Using IMac OS10.2.8. Up graded to FM7 and converting files from FM5. There has been some talk about FM7 slow speed. From my perspective the solution is so slow I don't want to actually put it to use in the company until there is a fix but I'll continue converting the scripts and upgrade features until the fix is available (assuming it will be). I wonder if my slow speed is due to using OS 10.2.8 and not the latest version of OSX, or I truely have a bug. I have short scripts. go to layout x, change window tile name to Y, set fields A & B & C. Show dialogue. What I see happeing is one by one the steps being done. A fast (but not very fast) count of 1,…

Field 1: Date of birth Field 2: Current date or entered date Field 3: Current age (calculation field) Question: Specifically how do I set up the calculation field for field 3? I have tried to figure this out by searching the online help and the post histories for calculating age. Sorry if this has been covered elsewhere. Thanks. Doug Lazenby

Seeemingly simple question: I created a merge field (name) that consists of theses 5 individual fields: title, first name, middle name, last name, suffix. that would yield e.g. Mr. John Henry Doe, Jr. My problem is that on the layout, in layout mode this text box takes up too much space on my layout. When I try to shorten it with the "handles" it just creates a 2nd line so that the "volume" of that text box is the same. This takes up too much space on my layout, cluttering the area, making it impossible to add adjacent fields on that line. In contrast, if I insert a field onto the layout (by selecting the field button --> specify field), I can shorten that "box" o…

Is there anyway to get the tutorial files for filemaker. I have downloaded the trial v7???

I use filemaker as my database from which I sell business leads. I have one client who only wants businesses in a particular SIC code who also has a fax number. I have many fields per record including SIC code and Fax number. I am hoping that someone can tell me a simple way without using scripts which I've never done, how to do these in find mode. I realize to enter the SIC Code in the SIC Code field, but I have no idea of what to enter into the fax field. I've tried "=", and "==" as well as "=" with the omit button checked, but none of those work. There hast to be an easy way to say give me this SIC code, but only with there is a value in the fax field. Your help would …

I wish to create a NUMBER Field and a DATE field that defaults to the current date then use those fields to perform a calculation that will: Show all records for the last "X" days where x is the number in the Number field. thanks Graham

Is there a way to toggle into the define database dialog box without having to mouse click the drop downmenu bar at the top of the screen? The menu bar suggests a combination quick-keystroke of ARROW-COMMAND-D but this only brings up the ability to select an existing field to place on the layout. What I am trying to do is get to the Define Fields dialog box so I can create a new field or amend a new one. Can this be done with keystrokes or am I chained to the mouse? I am running Developer 7 on Mac OSX Panther. Thanks, Jarvis PS: Does anybody know of a better remote mouse than Logitech? This one does the job but does not seem to be as ac…

First off sorry if this post is in wrong place, all the topics in database schema section seem to specific. I Would like to know if it is possible to copy a tables schema from one database.fm7 to another? David

Merging a name: Field1: FirstName; Field 2: MiddleName1 Field3: MiddleName2 (some people have 2 middle names); Field4: LastName In Layout, I use the insert merge field function to put the fields together and I leave a single space between the inner merged fields. However, if the person does not have a middle name(s) I am left with extra spaces that make it look askew. Example: John Jacob Jinglehimer Smith would have the appropriate blank space behind Jacob and Jinglehimer. However, if his name is John Smith with no middle names it will come out John Smith with 3 blank spaces between John and Smith. I guess I could put no spaces between the merge fields and try …

Hello. I am a brand new convert from MS Access... Just got FMP 7 Dev out of the box and was exploring a little. I opened a couple of different templates and tried to double click on the area where you would insert a picture and the entire program keeps shutting down, erasing all my entries. I can't figure this out. Like I said I am brand new to FileMaker (I bought Dev 7 to hopefully learn and then convert my workplace from MS Access!). Does anyone have any suggestions or can point me in a direction where I can learn the difference between MS Access and FM Pro? Thanks, And I'm sure I'll be posting quite a bit here in the beginnning Vandy.

Hi, I'm a newbie trying to make a script and, after a few days of messing with it, am in need of some help. I'm making a Medical Record script for my summer camp kids which has 3 tables. Demographics, Encounters, and Medications log. My script uses the patients name as the constraining information and goes to each table, looks for the patient, and then prints the data. What I should end up with is the demographics cover sheet showing name, age, etc.; a list of all meds I've given and a list of all encounters. It works fine if the patient has atleast one record in each table, but if they don't, it goes back to the last table and prints it again. So, I start with…

Hello, I have used filemaker 6 for some time (being self taught) and have the update to 7. I have only installed it on my PC so far to play with. I am having difficulty getting out of the mindset of creating new databases for everything I need to relate (i.e v.6) Could someone please give me the brief low-down on how to better structure my db's or is there a whitepaper somewhere? Basically what i'm looking for is a brief description as to when I use tables -v- a new relational database. The basic rule of thumb iv'e been playing with is if the information is used by multiple different db's (e.g a list of authors) then i have it in a new database. If …

I have a database with a number of relations. It is often convenient to see in view A the number of related records in table B (where A<->B is a many:many relation via an intermediate table). So I put a calcuation field in Table A Count (Table B::tUniqID) and this displays the number of related records in B. The problem comes when A is a Table Occurrance that references an table in an different file. I can't create the field locally (where the relationship between A and B is defined). But if I open the file and try to create the field there, I don't have access to the same relationship. The only solution I can think of is to create a new lo…

This may be a simple question... Is it possible script the movement of an object on a layout? I'm looking for something like this: Move/Resize Object [Object Name: <name of object>; Height: <n>; Width: <n>; Top: <n>; Left: <n>] Thanks for any insight, Jeff

Don't know if anyone else has run across this issue. I reported it as a bug, but maybe I'm missing something. Anyway, I have two tables (T1 and T2) and a join table (Jt). All relationships are by keys. JT records are created from T1, and the T2 key is looked up via a secondary relationship based on a global text field in the join table. (T2 key is looked up based on a text value put into a global field in the JT portal row. See attached .pdf. Global text fieldin JT is via a conditional pop-up list based on text values in T2.) This is all quite normal stuff so far. Unfortunately, when I'm creating new records, instead of looking up the T2 key, the p…

Im deploying Server 7 and I see that when I try to open remote from my FM7 client I only see certain files. The files I see were multi user files when they were created in FMP6. The ones I cant see were created as stand alone. In Server 5 you could have server host single user files. However, I can't find that option in Server 7. Do I need to activate networking on the individual files now or am I missing the way that Server 7 hosts files with networking turned off? Thanks Ron.

Is there a method of doing this in FMP7, where it doesn't store the insert as a referenced link only? I spent a good hour or two playing around with it, and every time I inserted a hardcoded imagewin: link, it would break the link when the image moved like an OLE object. This is important for uploading files and automating inserting them into container fields. If there's not a way to store the image in FMP7 from a "Set field" command, or to be able to use the "Insert image" and have the values based off of fields. Any help would be greatly appreciated.

which one is better? if i make my db app with one INTRICATE fm7 database file or split it to many fm7 file if most importatnt factor is speed of operations?

Curious if anyone has come up with a nifty technique for displaying different portals (one at a time, in the same space on the same layout) depending on some variable condition. I have different sets of related information that I would like to show in one common area of a layout, but I do not want to duplicate layouts in order to show the different portals. Being able to hit a button (effectively, to change a global field) and then show a different portal in a "portal space" would vastly improve some layouts. I messed around with the portal "visibility" technique to try to do this but could not come up with a workable solution. Thoughts?

How does one go about registering a solution using Filemaker as intellectual property? We have developed a very sophisitcated fm solution and now have three clients interested. Before proceeding with beta testing and licensing we want to know how we can protect our time and creativity.

Hello, I am thinking on how FM7 new function benefit if I want to design a new FM7 solution with Data & Interface separation method. For FM6, the reason I like data & interface separation method is easy for future development after implement. I also make the portal (in interface file) as list view and I can limit what user can see, to improve security. But I also hate this method because it made many FM default functions like find, sort... requires developer to use script and calculation fields to make similar functions. I would like to hear all of you sharing experiences and comments on "Data & Interface separation method", especially if you ha…

I have been learning Filemaker via the Business Tracker solution/sample, I have a strong DB back ground and understand the tables and relations specific to my question. What I would like to learn is how the location tabs are able to display data from up to 4 rows from table having a 1 to many relation without the use of a portal? Layout name 'Company Detail (Contacts)' use table 'Company' and has 4 buttons on it bound to field location::namedisplay, this field is of type calc using a case function and to the best of my understanding will always be true. TextColor( Case(UserSelectedLocation::UserName = Get(AccountName); TextStyleAdd ( Name ; Bold ); TextSty…

Is there a way to run a script when a window is closed. Running a script on close only happens when you close the last window of the current file. If the file however still has a window open then the close script is never ran. I wish there was option of run script on close window and run script on close of file thanks.

Hello all, This is my first post here. I currently have a FMPro7 Database. I originally designed it to give me an inventory of the computer hardware in our office (PCs, Monitors, Printers, etal.). I need to add a new functionality to it. I now need to track software Licenses; what we currently have and how much more we need to buy. The way i would like it to work is that i can query for a specific PC, then be able to note what software it currently has loaded and what software the user has requested (so that i can budget for Licenses). For Example, i currently have the only FMPRo License in the office, but we have some users who will need it. I'd like to re…

I'm sharing fm7 files on pc and on remote pc's I was hoping to create a shortcut to the main shared file rather than making them go through the whole "file>open>remote....process"? I'd also like it to eventually open on startup. Jared

Is there a fast way to "convert" a collection of FM6 databases to FM 7 tables (in one database)? Thanks

Im having a little problem with filemaker 7. I have a layout with a portal of records. When you click on the portal line a new window is created with more information on that related record. In the new window I have 2 buttons that I created(Save, Cancel). The Save button calls a script and checks the 2 fields that are editable and makes sure everything is filled in fine and then saves. The Cancel button calls a script that Reverts the record and closes the window and goes to main window. This works perfectly when I turned off save record changes automatically in layout setup for the popup. My problem is this.... If someone hits the X on the window (to close the wind…

Is is possible to use a variable or field in the right side of the equation for the "Specify Find Request" option that is now part of the Perform Find Script Step? It seems like the only place I can enter a field is in the left side of the equation. On the right it looks like I can only enter an operator and a constant. I would like to enter a field on each side. I am still trying to understand this new option in FM7. Thanks, Kevin

Hi all, I am trying to lock the user in the current record but couldn't find a way to do it (block the user from accessing other records). Does anyone know how? Thanks, H.P.

How can I Open last opened database on startup?

I can understand people who dont like the new fonts, but it suited me just fine. Is there no way for me the go back to as it looked in FMP7 V1? My arial fonts look like crap with the new update. Can i set my file up so it shows the old (v.1) fonts? Sorry FMI, you cant make everybody happy...

Hello, A client comes to us for a solution on FileMaker. We downloaded Filemaker pro 7 trial version. and are requested to update data to FileMaker Pro 7 over ODBC. We installed DataDirect 32-bit sequeLink 5.4, but ODBC administrator doesn't identify the driver. (we examined the list, and found all drivers are microsoft branded.) We aslo tried to install the driver following the windows standard installation(control pannel, add/remove programs), and the problem persisted. The OS platform to install FileMaker and ODBC driver is windows 2000 professional. Please guide me, and thanks for any help! FileMaker Version: 7 Platform: Wind…

I am completely baffled trying to configure the ODBC drivers. I have a web site that uses a PERL script and flat text file to server dynamic pages. I want to use FM7 to run backend operations off the database. I have the drivers installed, no problem. I go to ODBC Configure, add a new File DSN, follow the steps in the Filemaker Help, click the OK's to quit. When I go to FM and try to import from ODBC the data source doesn't appear, nor is there any way to navigate anywhere. Just the Cancel button. Back to ODBC configure...... Back to FM..... I am lost. Can anyone point me in the right direction or to a good tutorial? Thanks

If I do a find on a non-numberic work order number field looking for work order 1. I then get a found set of records with work order number 1, 10, 11, 12, ...etc. What am I doing wrong? I just want to find Work order 1. Thanks for your help.

Hello- Whenever I add or modify a calculated field, in order for it to take effect, I have to re-enter the fields that it depended on. Is there a way to make the fields update themselves automatically? For example, to find out the age of a client, I enter their date of birth into "DOB", then via an auto-entered calculation "Age" will be populated with the correct age depending on the date in "DOB". But, for records that had the DOB entered BEFORE I added the calculation to "Age", the "Age" will not update. In order to get it to show the calculated age, I have to re-enter the date of birth into "DOB" This can be burdensome with lots of records, is the…

I recently updated to 7v2 and there was little difference in launch speed on OS 10.3.3. I even manually ran update_prebinding from the command line to try and fix this. Yesterday I updated all of my machines to 10.3.4.... FM7 launch speed increased dramatically. Even on my G3 ibook 500, it launches almost immediately. (It used to take >30 seconds) Anyone else see this or have an explanation? Dana

Newbie question #1: The radio buttons in my database operate sluggishly. I click on the radio button and about 0.5 - 1 second later the button graphic changes to indicate that it is selected. Now 0.5 - 1 second later may not seem like a long time, but its enough time to make the end-user wonder if he/she clicked it correctly in the first place. I can reproduce this delay in a brand new 1 table file with only 1 field. To make things really interesting, if I create a database from a "FileMaker Template" (e.g. Contact Management), I can create a radio button field that responds instantaneously to my clicks (no delay)... as would be expected. Mind you this i…

Not sure if this is a bug in FM7 or a bug within my database - I can recreate this over and over. I have a layout that contains fields from that table (ids), related fields (codes and cost) and 1 related field from a table more than 1 table away (product name). When I add a record to this layout, the related codes and costs get filled in correctly but the product name does not. To make this appear I need to go to define databases (on the relationship tab), then double click on a relationship and then close the dialogues back to the layout and it magically appears!? Any ideas? Emma

Hello- I am trying to put together a calculation that will determine how many days it has been since an invoice has been submitted. I tried the following calculation: DayOfYear ( Get ( CurrentDate ) ) - DayOfYear ( DATE SUBMITTED ) The problem is that it fails when the dates span 2 calendar years. Is there a better way to write this that will give an exact number of days? Also is there a way to display the answer in "X months and Y days". Any help would be greatly apprecitated. Thank you.

I've always just used a simple copy/paste script but the more i investigate fm7 I've realized there might be better options. I'd like to populate a seperate file with a dozen fields from select records. Am i on the right track implimenting a calculation like a "get field" in the script instead? Any rules that i whould be aware of or tips? Thanks Jared

Has anyone else seen this behavior yet? Freeze Window does not work in a script that also calls for printing in the script. See below. Go to Layout [Layout 1] Freeze Window Go to Layout [Layout 2] Print [Restore; No dialog] Go to Layout [Layout 1] Refresh Window As soon as the systems dialog "Printing Page 1 of 1" comes up Layout 2 is also drawn though it should not be. Is it a bug or a feature? In reading some other posts, I may be able to get around this problem by calling the layout I want to be printed in a new window, but call it at a location off screen. Haven't tried it ... but I'll give it a whirl. Hope FM addresses this one real…

I'm not sure why, but using a 'Set Field' command when switching to a layout in one of my scripts will Set the field the correct value, and then leave the cursor in the field even though it's not allowed to be data entered in browse mode. Users can then type in anything and everything they want, and then when the leave the field it saves it. Unless I'm blind, I can't see the 'Exit Record/Request' script step they had in FM6. I could do a Insert Calculated Result in another field (I think, at least), but that seems rather silly.

I am working on a database and have been very disappointed by the speeds I am seeing for browsing records. I finally found one of the sources. The attached pdf is of a "Thumbnail" view that I created. This is done by a relationship between a global and a unique ID for each image. The page consists of 9 portals, each 4 rows high, which show an image. I can scroll this view by changing the global that defines the relationship (with a script, of course). I have been very disturbed by update speeds in scrolling--about 25 secs for an 800MHz G4! I have investigated changing the portals and relationships, and was able to get some marginal speed-ups. But the biggest spe…

Hello all, I should start with version 7 in a few days and have tested the trial version, but I cant make following: When I should convert my old FM5.0 database I think I should start from scratch but its a lot of scripts and saving time I figure about reusing the scripts. I tryed import scripts to the trial version. I can see the scripts but not mark them and not import them into FM7. So my question is: Is it possible import scripts from an old FM5 database or should I convert it to FM7 before I import the script? Or is it impossible? Best regards -Per

Hi -son of newbie question. Like features of FM7 - have created web pages with FM6 and CDML. Have looked at XML and XSL but question is can I use XSL to post info back to FM7 - all the books I have been looking at talk about re-formatting the XML and how happy XSL will make you, but nothing about user interacting with the database. Would appreciate any insight into how to use XSL to pass info back to FM7. About to start a big project - would like to use FM7 but if this XSL thing is a non-starter then FM6 will be used Serc

Hello- I have 2 fields: "Age" and "DOB" Can you please suggest a way to enter a person's age (via calculation,script)into the "Age" field once their Date of Birth is entered in "DOB"? Also, is there a way to calculate what the date would be 30 days after a given date? Thank you...

I have a pop-up menu where the user will select a section by viewing a list of text names for these sections - this is coming from another table of sections which have associated ID's. How can I use the ID of the selected item rather than the text that the user sees? Thanks

Hi, I'm a complete newbie whom is very very confused. I really need to be able to send 1 record (which is also the current layout), By email. I cannot figure out the script! I also cannot find help else where. Many many thanks for anyones time explaining this to an idiot, coops. [color:"666666"]

The discussion in the foregoing post has gotten too hard to follow, and I wanted to post an example of the solution suggested by Espringer. The task is as follows: You are given a database of car models. You don't want to touch that database because it is used by others, and you don't want to add cruft. You have a data of people and car ownership, and you want to display: 1) For every person, the number of cars he/she owns, and which models 2) For every model, the number of owners of that model, and which owners I was stuck on how to do (2). The solution is in the attached sample file. Unzip and open People.fp7. Sorry about the ugly design CarsPeople.…

I am trying to create a customer list data base, but would like to add a page that enables the user to sort records by a zip code range. I've created a layout that has two fields; a 'starting range' and 'ending range'. Can I do this?

How can I have all windows maximzied all the time, instead of having certain areas restore the window to a certain size that's too small to fit all my other customly-added forms?

I know this has been asked before, but I would like to bring it up again in the hopes that some new forum participant can shed some light on the topic. Is there a way to activate a script based upon the results of a field value or calculation. If the answer to a question is yes, I would like to perform a script. If the answer is no I would like to tab to the next question. Can this be done in FM7 or Developer 7? Are there any plugins available that could do this on a MacIntosh Computer? Thanks in advance, Jarvis

When a user performs certain functions, such as adding a new record, I want my application to do certain things, either before or after this action takes place. The only way I know how to accomplish this is to write a script and provide a button that the user can click to execute it. My problem is that if the user selects the New Record option from the Records menu or uses the keyboard shortcut Ctrl+N, my script is altogether sidestepped. Now, I can instruct users to always use my button rather than the menu option but that seems like a rather unprofessional solution to me. What do other developers do to overcome this problem?

I just recently made the jump from version 5.5 to FM7. It feels like a brand new world. Excited that they made all these great changes, but feels like I have to start my training all over again. Anyway, I need some help. I downloaded FBT to take a look under the hood. Looks fantastic, but Excelisys didn't seem to make it easy to add additional NavIcons to the default of 8. I switched to layout view and select "modules." Back in browse, I added a new record which allowed me to add a new icon. Back in "settings" I increased the modules portal to show 9 records. My new icon now appears in the portal. Now, here's the big rub, how do I get it to display on the Na…

Hi all, I am a newbie to FileMaker, although I have some basic knowledge about what Database is.. (DB concept like relational DB .., SQL, etc) I am creating an image library database(which also includes information on those images) consisting several tables. The database is about food. The tables are like <recipe>, <package of food>, <restaurant>, <tableware> etc.. Each records in those tables has one or more images and each images might be around 800k and at least 10000 images total at the moment. I expect around 3-40000 or more images in the near future because we are planning to input much more data in the future. I know that FM7 suppor…

I am looking for some suggestions on which software to puchase to create a catalog that is linked to my filemaker database. I've been doing some research on Adobe InDesign and QuarkXpress and was wondering if anyone has used these programs to create a printed catalog. Any help would be greatly appreciated.

How can I have a value list only list the apartment numbers that are "Empty" ?

Hello~ I have a question. I am in Korea, and I found when I import a file with Korean filename and show the filename in the records(not having problems with importing those files with Korean names) or when I use value lists with Korean text to use in Radio buttons, check box etc., the letters become all &#9633;&#9633;&#9633;(empty squares) . I don't have any problems with typing Korean in fields and They are saved well, and are shown well when I reopen the files. The problems occur only when including importing behavior.. How can I solve this? Currently in Korea, there isn't any vendor of fileMaker. I bought a Filemaker in USA. T…

Hi! I have a table with products and one with orders. Orders are registered in a portal and there are several lookup fields. Can I prevent the user permanently from performing a re lookup? Ideas are welcome!

Using FM7, Win XP, for medical-oriented project. Am using lookup tables pretty extensively in my project and interested in "nested" functionality so that my lookup tables/corresponding fields are smaller/more manageable in the layout section. I will try to use a car database analogy to represent what I would like. Consider the car dealer/seller who has a field in his master database for a car (e.g. to be bought/trader). We'll call it field 1. Rather than typing it in it (e.g. Toyota; Camry; 1987; 4 door;) it is a drop down list or menu (with submenus) that would give him the choice of all the possible cars out there. For this example the drop down menu's first level w…

Hello All, I am using oAzium Charts plug-in to add some graphics to my application. I can use the RGB command or the color names in the line commands of the plug-in to stablish the colors. I added check boxes in a "configuration area" so that the end-user can change the color of each graphic part (vertical bars, pie-charts, etc) based on names of the colors. However, I would like to know if it is possible in FM 7 to use a pop-up field where the end-user can change the color of graphics based on the colors itself, not the text. Or even better the end-user to use a tool like the fill color tool that exists in layout, where a plenty of choices can be made, just click…

How I can disable New Record command in Browse Mode in Layout, is there any script for that, also like to know if it

Hello I am totally new to fileMaker. What is the difference between making database of several files and tables? Is there any limitation to any of them? This might be in the manual , But plz be generous.. running out of time.. Thank you very much~

I've searched the forums and couldn't find this addressed... It seems that I've been able to get sliding up to work correctly for everything except text objects (field labels). As long as the text objects are on one page (don't cross a page break), they will slide up correctly. As soon as they are moved below the first page break, they just disappear in Preview / Print. The other objects (fields, rectangles, lines, etc.) slide up fine, but the text objects are gone. I've attached a simple file to show this working. I'd appreciate it if someone could confirm that this works or doen't work for them as well. It smells like a bug. Of course, I could make the fi…

I am developing a Property Management DB system now I need to incorporate the Invoice part of it. The Db has many units each unit has many different charged like; telephone, rent, parking, water etc... What is the best way to it?

Hi! Two questions: In FM6 I used to create a template file with graphics and standard fields like creation date, serial number etc. In FM7, multiple tables in one file seems like a good idea. But now I have to create standard field by hand for every table. Is there a better way to make a template? Tabs for layout navigation is nice. But I don't want user to end up in that ugly "No access" screen. What is the best approach? Thankful for insights!

I have noticed that as you scroll down the portal on a record, and you reach the bottom, it does a kind of bounce, then starts to screw up the look of the records being displayed. The actual records are ok, just viewing them only. Am I the only one seeing this problem? I also tried to update the V2 update, but it won't work without the CD... and seeing that I bought the program from a download, I don't know what to do... maybe the problem is fixed with the update... any ideas or comments?

Can anyone point me towards a summary of FM7's rules for maintaining the "found set" of records? It seems that if I create two entries in the relationship panel that point to the same table, each can have it's own found set. I rely on this to allow me to work on a different set of records in a script without changing the found set as seen by the user.* But then I discovered that if I open a new window using the same layout (and hence the same entry in the relationships), each can have its own found set. So as I am developing scripts that rely on knowing what the found set is, I sometimes manage to get very confused about which script steps will see which fo…

I'm a slight newbie with FMP. We've bumped from 4.0 to 7.0...yup, a big one. I'm creating my department's database for equipment use scheduling from scratch so that we can take advantage of some of the new things with 7. One area that I would really like to get to work is the 'Show Custom Dialog' in the ScriptMaker section. The 'Show Custom Dialog' has the ability for and 'Input Field' area. This is to allow the user to enter information. What I'd like to do is have the user enter a date of the records he/she wants to print out and continue with the printing script. What I can't figure out is how to make the date that the user entered go into the 'Date' field…

I'm just learning Filmaker & have a question. I have a 2 page invoice I've created & I want to add a 3rd page. The 3rd page is "Terms & Conditions" (legal stuff) but want to have the ability to choose whether I attach this page to each record. In my mind ... I would have a button that would attach/detach this 3rd page. Or a simple way to hide/unhide the 3rd page. The 3rd page is 99% unchanging, static information with a few fields at the bottom that reference the invoice number, the date, etc (page identification). My question is this ..... How is the best way to do this? Would it be smartest to reference the 3rd page externally so it's not copied to each reco…