FileMaker Pro v7 – v11

Hi I am totally confused by this one... I have a Staff Detail layout where Staff info is updated. On this form I have a button to display staff Report of all the Staff. I am opening this Report in a new window. The problem is the when the report opens in a new window, the Staff Detail layout also adjusts to the new window size. I don't want this to happen. The Staff Detail Window is open in "Maximize" mode initially and I would like it to remain that way.... Thanx

hello everyone, I started only 2 days ago with the trial version of filemaker 7 I never had anything to do with databases , but...first time for everything they say... (it should become a database holding a list of members, their contact info, talents , and looks(height ,color of eyes..) I started with a single table , (so have now a very long table) As i read more and more bout relational data, i think i have to re-think everything again... I made a second one , with 4 tables (personalContact, talents, experience , and looks) i was wondering if anyone can direct me to a clear beginner tutorial our help me out a bit bout relating... (i search…

I have a calculation that based on a condition should display one of two graphic container fields... Case( Validity = "Valid"; ValidGraphic; Validity = "Invalid"; InvalidGraphic; InvalidGraphic) But while this worked in my first test case, it hasn't worked since. The calculation field is always blank. What should I do?

Hi, I'm trying to create a report from a database where I have different items and their locations (selected by radio buttons), there can be many entries for each item as they are located in different places at different times. What I need is to take the newest date entry for each item and use that to create a report that tells me how many of each item is in each location at any time I choose to view the report. Hope this make sense. Thanks lsimpson

Hi to all, i need to know how i can put some mark to select the field (arrow) in the fields with pop up list. Another question! I Have in my home the FM pro 7 in my home (Mac OS X version) and FM 6 in my work place (Windows 98), and i need to know if i can run the db buid by FM 7 in FM 6 Pro? Thanks in advance for your help!

hi all~ is there a function that can get the field contents when it is made as a button? or to know the field name that is being pressed? i am trying to make a calendar solution, and thanks to a guy who generously gave out a free one, but there are 37 day fields, and the user click on a day on the calendar, i wish to know which one was pressed... thanks~

When installing FM7 it installs automatically onto the c hard drive although I would like to install it on the other hard drive. Is there a way of changing this? Thanks

I have downloaded the latest version hopeing to see improvements to some "querky" behavior that I have been experiencing with earlier revs. So far I see no differences.

I have a bunch of files in a folder with systematized filenames in the following order: name123_a.pdf, name125_b.pdf and name231_x.pdf. I want to import the files (automatically) and then fill out the following automatically: name language The name is the first letters and numbers separated by a hyphen, thus: name-123. The "_a", "_b" and "_x" refer to what language the file is in, where "_a" is English, "_b" is Norwegian and "_x" is both. Is it possible to automate the insertion of file names in the proper format, and the words English, Norwegain and English/Norwegian just from a file import action? Any help gratefully received. P

I have a database which contains equipment and a date tested. As an example equipment may need tested annually. How do I generate a reminder that a particular piece of equipment is due for test by either automatically producing a weekly/monthly report or having a pop-up box appear on screen to remind the user that a piece of equipment is due to be tested. Any help greatfully received. Thanks Susie

On my standard letters I have a line which contains details of the client such as title, surname, DOB, Address line 1 and postcode. at the minute I have to have the field size set to the largest so if someones surname has 20 Characters in it i have to have enough space for this then if the next client only has 4 characters I end up with a big gap befor the DOB . Is there away of seeting it to make the fields automatically set to the required size?

OK...Can anyone explain to me how exactly does the imbeded image in the FM container field gets "automatically" udated when changes occur to the OG image. I have insterted images into container fields using an OLE connections and I've changed the link options to update automatically but the image still does not update automatically. Why do I have to go and update links manually even after I've specified it to do it automatically...Help ! Any suggestions on what the best way to handle images (Illustrator) is !!!!

I have a script that is copying data from a field on one file, and pasting it into a field on another file. I have a portal that is looking at the information on the file where the data is being pasted. When I click on the button that runs this script and goes to the layout with the portal, I get an error message saying "This record cannot be modified in this window because it is already being modified in a different window" and the script is not completed (it copies but not pastes). But if I click the button a second time, it works fine. What do I have to do to make it work the first time round???

If I click outside the field before I click the button that runs the script, it works fine and there is no error message. I tried making it go to another field in the script, but that didn't work. How do I do the equivallent of clicking outside the field in the script to avoid the error messages?

Ok, here's one I'm stumped on! This is simplified a bit, but gets the point across as to what I'm trying to do. I have a table of records. Each table can have a varying number of child records in a related table. Each parent will have at least one child, but can have an unlimited number after that. Each child has a field with text entered either "yes" or "no". In the parent record, I want a calculated field to return "yes" if every child record says "yes" and otherwise return "no." So: Child 1 = "no" Child 2 = "no" Parent = "no" Child 1 = "yes" Child 2 = "yes" Parent = "yes" Child 1 = "yes" Child 2 = "no" Child 3 = "yes" Parent = "…

So far on these forums, we've found 3 serious bugs with importing in FM7. I'm hoping these get fixed in FM 7v4! Import truncates if double-quote at end of line: http://www.fmforums.com/threads/showflat...;gonew=1#UNREAD Server forgets import path: http://www.fmforums.com/threads/showflat.php?Cat=0&Number=120608&an=0&page=5#120608 Imports are 5x-100x slower than in FM6 : http://www.fmforums.com/threads/showflat...true#Post102196

if i am doing a lookup of a customer last name and there more than one 'SMITH' in my table, can i get an error message to display and possibly ask me which 'SMITH' im looking for?

Ok, this is going to be as detailed and clear as I can make it. I have been working on a quote database for our company and I have run into a problem (for me). The quote is laid out by room name (a field in a leading sub-summary by room name part) then items in the room (in the body, single line of info populated in a list in preview mode) then a sum total of the room items (in a trailing sub-summary by room name part). This give me a printout of all the rooms in the quote with room info and total below. Pretty straight forward until now. We also need to include wire and labor in the final quote as well so we just added wire and labor to the rooms value list and added a f…

I have a database in which I have a list of "Area of Expertise" beside each Area I have a checkbox formatted to display only one checkbox. The user checks the box to indicate that they have experience in that area. There are 34 checkboxes on my layout. Now I want to do a "Summary Report" which will only display the area of expertise that are CHECKED. How do I do this? Do I have to use a calaculation field? Instead of bloating my orginal file with a whole bunch of calaculation fields can I use a different table? Thanks in advance.

Please tell me this is not happening...from the fm7v3 readme: 1.6. Portals 1.6.1. Corrected a problem that could cause an incomplete update of records displayed in a portal based on a relationship across multiple tables. Note: In order to get the correct behavior in files created in earlier versions of FileMaker Pro 7, make a change to the database schema, for example by changing a field definition, and click OK in the Define Database dialog box to commit the change. Now we have to update all released solutions on new releases of the app? Rod

Started yesterday morning with a corrupted DB??? Appears I was able to recover data and then import into clone of back-up. NEW DB still seems unstable . . .but working However, on the new DB I cannot get the search to work on checkboxes. I can tab through records and see large numbers with checkboxes checked (different lists for announcements), HOWEVER when I do a find on one of these checkboxes I am told there are no matching records (which I know is not true). I have no idea what's going on. HELPL!!

Hi, I recently joined the filemaker-comunity. I already read some books and some of the documention. Since I have some background in c++, php and perl-programming, I am pretty suprised by how easily you can create complex stuff without programming. But now I reached a point where I don't how to handle this. I want to create a database for managing project related tasks. Each task has a date, start-time and an end-time. Now I want to list all task-records sorted into a list of weekdays. See this mock-up screen I created with photoshop: I assume I could probably do this by creating filtered relations between the task-table and seven dummy-tables one for …

Can someone tell me if this is possible? I was tinkering with the Business Tracker db I downloaded and when I open a pending invoice and click on the product code a drop down list appears with a selection of products available to apply to the invoice. When I drop the list down again to add another item to the invoice the "previous" product is still available in the list. Is there a way to change it so that once a product is applied to a particular invoice it would NO LONGER be available for selection again. I can't see a reason why you would want to apply the same item to ONE invoice more than once. It would make it easier if you could eliminate that item from the …

I have been having a problem with the "Open URL" script step in Filemaker 7. It seems that it is not case sensitive. Can anyone confirm this. I cannot open URLs with capital letters in them. Mac OSX 10.3 FM 7.0v2

I currently have a db with 2000 clients in it on one lay out I have the option of senidng a standard letter to the GP so when you click GP letter sent - yes it runs a srcipt which should go to the GP standard letter and print it the return to te original layout. unfortunately i think I have missed someting as when I do this it prints the standard letter for all 2000 clients....not what I want can anyone tell me what i'v missed out.

Anyone else seeing a MASSIVE slowdown in import performance in FM7? I've done some quick benchmarking, and my imports are between 3x and 5x slower than they were in FM6. Of interest: it appears as if the import starts out quickly and then progressively slows down. For example, the first megabyte of a 5MB file may take a few minutes, but towards the end, it's literally importing at a dozen bytes per second. This makes FM7 nearly unusable for some tasks, and hard to justify to clients as having "performance improvements"... FileMaker Version: Dev 7 Platform: Mac OS X Panther

When using the Substitute() function to change the font of some of the text in a field, the entire field changes fonts if the searchString includes the first character of the text in the field. For example: Create a database, "myDB", with a field, "myText", containing the text "some text", formatted with the Courier font. Create a script: Set Field [ myDB::myText ; Substitute ( myDB::myText ; "some" ; TextFont ( "some" ; "Arial" ))] Run the script. You should see ALL the text in the field change to Arial font. Change the formatting back to Courier, then change the script so it subtitutes "ome" instead of "some". Set Field [ myDB::myText…

Trying to get a value list that is a repeating field specified in another field I can get it to work, but when I base it on a relationship I seem to loose all of the repeating fields except for the first repeating field. I think I am missing something, but I just can't seem to figure it out, I have changed things back and forth to different relationships, and even creating a stand alone relationship, nothing seems to be working. And I cant just let it show all because this is a specific field relationship only. Any suggestions?

I am trying to control the opening and closing of windows in my db. In the solution I am developing I have a script that opens a new window/layout to pick from a small list records, the next script step closes the new window you just made your choice from and it is supposed to take you back to the main parent window and complete the rest of the script. But it only works because I know what the window name should be. Script Steps Close Window [Current Window] Select Window [Name "database name"] Perform Script [" Next Script Steps "] I have it all working fine but found one step that is less than perfect. I have a 2nd copy of this db for dev…

Hi, I wasn't sure where to stick this post so here goes. I have a DB that must print reports on a daily basis. Sometimes we have to print past reports, etc. I want to automate the whole process. I am a transfer from Access where I could use a pop up calendar and a print button from a query. So far what I can tell is that in order to get the correct day I have to make a button to send the user from the form to the print layout, then have them go into Find Mode to enter the specific day. It seems like a long way around the bend. The bottom line is that I want the user to be able to push a button and enter a date, hit another button and the print out the corr…

For some reason...on only 1 page on 1 layout of my file I have started getting an error tone (beep) whenever I tab to the next field after entering information in any edit box. Does anyone know what might cause this? I have deleted every field individually to see which field is causing it and it keeps happening no matter what I try (I even remade the entire layout to see if it would help). Has anyone seen this before?

Hi, I was wondering how one might create a log. Basically, I want to log changes made to various tables. Add, Deletes and maybe edits. Creating a table for Logs is not hard. It would be wonderful if i could create a function called Log("Added Record: " & Get(Tablename)) or something like that. thanks for your advice in advance, sincerely, J__

I'm running into a problem with users and permissions. I can get FM to only show the records associated with a particular user (using "<fieldname> = get(username)"), but rather than hiding the records that aren't applicable, I see a "No Access" in the fields. How do I hide the records that shouldn't be shown? TIA. -t ps - I'm under a time crunch so if I forgot any details you need, lemme know.

I've been asked to create a database for signups in limited capacity activities; once the 25 seats are filled, the activity no longer appears as a choice. Is this possible?

Now that FileMaker has fired many of their developers, apparently over problems with the release of FMP 7, (www.thinksecret.com) I wonder how long it wil be before we see fixes to the bugs in this new version. Somebody obviously didn't do their homework.

Aggghh! Sorry. I FINALLY convinced the powers that be that FM would be a worthwhile investment and now I've got til tomorrow to get this database working.... Let me explain exactly what I'm trying to do and then ask my question. Hopefully that'll make the situation clear. I'm designing a db to track therapist and client appointments. - Each client has a unique ID that I'm using as a primary key. - Each client has one and only one therapist, so the therapist is a field in the "client" table. - Each client will also have several appointments. This is a separate table with client ID as a foreign key. How I'm doing this now is using a portal…

I've tried my best to see if someone reported this before, but no luck. Has anyone experienced problems with buttons in v7. Even simple ones, which I made tranparent retain the borders after it has been clicked, and after the script has run. Not to mention that it isn't possible anymore to build shaded button with the borders toolbox as in prior versions.

I am a school teacher, as part of our afterschool program, we need to setup a system that will track students everyday based on the amount of time they are studying. The concept is: (I figure having records that are based on days would be easiest) 1.When the kids arrive, we can enter their student ID (I have created a relationship with another FM database with student info) This automatically fills in their name and phone number 2. We then would enter the time that they arrive 3. We also choose how long they would study for (usually 1 or 2 hours) ---This is important, becuase what I am trying to achieve is a format (can be very basic) maybe as a table that wi…

Dear colleagues I am trying to create a script that will backup my databases either one table at a time all or all of the tables at once. The problem is I do not know how to point to a particular table before I exported. If someone has a routine that actually unloads or backs up each of the tables please give me assistance. Below is an example of what I tried to start with. show all Rcords Export Records{"testbackup.fp7";Unocode(UTF-16)] "at this point I would like to move to a nother table and export the records from that table.

Does anyone know the logic of where Filemaker places custom dialog boxes on the screen? I'm finding that they're often not where I want/expect (sometimes low on the screen), and I'd love a way to control this behavior. Any clues? -Terence

I'm putting together a User Guide/Help system for my FMP7 solution. So far I've only got as far as a help button opening a new window titled Help. Would appreciate some pointers on how best to use FMP7 for this, as well as best practice for setting up help files. Thanks

Help! No matter what I do, when I quit FM Pro 7, most of the time it hangs. The database window closes but it hangs before the program can quit. I've tried reinstalling, re-Disk-Warrior-ing my hard drive to make sure there is no corruption, removing all USB peripherals...what is FMPro 7 incompatible with?

Hey All, I know there are plug-ins that allow a script to be performed or triggered when a field is exited. Does I thought I read that FP7 would have this ability. Does it? Thanks Joe

Hi everybody, I have a problem: I need to convert a number into text like: 234.678.000 and I need twohundredthityfourmillionsixhundredseventyeight. Is there a way to do that.. if so please help me. (I searched the forum but had no success)

Hey All, The new "Specify Find Requests" option in FMP7 allows the manual entry of static search criteria, is there a way to search on a global value. For instance, I want the user to enter the a SS # through a CUstom Dialog in a gloabal field, then pass this info to the FInd script using the "Specify FInd Requests". Is this possible. I know how to do it with a scripted "Enter Find Mode"=> "Insert Calculated Result" =>Perform Find, but I thought maybe there was a new possibility here... Thanks

I am trying to design a sophisticated find process for any table such as vendors, customers, etc. When the find returns more than one record, I want the user to see the list and click on a box to select the particular record in the found set that best matches the user's find criteria. As I read the Get(ActiveModifierKeys) function description in Help, only control-type keys are assigned numbers, not the mouse click. Any way to accomplish this?

I'm wondering about it's usage and if maybe how it's used might have changed from versions befor filemaker 7. So go to a layout, and initiate the relookup on the field that's the key for the relationship that the lookups get their data through. Does this only relookup fields that are on the layout? what happens if i have lookup fields that are from another relationship, I'd assume i need to do the relookup on the field responsible for that relationship too. My situation is one where i've got lookup fields that grab from atleast 2 relationships. I'm mostly curious about what get's looked up, is it just the fields on the active layout, or all fields that…

Hi to all! I'm a beginner in File maker, and i'm trying to make my first database. In that database, i need to put a field with text, but i want do a list with all the possible values for that field showed like a scrol bar (like browsers window). What i need to do? Its possible to do that? ps: in the profile window there is some like i want for the age. Thanks in advance for your help, and sorry for my poor english.

How do i create a file pathname in FMP? I need to export the data with the pathname that the files are from so that it will merge with another database.

I have a container field, set to repeat, how do I import all the images? I seem to be able to import one, but how to insert the rest?

ok so I came into a lab that was using FM and I learned how to get things working fairly decent. there were a few exisiting DB's and I was building tables off of those. Here is the thing I need to have something checked (ie need order) and then insert something into a second file. alright file 1 has a needed dropdown (yes/no) if yes then I need it to insert the item # from that record into a repeating field in a different file, I can open the file but I can't seem to get it to update anything in that file (file 2 = orders). loop... if(Exact ( "Yes" ; Lab Inventory Sort::Needed ) open file... (works) set field (file2::fieldx ; lab inventory...) so t…

Hi everyone!!! I used to program in Access, and I remember that when ever i would use a drop-down menu(or list) i would also have the option of attaching a VBA procedure to it. So here i am in FMP, and I

In Windows the Escape key is giving me some grief. I would like in a number of situations to use the default button in a dialog box for "OK" or "Continue" but a user hitting the Escape key expects to get the "Cancel" option. I have therefore always coded the "OK" option to button 2, meaning the user always has to click the button rather than being able to hit Enter. Now that Filemaker 7 allows field input within a custom dialog box, the data is only entered via the default button, ie so if the user enters data in the field input, then has a change of mind and hits Escape, the data is entered into the field anyway. Please confirm I've got this right. Are th…

I've assembled a project with many duplicate pages that have the same graphics (tab bars, background, etc.) only to find that when I inserted the graphics the first time (waaaay before formatting there size and shapes) I must have checked the Store Only A Reference to the File box. So now I when I want to send out a copy to someone else they don't get any of the graphics. Is there any way to relink these graphics or am I screwed and will have to re-insert and format all of them ( a process I am not looking forward to).

I have a layout with a portal with 15 rows. I want to get the total of all the values in the rows. How do I do that?

I have created a database which stores lists of documents, that we have archived. There are 25 fields where users can enter what the documents are that we have archived in a certain location. I want the users to be able to perform a find, where if they put in the document's details in the first field it will also search for the same details in the other 24 fields. Can anyone tell me how this can be done? Thanks Damien

HELP! In migrating my FM6 solution over to FM7 it seems that I have to specify the IP address in all scripts that use the "import records" script step if they are a client on a network with a remote server. This is terrible news for me as I use the solution for hundreds of different clients, all with different Server IPs. My question is: A.) is there a way to specify that I want the import to simply look for the file's name (locally or remotely) - this is how it used to work in FM6 OR B.) is there a way to make it based on a calculation that would go and look for the IP address of the server (if there is one)

Can anyone offer suggestions as to how I might be able to get the text with its formatting out of FMP7v2? At the moment, all style is lost if it is copied and pasted into the likes of Word. Would appreciate any help. Thanks. Paul

Hey all, I have a question about scripting a set field command. I have two tables, Companies and Contacts. I would like to create contacts from the Companies table. I am using a company# field to relate the records, but I can't get the script to insert the current company# in the contact layout. If I manually input the company# in the contact layout, the contacts show properly in the Company/Contact portal. Does this make sense. I am sure it's an easy fix, I am just stumped at the moment. thanks for any help, Tony

Hi I have a File that has a "Job" Table. I have another file that has a "Cleint Table" and "ClientContact" Table. Relationship between Cleint and ClientContact is one to many since one client(mostly companies) can have many contacts. Relationship between Job table and Client Table is one to many as One Client can have many Jobs. Now the query, In the file that has the Job Table, I have a form that needs to display Client and Contact Names. Do I need to have a relationship between Job Table and ClientContact table to do it ? Thankyou in advance

Hi there, Can you insert a pdf file as a picture in a container field. i know this can be done if our are using a mac OS but i am using windows and it doesnt seem to work. cheers

I have an ID system in my database which consist of 2 letters (always the same 2 letters) then numbers (which go up 1 increment for every client in the database....ie TB1, TB2, TB3 etc . i want to sort my db so that it is in order of numbers however I am unable to do this as the sort function rads it as text and organises it in order of TB1, TB10, TB100, etc how do i sort this?

Hi All, I am relatively new to FM database development, but find the best way of progressing is by asking the experts! . I am currently using Filemaker 6 and have bought the upgrade to 7, but have also bought Recruiter 1.1. I have not installed either as I am not sure that Recruiter 1.1 is compatible with FM 7? Can someone pls advise me? Since Recruiter 1.1 was just released I figure it might be compatible, but the specs still say FM6? Does anyone know if they are gonna release another version this year? Thanks! Celeste

Hi all: I am trying to move into more serious relationship design in FM7 and am, once again, having a bit of confusion adapting my Access/SQL Server knowledge. Using the example of a film production database: I have tables for Talent, Scenes, Locations, Film Info and Crew. Normally I would join all this data in a simple junction table with field names like: junctionID, MovieID, TalentID, CrewID - like that. This table would obviously hold the relationships between what crew and talent worked in what scene of which movie. All fine and well, but how does FM handle that? I can actually create this exact table I mention, but then how do I do things like enter…

Since FMP7, the ability to paste styled text into any external program (e.g. NisusWriter) and keep the style has been lost or dropped. I am interested to know how many others are upset about this loss. Cheers, Paul

I use FM7 in a peer to peer setup, with a dedicated machine as one of the peers. 2-3 users max plus the server. The file timestamp on the server is not updated during the day, even though the save every 10 minutes option is selected. Is the file actually saved or is the file just in memory. I realize that as long as the file size does not change, FM7 could just be replacing some file sectors. Advice please.

I was wondering if there was a way for Filemaker to see if a certain window existed and refresh it if it did, but create it if it didn't, so that a certain window could be "toggled" with a button, rather than getting new copies of the window each time the button was clicked. I tired using an IF/CASE statement with the WindowNames function, but it didn't work. Any ideas ?

I am having trouble 1. scripting to automatically attach multiple attachments, I see it gives option to select several files, but does not attach all files selected within the scriipt. 2. I would like to create an email script where it grabs the file in a container field and attaches it to the email. Any help most appreciated! [color:"brown"]

I have attached a pdf file which shows the layout our company uses for it's quotes. I have been able to create a really great quote software (with more than a little help from this forum) but I am befuddled by how to create a report which looks like this. Using the list output and subsummaries I have been able to get the individual page layouts to work, but I cant figure out how to make an opening page and a final summary / terms page. I need to make it where the entire document is created and printed in one step or my boss will never accept it as a viable option to the old software we use currently. Thanks for any help in advance!! samplelayout.pdf

I would love some help with cross-platform FM->Entourage/Outlook task. I know Applescript/VB script can handle this, but my scripting is poor. All I want is to send a mail message to Entourage/Outlook with to, from, subject, body and ATTACHMENTS. Or, worse case, no attachments, but an open window in Entourage/Outlook all ready to SEND is my goal. Thank you!

I have a database with 5 or 6 date fields, all formatted as MM/DD/YYYY. Our client is HQ'd in Europe and so wants the dates to be DD/MM/YYYY. I spent some time looking in the field options dialog boxes, but was unable to find anything. Is there a way to make FileMaker 7 do European dates? Thanks, Matt

Hi, When accessing FMP 7 over Citrix ... is it possible for the client to import / export data from files located in the client's computer? Thanks in advance!

Hey everyone, I have a text field that I use to keep a log of dates. Each date is seperated by a return and they are all in the same format. I have a need to get a count of these entries for a specified month. So my question is; is there any way to get a word count that is constrained by a certain value. For example, a word count on all words that start with 8. I am using filemaker 7 in a mixed platform setting. Thank you for any help.

Hi there! I hope this is the right place to post this question. I am using filemaker 7 for about 3 days now, im trying to export the data to an SQL SERVER database, but it only exports the first data, i even tried to show all the records but still the same, i also tried to create a loop from the first record up to the last but still it only exports the 1st record. below is my query or should i say script: -Show All records -EXECUTE SQL "INSERT INTO dnc (phonenumber) Values (" & DNC::Phonenumber & " )" hope you can help me thnx!

hi, I'm wondering if anyone can provide more explaination into what the filemaker installer is complaining about when it pops that informational message about if filemaker is installed on unix file system or what ever when I try to install it onto a new G5 tower? I've tried to find info at Filemaker's knowledge base, with no luck. I've even googl'd it

I have written a little application what I would like to do is release it with some inbuilt protection. I would like to make it unrestricted working for 30 days afterwhich it would require the user to enter a code that would remove the restictions. Any ideas on how to acheive this would be very welcome.

there is... no *UNDELETE* in FM 7..... unless u implement a delete button manually, which actually dumps it to a "trash" database table or something...?

at present I have two data enterers who input results from a very long questionnaire into filmaker 5 database. So i should end up with two identical files. What i want to do useing fm7 is to be able to compare these files and get a report of any fields which do not match between the two different data enterers. So I can check for data which has been incorectly input...any ideas how I can do this?

Not sure if there is a problem with this in windows or not, but I ran into this problem in a run time solution this morning. I was running some reports for records that have a container field in them, I printed the report about 40 times with different non overlapping record sets then I started having no record found errors when running my printing script which just goes to a different layout in preview mode and then prints. I noticed a slowdown after about the 20th record set but didn't think much of it. I had to restart the runtime solution to get it to clear out. Besides checking for error 101 (record missiong) unless I should check for some other error, how might …

I have two portals on 1 layout. Could someone tell me how to do the following: (i've searched but admittedly not entirely read the Moyer book and the archives, but haven't found my answers) Make the script go to the correct portal (how do I tell it to go to one portal over the other) Go to the first available new record (is this the Go to portal row "last" option or "next" option or do I need to create a new record once in the portal ?? Is it possible to make it so that the new portal record (that will be queued, ready for typing into, can pop to the top of the portal ?? so that my user doesn't have to scroll down looking for it. I have the por…

Running Filemaker 7.0v2 on Windows 2000 finding a serious problem with a true type font. The barcode font BARS12.TTF (version 1.00), which works just fine with Filemaker 6 for displaying a postal address label barcode, fails to render in Filemaker 7. An ordinary (plain) text field, in both a new test database and in a converted database I've used for years, refuses to accept formatting to this font in Layout mode, though the font shows in the font list and shows as a truetype font. (In Browse mode text will accept the font formatting, though it does not look right at the standard 12pt font size; appears to render shorter in height and length than normal.) …

just wanted to say something about FM 7 ... i think it should have the "type-ahead" feature!~ or is it in it somewhere that i am not aware of...?

The purpose of the portal I am building is to show all payments that have not had a receipt generated. Each transaction has a payment status field called Accounts_Receivable which is a calculation with a text message result: Case(((Amount_Due > 0 and Balance_Owing > 0) or (Members_Amount_Due > 0 and Member_Balance_Owing > 0)); "Amount Outstanding"; ((Amount_Refundable > 0 and Balance_Owing < 0) or (Amount_Refundable_Members > 0 and Member_Balance_Owing < 0)); "Refund Due"; ((Amount_Refundable > 0 and Balance_Owing = 0) or (Amount_Refundable_Members > 0 and Member_Balance_Owing = 0)); "Refund Issued"; "Paid") The portal works off tw…

can anyone tell me what version Claris filemaker Pro might be. I purchased about a week ago an upgrade version of Pro 7 and the box says that versions 2.1 through 5.5 qualify until the 17th of sept. i bought this on the 16th so i need to return it if my version of filemaker doesnt qualify. i have a feeling that it might not but not sure. the disk i have only says Claris Filemaker Pro for Mac. I am just now coming back to the mac. Anyone's help would be greatly appreciated. its sunday and filemaker is closed and i need to drive to return this today if i am going to beat the 14 day return policy of compusa. thanks to anyone for your help.

Hello all. I'm new here and am glad I have found this place. Looks to be a lot of good information to be had here. I have just migrated a client from v4.0 to v7.0. It went as smoothly as can be expected. But now there is a strange behavior with some fields that are defined as pop-up lists. What is happening is that in a repeating field situation, when entering the field and the list is to be displayed, the screen scrolls up and if the pop-up list box does show, only the first 2 or 3 lines are shown right at the bottom of the screen. I have experienced this with the v1a and v2 releases. This is running on Windows XP, which by the way is a completely new rollout - both…

I'm wanting to be able to keep a set of records, some assigned invoice numbers and others that have no invoice numbers but I want them all in one database. What I had in mind was being able to click on a button which would enact a script to assign a unique invoice number. Since my invoices are sorted by year and look something like "0484323" with the first two digits being the last two numbers of the year. So you can create a new record and "if" you need a new invoice number, click on the button and presto chango! lol And if you don't need a new invoice number, once you create the new record you simply enter the data requested and move on. I believe I will need t…

Could someone tell me why this Auto-enter calc isn't working and tell me how to get my end result ? the value list is working fine --- it's a dynamic value list that derives it's values from one of the portals on the layout I don't understand why the Auto-enter isn't working. I've tried setting the field to be a calculation field and also as a text auto-enter field but I can't seem to get ANY result from this: Left(ValueListItems ( Get(FileName) ; "SCME" ); Length((ValueListItems ( Get(FileName) ; "SCME" )))-2) I have it resulting in text. It's a value-list of Apple-script style email addresses "[email protected]", so I'm hoping my end result w…

I am looking for a filemaker expert to help me create a database for a new medical product. I have a barcode reading device in production and need a rather complicated database to run it. Market research has shown significant interest and orders could begin as early as 1 month following the developement of the database. I came up wtih this product having practiced in medicine for years. I know thousands will sell. Profits to be split equally with partial ownership of LLC. If interested please contact me directly at [email protected] or 616-780-3596. Randall

My Filemaker User manual explains that the match field in a single criteria relationship is connected to its related table by a single thin line if only a single record can match (e.g. a serial number). The line connecting match fields has a little "fork" symbol on the end if it is possible to match multiple records. What does it mean when the line connecting Match Fields has a little "T" at the end? I have some tables with this symbol and they don't seem to work. Thanks!

Hi, I am new in the FileMaker World, and try for weeks to synch FMM pro 7 with FM Mobile 7 on a Palm T3. I checked the authorizations, checked FMM preferences, synching with the folder opened (running the applications), tried to re install both of them, and no way. I use OS 10.3 and Palm T3 Is there somebody who knows the solution? Thanks!! Greg

Post deleted by joemacgruder

I have version 7. I've imported a list of names from an Excel table. The fields all get imported fine, first name, last name, address, etc. Each record contains a date field in the form of 03052005, 09102005, 07022005, etc. I've defined this field in Filemaker as a date field, but even after I do that, these entries do not change to the "9/25/2005" which is the form my creation and modification date are in. And I cannot seem to be able to sort the records by the date field. Any idea what I'm doing wrong? [email protected]

Hi, Im trying to exit filemaker (7) in the presence of validation. I have some fields that require input, and the validation option works great. But I would like to have an exit button in case someone needs to exit. My problem is that using the validation wont let you exit untill you eneter the fields. Is there any way to use the validation, but if someone presses an "exit" button FPM will just drop it and exit. Im new at this so sorry for the newbieness of the question. Thanks Albert

This question may not be a big one for you, but for me (a newbee) its big. This is what I'm trying to do. I have 2 tables. I'll call one Pies and the other Fillings. You can then go to the Pies table, create a new record. In the new record is a drop down menu with the names from all the records in the Fillings table. I've been able to do this so far. Now I want to look at a record in the Fillings table and see what records in the Pies table selected this filling. For Example: I go to the Pies table Create new record and title it Berry pie In the drop down menu I select blueberry, rasberry, and huckleberry Then when I go to the fillings tabl…

I see that FM7 has fixed one annoying attribute of prior versions. With FM5-6 "Unsorting" records in a list view would not advance the window to the record currently being browsed if the list spanned multiple pages. "Sorting" records was even worse. It would reset the current record to the first record in the new sort order with no easy way to go back to the record that was being browsed prior to the sort. These are both fixed now. Thank goodness.

I am writing a solution where I want to post information from some records in one table to another table. An example is: I have a work order that I want to post to a General Ledger. In the GL I need to add new records from a sort in the work order table. I am having trouble getting it right. Do I create the script from the Work order table or from the GL table? Do I need multiple scripts (one finding records and the other adding new records) It feels like It should be easy but I'm not getting it. Can anyone point me in the right direction? Cindy

Hey guys, quick question. We're trying to install FMSA7 on an IIS6 box running 2003, and are less than successfull. Installation looks like it goes through ok, but when trying to pull up the WSC admin page it gives out a 404, page not found. Tried installing on another box to capture registry entry's, installed files, and building a virtual directory for it, but none of it works when beinging it back to the 2003 box. I can install it on an XP machine, 2k machine, etc, just not 2003 with the latest and greatest IIS. Anyone have any clues? Or using a successfull combination of II6 and FMSA7?

I believe I've found a nasty problem in FM7 (Developer). When importing a comma delimitted text file FM7 chokes on a 13 record text file, and only brings in 2 lines. (FM6 & FM5 correctly bring in all 13). Looking at the data, I see a double quote symbol at the end of a line that I'm sure is causing the problem. If I substitute a word (Inch) in lieu of the symbol(") fm7 import works ok. This is a serious problem for anyone importing raw text files from external sources (main frames, other applications, etc). Definitely not plug for plug compataible with the previous version - can anyone here speak for FileMaker acknowledging the problem? I can provide examples if need …

Im trying to set up a portal with 2 relationship criteria: a text tag "Amounts Outstanding" and a Date tag (week of year in this case) to list all outstanding amounts receivable over a one week period. I have already created a similar portal for Amounts Payable based on month and year which works fine, but this second one won't work for some reason. It works with just the "Amounts Outstanding" tag but not when I introduce the second "week of year" criteria. I want the portal to show only one week's worth of payments at a time so the list won't be too long, hence the second criteria. Any advice very gratefully received.

I have a database of around 2 - 3 hundred thousand listings and need to dedupe it against another database and just can't seem to get it going any subjestions on how to do this would be most helpful MNC-Man (Rob)