FileMaker Pro v7 – v11

has anyone tried to develop a collaboration solution product based on FMP 7? or just a collaboration platform that includes task assignments, project tracking and processes... instant messaging (is it possible?), sharing files (this should be possible?)... etc. if so, how's the outcome compare to commercial products... is it as good as it can be like those good ones? easy to develop? much limitations? or easy to use? thanks~ p.s. i am thinking of developing a complete collaboration suite accompanied with database system with FM7... should i go for it or...? :-D

Hi, I've been trying to figure this out for a while now... I have Clients and Events tables and they are related through Registration -which has EventID(primary key from Events) and ClientID(primary key from Clients). Each Event has an Evaluation from different Clients. Currently I have different Evaluation-session tables such that a set of EventIDs with the same Session Name(from Events table) are in same Evaluation table. So each Evaluation table has a global field which is Session Name and is related to Events through this. On a layout based on Clients, I have a portal showing "Registration history" of that Client, i.e Eventcode and other fields fro…

Heya, I have a database that tracks tasks. Our SQL server holds employee info, but I've imported all of this into another DB. This second DB has the fields Last Name, First Name, Employee Code, Office, and Extension. I would like to pick, from a list that shows last name, first name, and when I make the selection, I want to see the code, the office and the extension get filled into the appropriate fields on the tasks DB. I've been able to create the drop down list, with last name/ first name, but haven't been able to get the other fields filled in when I make a selection. Again, I'm a newbie at FMP, please be gentle. Thanks in advance, D…

Hey folks, I've been pulling my hair out trying to get this to work. Here's the prob. I have three drop down lists with around 10 choices each. Depending on what is chosen on each list, I want a value dropped into a fourth field. i.e. Type -this type selecting this should auto enter the number 1 -that type selecting this should auto enter the number 2 -the other type selecting this should auto enter the number 3 etc. there's three of these and i need each choice made by the user to automatically enter the related value into the fourth field, each one after the other, so that the values from the choices are strung togeth…

i have a calculation field that displays the balances of some numbers. the criteria are as follows: greater than 0: green smaller than 0: red equal to 0: blue now, TextColor works perfectly. however, if you happen to use "Number format" on the field, for example, adding a leading "$" sign. the TextColor function will fail to work. please try yourself and see if it so for you too. I am running on Windows 2003 enterprise server, Filemaker Developer 7v02. should this be considered a bug? but not being able to use the leading/trailing signs and number formats with TextColor is a great imperfection...

I'm wondering if fm7 doesn't lower the DPI of images or something atleast on it's conversion process to fm7. My solution in fm6 and below left the image files at 1.06 GB. after converting it to fm7, I was shocked to find the file the images where in is at 300 MB. I like that it's storing them more efficiently, just would like to know how it's doing it. As long as it's not standardizing the images down to like 72 DPI and lowering the color depth as my solution needs to have the images print nice and be capable of doing higher than 72 DPI. Thanks for the info!

I'm new with FMP, so this may be a silly question - I'm working on an employee database and want to display the employee picture (along w/their personal info.) using a container field. Do I have to insert each employee picture or can I generate a script to automatically populate the container based on url location of the picture. All pics are stored in the same directory and the pic name is username.jpg. I have the username in a different field - so I'm hoping I can pull the picture name and url and somehow populate the container field.... Any advice would be great!

I have created an asset tracking database which I need to create a report for. I have a table containing an entry for each asset no, the equipment type that it is and the make and model. I then have a second table containing an entry for each asset tracking entry. This includes a field for the date of the movement and a field with radio buttons containing 6 options for the location of the movement. What I require is a report telling me the totals of a particular type of equipment, make and model which are deployed, tested etc (the options of my 6 locations) at any one time. The report would have to take into consideration where a particular piece of equipment was at…

I am writing a bookkeeping application and would like to display balances outstanding for invoices overdue by 30 60 90 day periods. What I would like to acheive is have 3 fields 30 60 90 which dynamically calculate balances based on age of invoice and result is balance of those invoices. Can anyone point me in the right direction

I am trying to create a database for an adoption project, where it will hold thousands of people with their DNA profiles. As new people are added it must check all records to find matches based on their DNA profiles. Is this possible to do with a real-time calculation using a cartesian product of 2 tables, or does this have to be a script that loops through records? Any ideas are appreciated.

I have been trying to do this script that will print a document for a record but it will not work correctly. What I want it to do: User on a data entry layout in browse mode, clicks print button. Window stays on this layout (from users view point) and a print dialog pops up. They choose the stuff in print dialog and click print. Document prints. During this entire process the user should never see any other layout on screen except the data entry and the print dialog. What script really does: When the user clicks the print button on data entry screen, the layout that is being printed, is displayed in preview mode in the window while the print dialog is …

Sorry if i'm posting this in the wrong forum, I haven't been here for a long time and I'm not sure where this fits exactly. I have a simple database which will track "meeting minutes". It will be used by three managers with about 25 employees each. I created a database with three tables: MeetingMinutes, Staff and Attendance. I can't seem to figure out a way to flag Staff members with a checkbox in the Attendance table so only those that attended a specific meeting show up in a portal in MeetingMinutes table. To be more specific: A manager enters text into several text fields containing the minutes in the MeetingMinutes table. The manager then goes to the Atten…

I'm trying 2 figure out how to store a graphic in a repeating global container field. If you refer to this link http://www.fmforums.com/threads/showflat.php?Cat=0&Number=113016&an=0&page=37#113016 you will understand more what i'm trying to achieve. I just can't get the image to load and i know I must be doing something fundamentally wrong even though i've done it once before several weeks ago. Can someone help Regards Dave

Does someone know if it is possible to make a database linked to one record so that each record have the same database linked but with other values. Because if i make a hyperlink to another database i have to make each time that i make a new record a new linked database. Could someone help me PLS THX

I have a portal setup for a card collectors DB. I have it setup with different colors to reflect the different options the user has to pick from such as 'own', 'trade', & 'sold'. When the user selects a new record for the portal I want the new record to be first in the portal. I want the sort to be 'own' first, 'trade' second, and 'sold' third as they are listed in the portal. The 'own', trade',& 'sold' are listed on the form as checkboxes, so they either have a value of '1' or '0, zero'. I have tried setting up the order through sort portals, but it never comes out right. Is there something else that would setup the portal to list the cards in this order? Ano…

I have written a script in FM7 to print a job to the network printer. The printer has 3 trays, and the script should print one page from each tray. However the script seems to lose its settings after a short period and starts printing all 3 pages from just 1 tray. How can I write the script so that it does not lose its settings?

Records created via a portal (quote records via relationship from a source record) started to vanish today. I went troubleshooting the relationship (both in the same file), and found that it seemed set up right, and was still treating old records correctly. Records created directly in the related quotes table seemed to be stable. (The solution had been in use for months, one of my first FM7 creations.) So, I created an external table, and had it import all the quotes table records. I set up an "allow creation" path in my main file to the new table and then redirected the portals in my source layout over to the new external table, to see if it would help. I went …

By default, I need to input Date by entering DD/MM/YY. Can I change it in another way, eg. YY/DD/MM??

TRYING to print a billing statement with two portals: invoices and payments. Each portal is 100 rows to allow for plenty of activity during the month. Everything is fine except the second portal. The headers above the second portal properly slide up to near the bottom of the first portal. But the second portal itself starts after 4 or 5 blank pages. Yes, sliding is turned on for all necessary objects. Yes, the body is reduced to the point that it's touching the lowest object in the body. Is this yet another bug? Thanks for any tips. --Frustrated.

How do I get a found set from one file to another? Files: I have created three files, one file holds the date, second file holds the interface (layouts for data entry), and the last file contains my report layouts (printable ones). Problem: A user does a search in the "Interface" file and a found set in listed. Now the user wants to print the list if records. I need to move the found set over to the "Reports" file to be printed out on one of the layouts. Is this setup possible with FIlemake 7? Do I need to move all the layouts back into the "Interface" file, where the searches are performed? Or should I move the search and list layouts into the "…

Just wondering if anyone had bought the new version of Filemaker Mobile 7 and if anyone knew whether it's as bad as Filemaker Mobile 2 was or is it this time a proper DB app for the Palm ? Thanks

Hello, I can't seem to find more info on Portals. I have a couple questions: 1. I have the relationship setup to create new record when the user finishes a line in the portal and hits tab or select a field in the next line they can start the new record in the portal. How can I set this up so the user has to hit a button to create a new record for a portal and not have FM auto create the new record so the user can't do this in error? 2. I have 3 check boxes in a portal row (this is for a card collecting DB), 'own','Trade', & 'Sold'. I would like to change the color of the background for the portal when a user selects one of these buttons. I figured I could do a b…

Very noobie question here. I have a table called purchase_invoices which is bound to a data entry layout (Purchase order entry), on this layout I would like to place a button which would list all records in a new laylout. I only wish to list certain fields and each record must be in a single row with the next record below etc. I do not wish to do this as a report as I would like to add some addition functionality like click on button to go to selected record in original layout. Any ideas would be welcome. Many thanks

i found that in table view, the table's header's display and fonts seem to be preset, and i can't find where to configure them. Filemaker cannot display foreign characters right at this preset font when printing, but it displays them right on screen. bad... when printing in table view, those foreign characters all turn into... squares. whileas preview actually shows them displaying correctly. i tried printing into a PDF file... same result... so it's mostly Filemaker's problem, not the printer's.

Hi, I'm trying to change some features on a student database solution which was designed by someone that we no longer want to employ (don't ask!). It was originally a FM6 solution but I've converted it to FM7 whilst still keeping it as 16 related separate files. What I'd like to do is track whether students have handed in a specific assignment by using a handheld text scanner to input the student's id number into a field in the Assignments table which then copies the student's details into the Completed Assignments table. At the moment we have 2 portals in the Assignments Tracking layout. One of these shows the students who are registered on that modul…

some of my clients want to be able to clink a link on the desktop that directly connects them to the remote file, like the "Open Remote" command in the FM menu. can someone tell me how to do that...? does filemaker accept command line or something?? i can't find any reference in the manual... thanks :-p

Hi- New here and to FM7. My site works fine on my PC but when it's on the web it doesn't function the same. Specifically my tab buttons through fields. MY local site works fine but online the tab button sends you all over the place within the form. Any ideas? Thanks!!!!

As a first post, let me start by introducing myself. My name is Nick, and I currently work at a drag strip (motorsports facility), as a racetrack announcer, and am looking to make a simple program to solve my problem. The computer we use displays us racer information when the racer comes to the starting line, and though the information is readily available, it is not displayed for anything but elimination runs. The other announcer and myself would like to create a program for our laptops that would provide us with the same information...no problem, that takes only 2 seconds. The feature we are looking for, is to be able to do 2 at once on the same screen. These are s…

I have a network of multiple users with a database using lots of esoteric words. Spelling is important and Fm has to learn all the terminology for spelling to go smoothly. Does every copy of FM on every client have to learn all the terms or can the Host computer host the dictionary? The latter would speed up the learning process for FM and accelerate data entry for the users.

I've had to reinstall the application 4 times. The symptons are; after double clicking I get the splash screen and then it quits. This happens twice, on the third try I get the splash screen with a line of garbage that looks like it might be filling in the serial number, it quits and then I get a message that a virus or something else has corrupted FMP, determine the error and reinstall. Then sometimes when I start the application, it works. I can't determine how or why this is happening...help!

Is it possible to use a wheel mouse to scroll through a layout/portal, etc., in FMP7 for Mac ?

Hello all! Filemaker has announced that they close the upgrade in September and that they stop selling FM6 at the same time. What is that really meaning? If you have a application which cant be upgraded because Filemaker doesnt let the Changeprinter upgrade plugin how could your client get the needed software, in my case FM5? Is it free to distribute the older versions as a copy of yours? -Per

I've been printing from Classic due to the EPS/PDF low-res printing problem in FMP 5.5 and 6 on OS X. I just got my copy of FMP 7 (which I understood would fix the problem), and imported PDFs (put on the layout behind text fields) still look horrible. Am I missing something? thanks, Don

I have just started with a company that uses version 6 via web companion to publish to their intranet. I am eager to move onto version 7 to implement some of the new features. However, what are the implications for migrating the web content from a version 6 setup using web companion to version 7 (I presume using server advanced?).

when customizing business tracker from the publishing business to a wholesale painting business, i am having trouble with the catalog. the catalog script refers to a "category" field that i no longer used. i've tried to change the field to "size" of the paintings, but the script still doesn't pull up the records. can anyone help me with the script? or tell me what i need to do as far as defining fields or changing certain of the layouts that the script refers to to make it work?

Hey whats up guys? I am looking to upgrade from filemaker 5 to filemaker 7 and might go with the advanced server version. i like the features of the xml and want to integrate it with a web site's shopping cart and make my own order status thing. I found this version on Ebay: http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=3773&item=3696065281&rd=1 and was wondering if this was a good price. any suggestions would be greatly appreciated. thanks!

I am just starting to convert a FM6 file to FM7, but have been horribly disapointed by the speed at which FM7 runs. Switching layouts, creating calculations, and even basic functions like replace and set field take a VERY long time. I have downloaded the latest version of FM7 and am running a 1Ghz G4 powerbook with OS10.3. I am afraid of upgrading for fear that no one will use the system if it is too slow. How are people dealing with this and are the folks at Filemaker doing anything to improve this? Thanks David

Hi Can someone tell me if I can make a standalone executable (.exe) database that I could run on different machines with File Maker Pro?? Thanks

I am very new to FileMaker Pro 7 (started using it yesterday). I have two popup lists in my layout one for States and one for Routes(I have two seperate tables, one for states & stateID and another for route, routeId & stateid). I need to populate Routes based on the State selected. How can I achieve this? If scripting can achieve this please tell me how to go about it. Thanks in advance.

I am creating an asset-tracking database using FM7. This is the first database I have created from scratch in FM7 and seem to be getting confused with a couple of things. Firstly, the database I am creating has a table containing unique entries for each asset no. and there are fields relevant to whether the movement of that asset is inwards or outwards, should I create one table containing all the information for each asset no. or create three tables

All, I have a FM6 solution that was recenty converted to FM7. It's around 55 files, 350 MB total, and was just converted to 7--not optimized in any way. (We're testing the waters at the same time as beginning to plan migration) One immediate problem is the SLOWNESS of opening files in FM7. We have a simple "System Menu" file that opens as quick as one would expect, but trying to open most other files from there (via a simple "Open File" script) can take as long as 30 seconds or more... and not even on a server, but on a local machine! Trying to directly open the offending files gives the same result. Looking at the output of "top" (OSX) while the fi…

Hi! Can you easily import the contents and structure of a MySQL database into FileMaker? Or, at the very least, the data from a MySQL database? I have a MySQL database that I would like to have in FileMaker. Its not a huge database (ie, I could create the tables in FileMaker myself, import the data in csv format, recreate all the relations, etc), but it would be sweet if a more efficient or practical method existed. What options are open to me? I'm new to FileMaker. I'm looking to make the switch from MySQL to FileMaker, using FileMaker Server 7 Advanced and Lasso Pro 7.1, or possibly FX.php. Maybe I'm nuts, but I'd like to try. Our MySQL database is …

How can I lock text in a (global) field so a user cannot modify it? I tried preventing entry in browse and find modes, but that also prevents access to the scroll bar. Since the text is too long to display, the field must be scrollable--but I don't want the user to be able to modify it. Thanks. RD

mind sharing some insights & feels of the product? thanks...

I need to know if there is a way to find email addresses without having to "" or /@ in the search. We perform most of our searches with email addresses. Sorry if this has been covered, I couldn't find it. J

I have tables in different files and I made relationships between them by adding File References. How can I add the tables to a single file, which has the main table in it? Thank You.

hi all~ can someone advice a good barcode plugin for me? i have seen a few around, but don't know which one is good. and... as a beginner in this field... can someone tell me how can i use a barcode scanner to scan the data and be read into filemaker? how is it done...? thank you very much...

Can anyone tell me what they replace this scripting option with?

i tried to update the patch on some client computers running Windows XP SP2 Simplified Chinese edition and the patch failed due to a path with invalid characters. does anyone encounter the similar problem and found a solution?

hy there I am new to filemaker and strugle a little bit with some operations i would like to perform. i want to make a phone log, that is conceted with a customer table. the phone log table consist of the fields: name, caller_phone, message, date, call_for. Now when I'm on the phone I would like to be able to enter the first characters of the caller's name into the "name" field and the database retrieves a list with names from the customer table starting with those characters from which i can choose. Once i chose, the same thing happens with the phone log's "caller_phone" field. There's a list with all the number being stored in that specific users profile. is …

FMP7 on reopen forgets the last screen and sort order. I arrange the screen and close, but when I open again the sort order is gone and FM is on a file in about the middle of the database instead of, say, at the top of the list where I left it. What's wrong? Is this a new "feature?" Version 6 always came back when it was left--same screen, same found group, same file. Furthermore, in 7, when I take a file from list to main, when I go back to list, the list has scrolled down a screen and is on a different file. This is the upgrade v7 (from v6), with the 7.0v2 update. At the moment I've gone back to version 6. If version 7 can't be fixed, my next stateme…

Sorry if this has been asked, but I couldn't find an answer by searching... Our simple invoice db includes several repeating fields (quantity, description, price, extended). I have borders (top, bottom, left, right) turned on. In v5.5 it would put borders around all the repetitions. Now in v7, it will only put borders around repetitions that contain text. This looks silly to me. Is this a bug or am I doing something wrong? Your help is appreciated!

I am setting up user accounts in FM7, and checking the "force user to change password at first login" option. When users go to login, they receive the prompt, put in their initial password, and the new one. The problem is that when they are logged in, their access privileges don't seem to match what they are expected to be. (User can't edit or view records even when they are supposed to) But if they do a relogin again, then everything works as expected. This only occurs when you create or reset an account with the "user must change password" option chosen. If they change the password themselves, it works fine. Also, this only happens to users logging …

Hi All, Just getting started with FMP7 here (well, getting started with Filemaker, period.) I successfully merged my two FMP6 files into one multi-table FMP7 file and would like to begin adding modules to it. This is a rolodex application. The first thing I wanted to do was create a script to generate faxes. The way I'd l ike it to go is the user looks up the recipient's name in the rolodex, then a "create fax" button would create a new record in a fax table, with the recipient's name & company info plucked from the rolodex and pasted into the appropriate fields as a lookup. But I don't see any script steps that would accomplish this. Can someone …

Hi-- I have a FM7 DB with several tables. One table (admin) allows a user to enter in details about a program, including individual fields which indicate all the days during the year the program will operate. I have a second table in the DB which users will be able to access to enter in positive attendance days for students. I would like the users to be able to see a value list of all program available dates (defaulted to todays date) which will allow them to edit/enter past attendance only for the dates that the program operates. I would like to be able to get these dates from the admin table in a relationship. FM7 does not directly alloe the creation of a v…

In a found set, how can I bulk enter data into related fields inside a portal? I can create a new related record in the portal by simply entering data, which creates the related record and puts the data in the field, but how can I do this in bulk for a found set? I try "command =" but that doesn't work for fields in a portal. (It pretends to, but nothing happens.) Is there a way to bulk edit related fields in a portal whereby the related records are created and the data inserted into the field?

What's the best/easiest way to get data (in this case, a list of names) from two separate tables (same file) into a single alphabetized list? RDecker

Does anyone know how to create a script that will open a particular *folder* on my C drive -- showing the files within the folder, but not actually opening a file? Can this be done without a plug-in?

Here is a snippet of my calculation contained in the Open Script command... "&city=Somerville&state=MA&country=United States" it goes to the browser as "&city=somerville&state=ma&country=united states" I wish to preserve the text case as the user types it. How?

I want to store Word documents in container fields for each record to maintain the format and styles of the document, but I want to be able to search the text of those documents as if it were a regular text field. Is this possible?

I'm having a real problem with fonts. I have several users in my solution, as well as one or two people helping me with programing. I have made some specific choices about fonts in my layouts, but with so many different people accessing the database, those decisions have been fruitless. Does anyone know of a plugin, or a way of creating a pseudo-font substitution table similar to what you see in programs like quark xpress and other desktop publishing applications. I need something to run at startup that alerts the user that the solution is using fonts that are not loaded on their workstation. I need the user to have the ability to load those fonts, or substitute …

does anyone else meet the same problem? i am feeling really anxious about this now. Internet sharing is so important, and it gets disabled if IWP is access on local network. i tried several ports with no success, such as 80, 123, and 591. A few seconds after the database is access through IWP on a local network, the internet sharing is blocked. anyone else?

I have a card collectors database with 2 tables one for cards and one for sales. The sales table is a one to many relationship to cards table. I also have a self join to cards table to do lookups by series of cards. They are related by 'series'. I have 3 fields in the sales table that is setup as a portal to my cards layout - sales date, sales qty, sales amount. When the user is on a certain card, they can enter multiple sales for each card. I have created a couple sales reports, one that will show you all cards sold sorted by series and another that the user can select the series and it will list all cards sold by that selected series. If the user selects the s…

Dang, just about finished an app, and I was messing with making a script based menu. Some how, I have the start script doing an 'exit application' Which means... When I open the file it automatically exits filemaker. Any one have an Idea how to keep it open to fix my error??? Maybe if someone has the Dev7 they can fix it? TIA

i just discovered that i was trying to put up an image of size 600 KB, and it will never show in IWP. or is it nothing new?

I have a database confugured for IWP. The openscript contains a script step "Show/Hide Status Area [Lock; Hide]". Upon opening in Explorer the Status Area is hidden, but not locked. Anything I might be doing wrong?

I have a database configured for IWP. The main layout is supposed to work as a web form. The user creates a new record, then asks for a registration number, then there is a button to a script that does lookups of several fields in a related database, with the relationship based on the registration number. This way a registered user gets all his personal info entered into the new record he just created, and can then go on to fill in the information I need from them. This works well, until I attach a "Not Empty" validation to any of the fields in the main database. When I hit the lookup button the screen refreshes, but no lookups take place. This makes it impossible to forc…

Hey, this is what im trying to do.... Lets say I have 35 records, and I want to see a big list of the records on one page. I want to have about 5 fields from each record displayed on a line with a button to click to visit that record. whats this called and how do i do it? or if theres other threads on how to do this please direct me, for I have no clue what its called, tried to search but dunno what for hehe

Hi guys, I have a quotations database that has a portal to list the line items in (this way I keep a track of everything by accessing the line items database from invoicing, purchases, returns, etc - all writing to the same record) Now, if I make a quotation and then I want to make a revision version of the quotation, I want to be able to make a duplicate of a portal row so that I do not change the original record but a new one. Now that Filemaker 7 is all in one file, I cannot do an external script to say duplicate record. What is the new answer to this problem? I want to put a button on a portal row and by clicking it copy the related record. …

Hi Everybody, i hvae had a good look around before posting this and am starting to think it my impossible! my situation, i am developing a database to put quotes into; the user / quoter needs to be able to the email that quote directly to the client. the setup is currently running on OS 10.3 (eventually running on a cheap windows box) all clients connecting via web sharing. is their a way possible to export the files as a html/pdf/doc ect and put directly into outlook express. thanks, Neil

Hi again everyone, You know how internet explorer and quickbooks have an autocomplete that remembers what you typed based on your history? So for example, once you start typing "fm" into your browser, it shows you a drop down box of "fmforums.com" and any other web sites that start with "fm". can u do that with FM or a plug-in?

When I attempt to update my copy of FM7 Developer On OSx Panther It stops midway through the proces and reports "An unexpected error occurred while installing "554490" 1008: 17, -4". This also occurs if I try and update the trial version of FM7 that I had previously used. Any ideas as to why this should happen and what I can do about it?

I have a database that has multiple tables, to represent Visual Effects shots in a movie. One table - Shot - breaks down the shot into items such as description, day or night, length and so on. This is the master table with a unique shot number field as the main form of id. A second table - Element - breaks down the images required in each shot - Live Action, CG, Stills and so on. This is the related table, with the shot number used repeatedly for different elements. Shots are often duplicated, but the shot number field needs to be changed to differentiate things. As soon as the shot number changes, all the elements related disappear. I need to make a quick and easy …

Anyone know if it's possible to search for and replace an the end-of-line in a text field when the field has only a single line of text?

I am currently a version 6 user. I have scripts that import data from MS Access. There are two limitations of v6 that I would like to ged rid of. And I am wondering if v7Pro solves these issues. I browsed the user manual for v7 but did not find what I need. The ODBC connectivity in version 6 does not allow me to use a parameter. In other words, I cannot run a parameter query. I cannot say, give me all rows where price > 5, where 5 is a value that my user entered. The second limitation is the script maker field mapping. V6 has the way of remembering the last field mapping you did when you record the script. Once you create multiple scripts you really can…

I have a table Course with details of different courses. And 2 related tables, Facilitators and Enrollment. In a layout based on table Course, I have fields from the table Course(course name, course ID etc), a portal showing the Facilitator details(Facilitator ID, Facilitator status) of that course, from Facilitator table and a portal showing Enrollment details(Enroller ID, Enroller's Status from Enrollment table) of that Course. If I want to create a new record for a particular Course, can I use this layout to enter, along with the details of the Course, Facilitator Details and Enrollment Details using the portals? I could not do this. But there should be…

I have a database that is used to track job applicants. Each season, we have a "recruitment" period, twice per year. After each season, I'd like to be able to archive those applicants who we're no longer interested in... especially since one of the database's main functions is to show the current crop of applicants on various reports. However, we'd like to be able to pull up archived records at a moment's notice. The two ways I can think of approaching this are: 1. create a separate "archive" database.. and write a "send to archive" script in the main database and a "restore" script in the archive database. 2. keep all records in the main database (I'm…

What is status of use of Filemaker 7 as ODBC client in general, and on local workstation in particular? Is it possible or is there a workaround besides export of data to earlier version of Filemaker?

I broke down and burned up a tech support call today regarding some issues. Here's what I was told: 1. Fonts blurred - that's a feature not a bug (I anticipated that answer)- "just increase your font size until it's not blurry anymore" What - 72 pt? 2. Lag and "stickiness" in Layout Mode: They hadn't heard of any problems with this - it must me my four computers I tried it on. (I suggested they ought to do a search on this fourm - he said maybe somebody from FM will check the fourm, but the tech support folks have never heard of it). 3. Instant Web Publishing - Sometimes a list layout will show up with misaligned fields in the browser - again - must be …

Hi guys, I have got a database with 4700 records in it and I have added a new field. I do not want it to be a calculation field but I want it to have a set result in all previous records. I want the value of the field to = 1 at the moment it has nothing in there I have tried a FIND & REPLACE looking for "" and also without the exclaimation marks, to replace with 1 - current field only, all directions - REPLACE ALL It just goes through the whole database but replaces nothing with nothing Does anyone know a way of replacing a blank field with something in an entire database? thanks

is it going to be delayed? it's near the end of august... and the webpage says it's going to be available this month.

Hello all, I am interviewing for a job that includes administration of a FileMaker database. I have never used FileMaker before, but I am very familiar with PostgreSQL and MySQL, and I have dabbled with Oracle a bit. Could anyone point out any basic guides to FileMaker for me? Books would be fine too. Or, if someone would like to give a basic overview of how it works, that would be great Mostly, I am curious as to how the graphics frontend works and anything that may be necessary to know for someone coming from a command-line based DB background. Thanks!

Hi, I had no idea where to post this so I hope i'm in the right area. This may be an obvious question but i can't figure out how to do it. I have a database with stock codes. Each product has an associated file (with pictures, notes, etc. about the product) on a remote server. My question is how do i get filemaker to open the file for a certain product. I have the path to the file stored in one field and the stock code matches the file name. I don't want to have to hard code the path of each product to a button or anthing, i'd like it to be dynamic. Is there a way to do this. I have opened files on the local disk with Send Events before but it doesn't work for remo…

HELP! I just got Filemaker Pro 7 and have what I'm sure is a VERY simple question (but I'm not getting it!). I have data for a photograph print competition that I want to get statistics on. There are different categories the prints can be entered in, and in each category the print can be given a blue, red, white or green ribon. What I'd like to be able to do is calculate 1)the total number of prints in the competition, 2) the total number of prints in each category, 3)the total number of blue, red, white, and green ribbons in each category. A table with the above information would be great. And if you can tell me how to get the percentages - bonus points! T…

We have an elaborate collection of FileMaker 6 databases that relate to form a system that manages our business processes. We are looking at migrating to 7. Is there a 'general rule' we can follow as to how (and how many) we should arrange our tables in files? Having 50 tables in one file does not seem logical to me. Does anyone know of any documentation regarding design principles in this regard? I am reading 'Migration Foundations and Methodoligies' document and finding it usefull, but haven't been able to find reference to this. Thanks

Does anyone know how to make a link to a URL on the web or to a pdf on the hard drive from a database? I desperately need help cuz I've tried everything... I'd appreciate it a lot!

I have a strange problem and I was wondering if anyone else had a similar problem and possibly a solution. I have a script in "File A" that calls a script in "File B". After the child script in B is fully executed, script A executes the "Exit Application" script step. The problem is that the filemaker.exe process is left hanging. The user does not know this until they try to open filemaker back up and nothing happens. If you go into the process window from the Task Manager and kill the filemaker.exe, you can go back into filemaker. After some trial and error, I discovered that the filemaker.exe is not left hanging if I don't call a script in File B. …

When I add new record, middle of data and I change my mind and cancel/delete the new record. After that new record start from new number and skip the cancel record number. Please review attached three pages. Every page is one proble alltogether three diffrent problems and problem I'm talking about is second page. If you can help me with all the problems I really appreciate. Need some desprate helppp!! needhelp.pdf

A file thinks it is open when it isnt. Cant open, copy or import. Is there any thing I can do??

Hi, I have a rather long and detailed story (including my plans for the database), but if you want to skip it, go straight to the questions at the end. I was recently hired for some temporary work at my father

Hi. I have a table with a drop down field where the use chooses a code. I want to make a layout that will summarize all the codes by type... how do I do this? I don't want to make a 'summary' field for each field... and I don't even think that would work because it's only one field with multiple choices.... anyone have any suggestions?

I'm wondering if it is possible to create a related record just by a relationship and an auto-enter field? What I would like is where I make a new record in the parent table and set the appropriate field values in parent table and once I commit the record a new record is created in the related table. This is without using a set field of the related keys in the related table. I know related records can be created using a set field through the relationship but is it possible to create it without the set field and just by auto-enter fields that are bsed on the parent table? Thanks.

I have to keep restartung Instant web publishing or change the log idle users off time in order to restart the web service. The database itself is accessible through Filemaker. This is my console log...does anyone know what it means? The only thing I know is that it's referring to the Filemaker app process and not the IWP process because of the ID number. Thanks. ------------------------ Mac OS X Version 10.3.5 (Build 7M34) 2004-08-13 09:29:19 -0400 *** malloc_zone_malloc[352]: argument too large: 4294967295 *** malloc[352] Deallocation of a pointer not malloced: 0xbfffef80; This could be a double free(), or free() called with the middle of an allocated bl…

In FileMaker 6, if I had a value list that pulled data from two fields, say item number and item name, and set the value list to sort by the second field, I could use that field to jump in the list. For example, if the value list looked like this: 12345 Apples 67890 Oranges 24680 Pears I could press the letter 'P' and jump right to 'Pears' in the list. I cannot seem to do this in FM7. Is this no longer a feature? Or is there some trick to make it behave in this fashion?

I am creating a custom DB solution for my company and wanted to insert buttons with rounded edges. The problem is that when you click the button, the entire rectangular shape of the button image goes grey. Is there anyway to make the mouse down color follow the transparency of my GIF? I noticed that FileMakers standard rounded button behaves this way. TIA, .sly

Hi all, I really need urgent help on the procedure of how to convert/save a file in filemaker pro 5 format when using file maker pro 7 as I need to use the current files on a different system that has filemaker pro 5 installed and upgrading is out of the question. I need your help!!! Thanx in advance Stephen

Hi all, I am trying to use sendmail to send an email with specific information from the database. The main problem is that sendmail only opens outlook and then I would have to click on the send button manually. Does anyone know how to make it send automatically? Thanks, H.P.

Hi all, I am new to the forum here, and new to FM7, though FM user for years. I had a question that I hope I can make simple. I am creating a solution for a music school that has tables for FAMILIES, STUDENTS, FACULTY and INVOICES. The relations are all set nice, students to their families, for billing etc. BUT here's where I need help. I create an invoice and enter a FAMILY number. That easily pops up all the corresponding students with their info and lesson costs through a portal into the invoice. But of course, I don't want to use that portal directly, I want to use a Line Item Table, so the invoices will not get altered in the future when student recor…

hi all... i have two tables related to each other by Purchasing Order. In the master record there is Customer Name, Purchasing Number, etc. Then in child table are order details. i made another layout that is supposed to be available only in table view, which lists all the orders and their details. the layout is based on the child table, and it has a field Customer Name that is from the master table. what happens is that in the table view, the Customer Name gets repeated several times in its field for each row. The field is not repeating field at all, and the entry was correct, such that the customer name was only entered once. but when it shows up in …

Need help to format a field. Is it possible when I enter data in a lower case to a field and tab to go to next field and the DATA I enter into previous field automaticaly changes to upper case. [color:"blue"]