FileMaker Pro v7 – v11

I am trying to populate a pop up menu from a field but the order in which it appears in the pop up list is alphabetical. I just want it to appear how I typed it in the field in the first place. So I have 2 questions: 1. How do I get this list to appear in the order in which I typed it? 2. What I would really like to do is enter a list of items into a global field and have that list be a pop up menu. The problem is that a global field cannot be a value list. Does anyone know of a way to accomplish this or something like this? My main goal is to have the user enter in a list of information one time and no matter what record they are in that same list will appear in a p…

Whatever I am doing, I do not get as hardcopy what I am seeing on the screen in the preview mode. Nothing like scaling and the like helps. When the printer has finished its work, the "format" on the screen has changed, i.e. becoming smaller or bigger. No such problems with FM5. The other day, we had an update on the virus scanning software and I have updated Adobe reader from version 5 to 6 but no other changes have been made to any software or any driver. Could the virus scan software cause such problems??

I am unable to save printer settings iro paper format. There's no mistake with the printer drivers, as I am using various different printers - including FreePDF. I do need European A4 format, however, FM is always going back to US letter format, even when "saving" the settings I do need in a script. How comes? How can it be assured, A4 is the primary choice?

I am using FMP 7 on a Windows XP Pro box. I have a database of about 125 records, one table, and about 300 fields in that table. One of the fields is a container field into which I have been dragging PDF files from a Folder. I closed the Database, and then reopened it and the PDFs were not available any more. IE. WHen I tried to double click on them, they did not open Acrobat Viewer. I put another 15 PDFs into the DB using the exact same method. Dragging PDF files from a folder. These files (after closing and opening the DB several times) are available, upon double click, they bring up Acrobat Viewer. The size of the database indicates that the PDF…

I've converted my 10-table database from Access95 to FM7 (on Mac), copied all the data into identical tables, replicated all the reports, panels etc etc. (Took me almost two months to complete). It worked for a couple of days, after lots of testing and comparisons with Access results. Now, nothing. I open the database, it goes to main panel, which has several buttons to invoke various reports and other layouts (data entry etc). But, now, none of the buttons responds, nothing happens when I click on them. I close the database, start over, same problem. If I go to the Scripts menu and select a script to take me to another panel or layout, no response. What's going on??…

the database has 6 fields and i want to print 3 fields on 1 label and 3 fields on the label in the next column for a total of 4 label columns per page. i can browse the layout the way i want it to print, as a list, but it only prints from the 1st and 3rd columns. i think the problem is in the way i am setting up the layout mode. I am trying to re-organize slide information in filemakerpro7 and print info on 2 labels per slide, 3 fields on each label for a total of 6 fields per slide. any help would be greatly appreciated.

i am making a database in filmaker 7 but the people who are going to use it are using filemaker 6 and they dont want to upgrade to 7. so is there a way to make my filemaker 7 database work in filemaker 6?

I'm pretty new at FM and I'm making inroads with the aid of a book, but I wanted to run my design and ideas by someone with actual expirence before I started to get (any further) in over my head. It's something of a huge project, so the sooner I actually ask someone who knows, the better, heh Thank a million, Scott [email protected]

I'm at a new job, and my boss just upgraded to FMP 7. He's been using earilier versions, and is getting used to the new version, while I've never even used a database before. I need to find information on container files, OLE embedding, and linking for him. I've been through the tutorial that comes with FMP7, and looked for any information pertaining to these subjects to no avail!!! Please someone help!!! I'm not even sure exactly what I'm looking up!! Jessica

Hi all Does anybody knows if is possible to create a report that combines data from 3 different tables? Explain: I have a database with some tables, three of them are t_tasks, t_services and t_various. Each of these tables has, among others, the following fields: operator_ID, date, job_description, work_hours, cost. What I need is to search for an operator and to produce a report categorized by a) job_description and date, with the data from the three tables. Is this possible? Any help will be valuable... Thanks nlo

Hello, I'm new to FM7 and scripting. I'm urgently need to come up with a event registration database where an attendee would enter their cellphone number for validation. If the attendee is pre-registered, it would display a thank you message and if not, it would proceed to a registration form . Can i create a script to perform this task? Incidentally i'm using the built-in FM7 registration template. Someone from another forum posted this up >.. how do i convert this to FM7 When a Registrant arrives, you should be on a screen which has two buttons (One labeled "Register" and the other "Pre-Registered"). Clicking the first moves one to the registration f…

Is there a way to insert a picture into a layout? I need to be able to have a different picture appear for each database entry, but I only seem to see how you can insert a single picture for all the entries of a table, but not a different picture for each entry. Any ideas?

Hi, Its me again! I am quite new to filemaker pro and I am not sure what its capable of and what it isnt! Anyway, question is: I have two tables. one with People ID, names and address and two with People ID and status. The two tables are related through ID. I want to Find records in Table one(i.e. ID, name and address) with a condition on status(say status = employee) from the Table two. Is it possible to "Constraint Find"? Is it possible to search records from one table using a condition on a field from a related table? I'd be thankful to anybody who'd help me out here. Thanks. Prithvi

I'm new to Filemaker Pro. Just started. I just got 7. It wont open or work with the file which is reason I got it. I want to call tech support. they need an "ACCESS CODE" All I see is the serial number. Can someone help? I called them but was put on hold, a very, very, very long time.

How to allow a superuser to create other users but not to access the admin user or password?

Hi, Is it possible to take user input data and find records? For example, can the user enter a range of dates, and click a button to get records with the date field in that range? Do I need some Troi plug in along with Filemaker Pro for this? Thanks in advance.

I've got a custom dialog box that appears and asks the user to enter a date. It then stores this date in a global field inside my globals table. The problem is, half the time, it fails to update the global field, so the script elements that follow don't work properly. (and the annoying part is that half the time, it actually DOES properly update the global field.) Has anyone else had this issue, and is there a workaround, or is it something I'm doing incorrectly. Thanks.

Hi all! I was doing a list of my books using Microsoft Excel, because I like this software for entering large amounts of data, but I now moved to FM7 because it's a real database program, not a Spreadsheet. But I miss a very useful characteristic from Excel: When you are filling a new record, the program Autofills that I write with the data of all the other records (the data of this concrete field). In example, when I write "Grisham, John" for the first time, if I have another Grisham Book, I don't need to write the whole name again. I start to write Gr..and Excel autofills the rest. Maybe I have another book written by, let's say, Gritton, but when I write Gris…

I'm not the sharpest knife in the drawer when it comes to this database stuff, so it gives me great joy whenever I master something I've been struggling with. I think I have figured out PDF storage for FM 7, at least some of it. I've been developing a work order database for my shop. LAYOUT ONE holds the usual data: Order Date, Contact Info:, task description, etc. LAYOUT TWO: is a columnar type layout that just lists TASK DESCRIPTION. LAYOUT TWO also has a transparent button overlaid onto the field TASK DESCRIPTION. This button activates the script: GO TO LAYOUT ONE. LAYOUT TWO IS the active layout. When you see a task you want to per…

I understand if FileMaker is too lazy support PostScript fonts, even though it's really the only program I've ever seen in my life that won't support them, and even though it means that hundreds of dollars worth of fonts are now worthless. That's fine. But I've inserted an EPS into a print layout, and when I print it shrinks the size of the EPS, no matter what size it was before I inserted it. Needless to say, this is frustrating. In my v6 version of my client manager, I could insert company logos into my invoice layouts, etc. Is that chapter of my life now closed? You should not lose core features when buying an upgrade.

Question: 3 (or more)fields on 3 (or more) lines; I would like when I go to print the record (i.e. preview mode) for there to be no blank line: Example: field 1 on line 1; field 2 on line 2, field 3 on line 3; if field 2 is blank, I would like for field 3 to move up to line 2; I think a calculation field would work best but I don't know the syntax. Please advise. Thanks, Doug Lazenby

Hi there, I've been trying to implement some Filemaker databases for our small office of about 5 macs. Anyways, not sure how to fix this, but when i open one file, it says: "Filemaker cannot share files because another user is already sharing files using Filemaker Pro on this computer." So, what do i need to do to fix this? Any help would be great...

Hi, I have a main layout with different buttons say- General Info, and Address. I have two other layouts with the "general Info" and "address" respectively. When I click on either button on the main layout, I do not want to skip to the appropriate layout. This is what I am currently doing. I want the appropriate layout to open in the main layout itself, say at the bottom half part. How do I do this? Thank you.

Hi all, I desperately need some help. I have a group of four computers which are connected together as a basic intranet, no network server, just an apple airport extreme and sharing of files between the computers. Unfortunately money prohibits too much else. Now I have File Maker Pro 7 and need to allow users access to the databases which are being held on computer A. Computer A has the file open and I have Sharing over the network set to on, with the IP address of computer A as the given IP. When I try to access the file from computer B, I can see computer A at the correct IP address, but cannot see any of the files when using the Open Remote option. Is it possible …

Hi all, this is my first post to the forum. I've just started using Filemaker Pro for developemnt and have come across my first problem. Luckily I managed to solve the others but am just stuck on this issue. I have defined a database for a billing program which has 18 kinds of charges on it. e.g. Creative fees, Recce, Air Travel, Food, Production etc. Problem 1: Depending on wether the bill should include the charge or not, the user needs to have a list of these items on the first screen and he checkmarks only the ones he wants. Then a bill entry screen gets generated with only those fields available which the user selected in the first screen. Is this possible…

Has anyone noticed that when you constrain a found set in FMPro7 and the result is 0, for some reason you are still left with the same found set that you started with? Also, has anyone had trouble in FMPro7 using the Get(LastError) scripts? I can't seem to correctly execute in FMPro7 the same scripts that worked fine in FMPro6. Thanks in advance.

I've been having a problem with printing a record from a web browser. I want users to be able to access my database, and to be able to print out forms that are horizontally oriented (landscape view). I'de like to make it as simple for the user as possible. Right now the default page set up for printing is the vertical orientation. Is there a way to have file maker tell the browser window to change the page set up to the landscape orientation... actually is there even a way to make some kind of script (that i could attach to a button) that tells the browser to print, instead of requiring the user to go to "file" and then "print"? thanks for your help Je…

I have spent a lot of time working with FileMaker this summer, but I realize that I have no inkling about its total capabilities. I need to analyze the data in my database for my research, but I can't seem to figure out how to create summary pages that are relevant and meaningful to me. Please help me. My project: I am researching a specific minimally invasive medical procedure to determine whether it is more beneficial than the current gold-standard open procedure. My data: Approximately 100 patients with a brief patient history, a description of the operation, and follow-up information. This data is in about 90 data fields all in one table with nine dif…

Hey all, I've been wondering why FMP7 added accounts without also adding 'account specific global variables'. In other words, why don't users have their own scratch space? It seems that all the multi-user woes are intact... using 'lock scripts' and the like. But by adding non-global scratch fields to an "accounts" table (containing all the active accounts), shouldn't I be able to make a relationship where "get(accountname)=accounts::accountname" and thus access temp records from a particular user? The first problem of course is that in the above relationship, "get(accountname)" needs to be an existing field.. can it be a global calculation? I'll try this st…

Hi, I need to export into multiple files (several thousands, xml-files for flash-application, one by one record). "Export field contents" works fine within a loop, but it overwrites one and the same file over an over again. Is there any chance I can control the export file's name by a field's content of the active record? Any other solution at hand? TX a lot!

Does anyone know of a solution to track working hours? I would like to use a simple solution where the user login on his/hers account and register the working hours. Does anyone have any suggestions how to do this solution or is there a solution ready to use today? by the way, i am using FMP7.

I have a database that I give out to quite a few people and I want to setup accounts that expire every year and switch to read-only status. Does anyone know how to do that? Thanks! Randall

I am going to post the layout as well as the preview so you can see what I'm talking about

Hi-- I have upgraded a database from 6.0 to 7.0 and am having a problem with a date calc field. The calc is supposed to handle a date which is entered in the format: 5/03/03 11:51:24 PM EST And have the result of date: 5/03/03 The calculation is as follows. The first part handles dates which were entered in another format before the present format had started to be used. The second handles the current format: EDITED (sorry about that!): If(MiddleWords(Enter Date;2;1) = "Feb" and GetAsNumber(LeftWords(Enter Date;1)) <= 15 or MiddleWords(Enter Date;2;1) = "Jan"; GetAsDate(If(MiddleWords(Enter Date;4;1) >= 24; Case(MiddleWord…

Is there any way to work with a plugIn that updates a field

In sorting in valuelists all the words strating with '_' and ending with '_' are sorted out first based on the character after the '_' and sorting of all words with first character as an alphabet are sorted after that. If words are :-- _Consult_,Consult 1,Consult 2, _Hospital_, Hospital 1, Hospital 2 I wish to do the sorting to bring the result in following manner:-- _Consult_ Consult 1 Consult 2 _Hospital_ Hospital 1 Hospital 2 Whereas What I am getting is:- _Consult_ _Hospital_ Consult 1 Consult 2 Hospital 1 Hospital 2 Plzzzzzzzz help

I have noticed in FMP7 that creating a script doesn't seem to be an automatic action. In previous versions, once the root actions have been performed (i.e., page setup, sort, find, etc.) using Scriptmaker to set up a script would establish the necessary script steps to repeat the desired script. Not so in FMP7. Nothing seems to be recorded when creating a new script and I can't find the requisite actions in the scripting menu. Am I missing something or has Filemaker, Inc. left something out?

In a database I have a bunch of records about people, and each person is designated by a unique ID code. There are multiple records for each person, though (each record represents one person for a particular year). What I want to do is sum the data over all the years for each particular person in a new table (or a new database). Anybody have any ideas? Maybe a script?

I am "experimenting" with the new features in v 7, esp in regards to not needing to generate multiple/complex keys to set up relationships, but I am kind of stuck, and I think it is because the environemnt is so "visual", whereas I could work the problem out as a series of join statements in SQL fairly quickly... Anyway, I have an Employees table. I have a Projects table with multiple fields for "People" (yes this needs to be taken to another table). The employee name goes in these fields...say three per Project... back in a Layout showing the Employee info I want three portals... each one showing a list of which projects they are in slot #1, #2 and #3 in respectivel…

Hi, I am new to file maker pro. I have 3 tables- People, Teachers and Courses. People and Teachers are related through a common field "Client ID". Teachers and Courses are related through a common field Course ID. A teacher can have more tha one course ID. I want to search for course details(from course table) of teachers who are Professors, i.e status = Professors(in teachers table). I tried using Constraint found and I have been unsuccessful. Could anybody help me out? I would also like to know if its possible to search for course details from Courses table, using a field from People table, say Last name = Jordan(Courses and People are not directly related) …

I have a database in which I am trying to summarize and analyze data. Here is what I'd like to do if I could figure out how to do it: I have four specific symptoms (leg pain, ulcer, gangrene, ischemia) that require the same surgical procedure. I have a hundred or so patients with one of these symptoms. I want the database to count how many occurences of each symptom appear. I would like a layout with a table that says: leg pain - 25, ulcer - 17, gangrene - 22, ischemia - 28. Or something like that. This is one of many fields that I'd like summarized similarly. Is this possible or do I need to put the info on excel.

I converted a FMP database which consisted of more than 10 files, from version 5.5 to 7.0. The conversion created a lot of problems and issues. One of the problems is that a field (in file : use a popup list that is designed to use an external value list in a relational file (file A) that shows related values only. This value list (in file : works fine in the Browse mode, but does not show any value in Find mode. I didn't have this problem when the files were in version 5.5. Has anyone seen this problem before? Do you know how to resolve it? Any comments will be appreciated. Thanks!

Is it my ignorance of the program or are these 2 things bugs. 1) When I add a color to the list of custom colors it does stay there after I have closed and re-opened the program. 2) Same problem when I add a page from the help file to my favorites

Howdy, Is there a way in FM7 or FM7dev to temporarily bold/highlight keywords in found records after a search? Example: if a have a bunch of recipes and I perform a find for "onion", on all the found records containing "onion" can the word "onion" be bolded temporarily to help the user find the word? Another example is here on the word "headache": http://66.102.7.104/search?q=cache:fe2XC...520headache.pdf headache pdf&hl=en Thanks a bunch

Can anyone tell me the maximum number of layouts possible to store in FM7? If there is a maximum. I looked for it on the FM site but didn't find that info.

Hi, I've been using filemaker for over a year with great success, but there is something I find myself wanting to do more and more often. I've never been able to imagine how to implement this request so have worked around it, but I thought I'd ask you pros -- maybe I'm overlooking a basic feature. I'll explain by using the db I'm working on now as an example. I'm making a list of all the brands and varieties of tea available in Chicago supermarkets. There are attributes which all teas of a brand share, such as the store where it's found, the packaging type, and then there are attributes unique to the variety of tea, such as its name and the package weight. What…

This worked in FM 6 but it just refuses to in FM 7.02 When I do a find on a Calculation Field, using > or < the find comes back with no matches found or the wrong results (>3 would give you 1,2,3). Is this a new feature that I overlooked? This application is running on FM server 7.

I know they beefed the securtiy features in 7 but I was wondering if theres any logging.. Example User_______Record______Field They edited______from____________to --------------------------------------------------------------------------------------------- Me_________1___________Name______________Myself__________Me (Sorry for the _______ The forum takes out spaces) Anything like that going to be in FM7 or Server?

As much as I like the "ScriptMaker" interface, I was wondering is there any way to edit the scripts in filemaker with a text editor. It is easy to make sweeping changes when using a text based method. (e.g. Set Field on 10 fields when copying data from one table to another.)

There is a post on FileMaker Cafe at www.maclane.com/cgi-bin/ultimatebb.cgi that is called "To update or not to update" It has some good information about updating. But the best reason to read it is it will really make you laugh. It made my day and I just wanted you to know about it! Who said a database can't be fun! Bill

What's the best/most efficient means of finding the next highest number (i.e., highest existing value + 1) in a DB for which not all records have a value in the given field (which I'll call #Fld)? i.e., this is not a serial number; Of thousands of records, only a few dozen will have a number assigned in #Fld. This number must be unique and should be assigned in sequence when it is needed. (There may be gaps in the existing numbers.) I've figured out a way to do this, but it seems unnecessarily clumsy to me and I suspect that there is a much more efficient way to do this. What I'm doing now is (all scripted) find all records containing a value in #Fld, sorting de…

I've created a DB for our school that stores student files. In order to keep the DB as streamlined as possible, I've stored the various student files as references. Here's the problem: the folder that contains the actual files is a shared folder on a network. When users log onto the DB I've created, and try to open the referenced file, they get a 'file not found error.' The only work around I've found is to tell the users to make sure they've logged onto the network and made a connection to the folder in question. Most of the people who will use the DB I've made aren't that computer savvy. Is there a way in FM Pro 7 that I can create script that will log onto that folder …

Basically what I have is a Notes field, and some formatting buttons along the top. (Plain, Bold, Italic, Underline). I use one script for Bold, Italic, and Underline with the style as the script paramater. This is what it does... TextStyleAdd ( Middle ( text field ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize ) ); Get ( ScriptParameter ) ) The problem is, If I've selected styled text (and only styled text) I can't get filemaker to remove the style from it. It does work, however, when I select the styled text and a single (or more) character(s) that is not styled. (Script paramater "AllStyles") TextStyleRemove ( Middle ( text field ; Get (…

Hi folks, I'm fairly new to Filemaker Pro and have been busy creating various databases for my department at work. The database I'm working on right now is basically just a way for myself and the other 3 coworkers in my department to fill out a daily production log for each of the projects we're working on. You can see the layout for the daily production log with a sample entry here: Daily Production Log Sample Each of us can access our table by clicking our name in the top right corner of the layout. We will be creating a new record in our table each day, and each table should be sorted by entry date. The data entry part and configuring the 4 separate…

I created a FileMaker solution for tracking and scheduling of jobs to equipment. It works well. However, the company recently purchased an SQL server and a heavy application that creates job tickets, inventory, shipping and data collection. The scheduling portion of it stinks! They would like to continue to use the FileMaker solution for shceduling. Currently, users are then forced to enter common data twice (once for the SQL application and once for the Filemaker... i.e. job number, due dates, quantities, etc). It is nothing more than- I have no idea how to use the ODBC setup and pull data from the SQL database into FileMaker. Is there a primer? Is it reasona…

I AM USING FM7 (this used to work in FM6) I have (2) databases During a script, i find one record in 1 database the script then goes to the 2nd DB and runs an import records script from that databse (subscript) But it imports ALL of the records not the "found set" of records?:? How do i get it to just import the found set (in this cast just 1 record) and not all the records?: Thanks Wade

Unlike Mac users, I'm having a problem where I need to stop the mouse wheel from changing records. Is this possible, and if so, how do I do it? As a second issue, (which would negate the first) is it possible to trigger a script/action to happen when the user switches records? (I need to force certain locked records into a layout where users cannot modify them) Thanks.

I'd like to create a field which will return a 'Y' or an 'N' based on the existence of a value in a field in a related record. ie. If there is a record in related table X which has the value "1003" in field 'UID' then "Y" Can anyone help me out with this? 'preciate it. Joey

Need a lil help here, I am using a button to call a new window (and create a related record) for the user to enter data into, the data entry window has 2 buttons, 1 to save the data and close the window, the other to cancel the data entry (delete the created record) and close the window. I have realised that an errant mouse click will leave the data entry window open but hidden behind the main window, is there a way to keep the focus on the data entry window until the save or cancel buttons are pressed? 'preciate it

This USED to work...I could have both FMP6 developer AND FMP7 Developer open.....now I can open one and when I try to launch the other.....the splash screen shows up then it stops. I have deleted the plists, repaired permissions and I even ran cron scripts.....any ideas? Greg

About to create a solution for a client in the Security Industry. They desire to share the database solution among 8 network users. Should I go with the tried and true Filemaker 6 OR go with the new Filemaker 7.......any suggestions would be appreciated.

Ok I have two tables, one with courses, which includes course code and descriptions, and one with coursePerSemester, which includes the courses that are recorded for each semester. Then I have a student file. I want to be able to using the semester number, get the course codes, which it does, but also the course names. When I link them, the course codes show up fine, however the full names of the course do not, just the first course code name. Any ideas?

Hi can anyone help? I am trying to export data from filemaker pro to a Windows XP machine, and can't find an ODBC driver to do this. Can anyone point me in the right direction please Thanks Anne

I am trying to customize Business Tracker and need to add a script to automatically update the inventory of an item when an item are sold. I noted that BT does not have this built into. Has anyone created such a script or have any advice on doing so? I saw a similar thread re FMP 6, but would like specific info on BT in FMP 7 if available. TIA

Hi all, again I apologize for posting DevCon issues in this forum. I have suggested to the admin that he create a DevCon forum. If there is one and I'm not finding it, please let me know. Anyway, it turns out there's another resort adjacent to the Desert Ridge, called the Marriott Canyon Villas. I was told by someone at the resort that it's about 10 minute walking distance from the conference rooms. But if you don't want to walk, a shuttle bus runs on a regular schedule between the two resorts, so between walking or riding the shuttle bus, renting a car would not be necessary if staying at this resort. Note that people who stay at the Canyon Villas get full use of th…

Hi there, I am relatively new to FMP, and am just beginning to work with scripts and relationships. I currently have a database with over 900 records, and I now need to assign serial numbers to my records. Is there a way to automatically add serial numbers to existing records? Would I use a script, and if so, what would it look like? Any help would be greatly appreciated! Emily

yo, brucer i went to my retailer and they told me they would supply me with a copy because i showed them my receipt. so that solves the problem brucer, i think you are rude if your not willing to help me then don't! i don't need ur other comments my conscience is clean. rogermax thanks again for the help. im still waiting for updates from my agent regarding the solution that u binded by the way i bought filemaker developer already. i still owe you one! thanks

All of my db experience is with MS Access (a number of years ago). A few weeks ago I downloaded the FM7 demo and I'm trying to decide if it's worth the price. My initial reaction is that FM is lame compared to MS Access but there's a good chance I'm just not familiar enough with FM. Of course, I'm a Mac-only guy now so Access isn't an option. Is FM as powerful as Access? Has anyone else made the transition with success/satisfaction?

We have a large investment in FileMaker (currently 5x-6x and Server 5x). Due to the age of our databases, many have repeating fields. How does FM 7 handle these? Does it simply move them into a table or will we have to deal with them before conveting to 7? We have 275 files,five servers, sixty clients on a mixed Mac-PC platform running OS 8.6 to 10.2.x, Windows 95 to XP pro (quite the gamit). Version: Developer v6 Platform: Windows 2000

I had just migrated to Filemaker Pro 7 and is using network share off a dedicated client. What do you guys & gals do to backup the local database ? I had just used up my complimentary support with FM and they say they dont support command lines or batch files. I basically want to use the scheduler to shutdown FM, run a scheduled backup from my backup exec server and start it first thing in the morning. Im a newbie with FM by the way, so any help would be much appreciated.

Firstly, I tried searching on here, but honestly, it's a miserable setup to find anything, so sorry about the possible double post... I'm trying to search a timecard table that includes a timecard number, producer(name) and a date weekending field. My script selects all records, sorts by date/name, then goes into find mode. After typing a name to search for, it displays the results. The problem is, that the results will only be displayed in ascending timecard number order. This will happen no matter how a sort the records before the find. Unsorting the records will produce the same result. 1. Is it possible to pre-sort the records before ent…

I am trying to use php on one system to connect to another system that has ODBC sharing enabled. It seems that either the parameters I pass into odbc_connect (a php function) is incorrect or I don't have ODBC correctly enabled (can u just go to Edit->Sharing to enable ODBC? ... or do I need to install an additional ODBC driver?). I use the following in my php script uses: $DSN = "Driver=FileMaker Pro;Server=server.name;Database=the database.fp7"; $connection = odbc_connect($DSN, "username", "password") or die("Couldn't connect to database"); (where server,database name, etc has been changed) Please help me figure out what i…

is there any way to pass variable data to a DB via a URL? for example: this creates a new record: http://domain.com/fmi/iwp/cgi?-new=&-omitstate=false can i pass a variable in the URL so the DB picks it up and places it in the proper field: http://domain.com/fmi/iwp/cgi?-new=&-omitstate=false&-name=bob Im stuck.

I'm laying out a 300 page manual in Filemaker 7. The type of information in the manual requires specific pages for specific information. Is there away to force page breaks, and then view those breaks for adjectment.

Hi All, I'm new here so aplogies for the dim-wit question, I've been searching the net looking for my answers and have so far been unsuccesfull. I am trying to set up a version of FM7 client to run on a G4 running OSX (Panther). What I want to do is allow someone to FTP a new database up to it and for it to be hosted. In order for this to happen they will need to close the DB first, FTP it up and reopen it. I have the FTP server working but can't find any way of allow a remote user to close/open databases. The names of the databases will be fixed so I can hard wire the names. I have seen the Troi plug in that allows scripts to be triggered but i…

How do I consolidate data from many records. There is a folder that receives XML files from a FM aplicaton located in several places. Each aplication saves a xml file with its name (calculated field). That folder would contain: Day 1: place1invoices.xml (23 records) place2invoices.xml (39 records)

I have a client who wants to email invoices to clients. I need a plugin to automate the creation of a PDF file from a report which can then be attached to an email and sent automatically. I know there are several email plugins and I saw one Windows-only plugin for creating a PDF. I need a Mac version. Anyone know of a plugin or have any alternate ideas?

hi folks, this is my problem i bought filemaker pro 7 but the cd was sat on by my wife....(long story)... and it broke luckily i saved the license key now i just formated my pc and i don't know where to get a copy of the filemaker pro installation files do you guys know where i can download one thanks a lot... i know that you guys will reach out to help me. and another thing if i download the trial at the filemaker site will my license key work with the trial version?. thanks again. GOD BLESS YA ALL!

I had posted a similar question under relationships, but this is a broad question, so I think it's appropriate in this section of the forum. I have a table of people, for a fundraising db, and a table of events. Each event needs to be tied to a person, as it contains their payment info, etc. There need to be many events per person. I want to have a layout that displays all events per person. I am planning on using a portal for this. However, I can't create new events on that page (all events), as they need to be looked up. I did this by creating a field on the Events table which is joined to the Person serial. On my layout for creating an Event, …

FileMaker 7's Sort Records dialog includes an option to "Reorder based on summary field" which can be applied to any regular field in the sort" What does this do?

I have a find mode problem. I have created a database to store collectors cards. If the user clicks on the find button it will bring them to a find layout and I run a script for them to do their search. The problem I am running into is I want the search for one field to be constrained only to what they pick. Example I have a field called series and I have a drop down menu so they can pick the series. The user can also add a series that is not in the database. If the user picks 'series 1' it will pull all the series 1 and series 11,12,13,14,15,&16 cards. So I thought I would put in an if statement so that if they pick 'series 1' it would constrain == to 'series 1…

Can more than one instance of filemaker be open in windows and filemaker 7.0 ? I would like to open two instances of filemaker, one for each project I wrote. The customer would be able to close one with the "Exit Application" script easily without affecting the other. Customer could switch between them with ALT-TAB easily. Much more effective than worrying about switching between windows, or leaving pieces of a project open when it should have closed. Any ideas? Thanks. Joseph

Hey all, I'm trying to do something very simple, but can't figure it out from the documentation. In a project folder, I have a FM db and a folder containing images. The db fields includes "image" (a container) and "image_path" (text). The images were imported as references. When I copy the project folder over to another computer, it breaks, naturally, because the stored reference path changes from "file://Drive 1/etc/project/images/picture.tiff" to "file://Drive 2/etc2/project/images/picture.tiff". I can easily modify the text "image_path" via calculation to point to the new file, but have no idea how this should work with containers! How does one migr…

Just wanted to let you know that Alpha Software has released version 6 today with its own web application server and ability to interact LIVE (not import) with ADO / ODBC compliant databases, like Access, Oracle, SQL Server, and MySQL. www.alphasoftware.com or HERE for their slideshow!

Is there a way to ensure a field is displayed in a certain format? ie. if you enter a phone number 8765552212, it displays as (876) 555-2212 appreciate the help in advance.

I want to use customized graphics for the scroll bar "for a uniform appearance" But I can't figure out how to script the "up" and "down". If my portal shows 10 records, how can I see the next or "11" etc. record and then go back up if I wanted too? I'm pulling my hair out on this one. "Customer doesn't like the look of the stock scroll bar, want's it to look like my "os-x aqua" that my layouts are designed as. If anyone can land a hand, I sure would like to end the madness. Thanks

hi there I want to import records from several files automaticaly,the number of files is varible. anybody knows how can I achieve this? thanks M!

I am trying to make a field automatically extend to the next page in Preview Mode if there is text in the field that is too long to display on one page. I have tried selecting "Allow part to break across page boundaries" option in the "Part Setup..." window, but that doesn't work. It still won't display the information that is too long for one page on a next page. The page has a header and a footer that I want on every page. Thanks.

sorry if this has been asked a thousand times, I can't seem to locate the answer in my searches though I've seen the question asked before when 7 first came out. I want to develop a fairly simple web solution in FMD7 but just like I did in 6 using CDML, i.e without the hokey IWP interface. I have developer 7 & 6 and far prefer 7, but I can't seem to figure out if I need server advanced to develop custom web solutions. I'm not going to serve, only develop then host with a pro host company. I can't find anything in the dev7 materials about custom web, other than you need SA to host it. Can I develop in Dev7 and then send it to the hosting co? How would I pr…

My spreadsheet report is visible in Browse and Preview modes. When I try to print this report only half the page prints in landscape. When I check my print preview only half the spreadsheet is visible. If I go to page set up and select landscape to print the portal expands in Layout mode to include all the data I need to print. When I then go back to print preview only half the records show up and this is how it prints. This never happened in version 6. Help! does anyone know how I can print my report?

Hi guys, To back up fmserver we have found that we have to use the command "fmserver pause" before the backup will commence. Once backup is finished we then have to use the command "fmserver resume". How do you guys manage your backups? Been thinking that perhaps we have to create a DOS script to do this and have it execute at say 2am? Sorry - I am running FM6, Server 5.5 and XP for this question

If a user clicks the Cancel button in the Status area during a scripted Find (paused), is there any way to have the script take him to a different/specific layout instead of dumping him in an inappropriate place? (And yes, I want to keep the Status area "live" in this situation.) This script traverses two diff layouts, and the problem arises if the user cancels on the 2d one--which has only merge fields and no navigation options (other than a "cancel everything, go home, and start over" button). I'd rather be able to take them back one step/layout since it usually means that the found set they got isn't what they wanted/expected. Thanks, RDecker

All I want to be able to do is to import/export simple chemical formula - which involves the use of super/subscripts. Filemaker appears to not be in the mood to play nice. If I take a set of test formula and export using the xml option, all super/subscript information is lost. Then again, I already have a field where the formula are formatted using HTML (useful when generating web pages). I can export them, convert the &lt; and &gt; to < and > so that the tags are proper but FM refuses to import them - it knows nothing about <sub> or <sup> from what I can tell. Clearly, it should be possible to import/export formatted text but …

Hi, ive been reading though the forums and cannot find the asnswer to my question. Anyway, I have two tables. One is ' [color:"blue"] Invoice ' and the otehr is ' [color:"blue"] Line_Items .' The [color:"blue"] Invoice table has a value of [color:"red"] id that [color:"blue"] Line_Items is related to. Now, here is my problem. I have a layout that is owned by [color:"blue"] Invoice and it has a portal to enter in the invoice lien items. In the [color:"blue"] Invoice table i have a field called [color:"purple"] total . That field has a automatic calculation of ' [color:"#666666"] Sum ( [color:"blue"] Line_Items::Amount ) . This calulation only works at …

Is there any way to export files with header names?

I'm a newbie using trial version to see if I can replace Paradox. I'm creating a complex directory which includes several fields which are empty for some records. If the field is empty, I want to hide the field name (which seems to end up as just text on the layout, rather than attached to the field itself). I thought "slide" would work but it just controls what is in the field boundry. Anybody know how to do this? an example would be "Business Tel" followed by the Btel field. I don't want to see the label if they have no busness tel. Thanks, Ed

Is it possible? Or once I've set it I'm stuck with it and I have to make a new table and import?

Hi, I have a set of 'find results' that I need to manipulate further, and I am not sure what the right direction to go is. Right now, I am generating an invoice by "period" selection. (User chooses the "period", and FM prints a pre-formatted invoice). My application is a modification of the FM TimeBilling template, and uses "Time Billing" the and related "Line Items" to produce the report (with a few lookups). The report is sorted by "Project" and produces the total of hours and a subtotal by project on the fly. But if I have an employee who has multiple timesheets within a period and for a specific project, then the employee is listed multiple ti…

What is the proper way of creating a nice crisp graphics for icons?? Some of the problems I'm having are: -The inserted graphics dont show up during printing when they're sized down. -The inserted graphics print with a white background. Thanks, Mariusz

I am new to fileamke pro. I have a database with multiple tables two of them being a students table, and the other being a classes table. I have these two tables being related to each other via section where each student is in a section 7A, 9B , 6C ect. The student table contains various information such as names addresses ect while the classes table containst information of various classes offered. In the classes table, there are fields for evaluation text and evaluation criteria. I have a layout which displays these and then the student name based of section. The problem that i am running into, is that it will dispay the correct student whith the correct…