FileMaker Pro v7 – v11

hi all... does anyone know how to duplicate a record along with all its portal records (related, of course). i tried the Duplicate record, but it only duplicates the parent record, and then i tried the Copy all script step to try to copy everything from portal and paste to the new portal... and nothing gets pasted :-(

Hi, 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... however, we'd like to be able to pull up their records at a moment's notice. I was thinking that I could add a "season" field.. and then script the navigation and find and "new record" buttons to all stay within the realm of the current season "Fall '04" for example. does that make sense or is there an easier way ? should I perhaps just have an "archive" database that you send records to when they no longer need to be in the "curren…

Hi, My company has developped an application using FM 6. They want to migrate to version 7, but their application is not easy to convert since it is splitted in multiple files (mainly due of the file size limitation). The converted application in FM 7 is REALLY slow and is still fragmented in multiple files. Basically, by using XML export operations in FM 6 and some Java, I want to build a FM script that will be able to create the tables I need with their fields relations. I know that you can use SQL statements with the script engine, still a lot of fields or even data type cannot be created by using only SQL. Any suggestion about it or any hint about how I coul…

We have just upgraded from FM5.5 to FM7. We are now encountering problems with file sharing which we haven't previously eg... when opening multi relational files there are difficulties opening its relational files with messages like 'busy' and 'open remote'. We have about 4 computers sharing. Can we remove our guest and other 'accounts'. Something seems to be wrong with our sharing setup? Look forward to any suggestions...Thanks

hi, i have a question. is it possible to have a field that can show all the values from 2 other related fields? for example... suppose i have a table that has [Order Number], and yet another table that has [Order Number] as well. now these two tables just has its own independant records and data. then i wish to do accounting which will calculate the expenses of both table... is it possible to have one single [Order Number] that can show all the records from both tables? thanks~

when an user with no access to a layout and its records, and try to view the layout online in IWP, it crashes IE 6 and enters an infinite loop that keeps on displaying a dialog box with only OK. it happens when one has a menu selection that directs the user to try to access the layout... does anyone encounter the similar problem?

I need a find request to return the Account Name. I tried =Get(AccountName) and it did not work. Any suggestions would be MUCH appreciated. Thanks - J

Since dialing is broken in FileMaker 7 for the Mac. Does anyone have a good solution for dialing?

Hello Freinds, Like to know if it's possible or is there any script exist to detect a duplicate record during data entry and prompt for proceed or cancel. If some one can help me . Thanks

Hi All, This is my second post. This forum has proven an invaluable resource to the newbie Rex. Thanks to all that manage it and post. I am trying sort and create a report, records by the frequency of values descending from the most to the least occurances in a given field. Explanation: I have 70 records that have 20 fields describing them. I would like to sort the 70 records by one field according to the frequency that the values occur in the records. Much like the alphabetical descending sorting, but by frequency of the value occurance. I would like this to appear in a list. Example: 1. Bannana----------------->1. Kiwi 2. Apple------------------->…

I asked a similar question in the AppleScript forum, but realized that the solution doesn't need to be AppleScript if...it doesn't need to be. Perhaps you can think of a better way to accomplish my goal. I have a FileMaker/Excel combination which is used for expense tracking and budget planning. (Think a bare-bones Quicken with some very specific customized reports and uses.) FM tracks the expenditures for different bank accounts and categories, and summary of these is brought over into the (existing) Excel spreadsheet to track performance and plan budgetting. The Excel file has a sheet called "Incoming Values" with columns for each month, and ~65 rows for all t…

I am building a database for shop work orders I would like to be able to attach shop drawings in PDF format to these work orders. I imagine I should be able to do this by inserting them into a Container Field. The problem I am having is that when I do this all I can see is a faint rendering of the original PDF document. Printing also produces just a fairly faint facsimile of the PDF. This topic has been raised on the Container Field part of this site but does not seem to get answered there. Can anybody direct me toward a discussion of this topic? Thanks, Jarvis

Hi, i am developing a little database for pdf documents... and i have this problem: I tried to print from filemaker the pdf contained in a container field, but I been able to print only the first page of the pdf. There is a method to print all the pdf from the container camp? Or a method to view all the pdf pages in the container camp? thank. Johnny ------ I live in Italy, and I am Cool, and sorry for my YeURRch english.

there is a problem when one tries to loop within a portal. the problem is with the end-of-loop detection. Example script: Go to Portal Row [select; Perform without dialog; First] Loop ..... ..... ..... (your operations here) Go to Portal Row [select; Perform without dialog; Next; Exit after last] End Loop The above script enters an infinite loop and creates infinite new portal records in the portal. Is there a fix for this? or am I just scripting something wrong here? I tried taking out Select, but it doesn't do it. It doesn't seem to detect the end-of-portal-records in portal.... :-( and this script is very important for …

I'm trying to attach a Filemaker 7 file to a post. I get a message can't attach with fp7 extention. Please help

Hi Forum, I would just like to know if anyone has any experience with a biometric interface, using FM ? I'm looking to implement a fingerprint scanner, but I'm not sure if this within FM's scope. Eric

I created a Portal record that has two calculations as fields. Both of them require a field that is manually entered; these fields are not with in the portal, and do not repeat themselves. Cost = (Length * Width) / 144 * Extend ( Three Quarter Hidden Field 1 ) Same for the other field. Lenght & Width are repeating fields. Cost only gets calculated on first record of the portal, I need the calculation for each record. I need help ASAP!! Anyone please [email protected]

Hi, I am new to the forums and have a concern with FMP 7. I have been learning to use it for a project at work for the last month now and so far love it. However, I have noticed something that appears to be a major bug in my FM. In the memory settings, I changed the "Save cache contents" from the default "during idle time" to every 10 minutes. I have found that neither of which are actually doing so. I had FMP running for 3 days straight and added and modified records during that period, and never once did it save the cache. I know this because in the properties of the DB file, the last modified date and time were the last time I had closed the file (3 days prior). …

In the older version of FMP, if I click on a script button in a portal row,say row 5, the script excutes in the record that's in the row 5. In FMP7, the script always excutes in the record in the first row. This problem really bothers me. I'm think about adding a few more steps to the scripts. Maybe I can use a global field to store the portal row number, then go to the related records, then go to the record which record number equals the portal row number. I wonder if I did anything wrong when I converted the database to version 7 that could cause this problem.

Post deleted by joemacgruder

Hi I see many web sites using what i call a Where You Are Directory Path with url's to navigate back like the example from eBay "Home > All Categories > Business & Industrial > Construction > Building Materials, Supplies" How can this be duplicated in FM?

I've read other posts but none are working for me. I'm building a simple inventory and want my quantity field to count how many records contain the same model number of the record being browsed. We may have 10 of the same item, but each needs a different record because of different serial numbers. So I tried the count(solution::model) and that is not updating the quantity like I'm expecting it to.

Hi Guys, need a little help. I have a table with 8 fields, the first is what we call location numbers, the second is employee names. There are a multiple employees assigned to many of the locations. I need to show all employees in one field "maybe a portal" by location. I want to link this information to another table, if you can help with the employee part., i can do the rest. Please Help!!!

I am still wokring on more reports. I found a useful thing to have on the reports is a little section that contains what exactly i'm looking at. For example, if I was looking up hours for a certain project between certain dates, it is useful to know what dates i'm looking between. Is there any way to set it so that the layout prints out the "Find" contraints used?

When importing photos, I choose link but the paths are coded as absolute. If I burn the fp7 database with it's linked photos to a CD, the images aren't found because it's still looking for my computer's partition/folder structure. I want to make it default to using relative paths when importing images or files into a container field. Any suggestions on where to set this?

I have an Access database that is currently still evolving as some of the uses people want out of it are changing. The last changes made it so I have to throw out alot and rebuild from scratch. It is a relatively small database so this haphazard method is not to bad. I decided to do the current rebuild in both Access and Filemaker because I would prefer to just migrate it over to Filemaker. I have several tables which are still usable and I want to import them all as a foundation for this build (the relations are not important they really started acting weird in access which is one of the reasons I am rebuilding). I was fooling around with things earlier and it appe…

Dear all, I have a text file that has a ton of names & addresses separated by one or sometimes two carriage returns. (There is also a carriage return at the end of each line) example: Tom Smith 12 Park Place New York, NY 10034 Bill Frankel PO Box 974 Mills Highway Minneapolis, MN 34387 Janet Parker UCLA West Wing Box 4343 Los Angeles, CA 94372 . . . Could someone recommend the easiest way to import this information into a simple Filemaker database ? I'd be happy with having each person having their own record, and getting the name into a "name" field and the rest of the address into an "address" fiel…

Is there any way to change several records at once? I have a database and I want to change all the records for a certain field and rather than doing every single record (78000+), it would be useful to change all at once. Thanks

i was just looking throught the business tracker to get a first look at some filemaker 7 solutions. I'm still not that impressed with the fact that you don't seem to be able to have frames. i.e have a single top menu and a frame below that which you can use to navigate to different layouts to via the menu ...or have I missed something and this is now possible? Does anyone have any good demo files that show off some of the new things it can now do over filemaker 6?: Thanks

Hi, I have recently posted this to the filemaker website as a bug. In FileMaker 7, if you have a portal where it needs a scrollbar, and have the portal have no border in between the entries, and you scroll to the last entry. And then press the scroll bar again, it will show that last entry sliding up but it also is in its original position. This problem is resolved however if you have the portal with a border. Hope FileMaker fixes this bug, because it seems kind of dumb to be forced to have a border in portals.

Hi I have need to display a shopping cart where the line item discriptons are from one to three lines long. When I place the items in a portal and leave room for three lines the spacing on the line items that are only one or two lines long have additional white space that i want to eliminate. I have not used FM since V4.0. I seem to remember placing html in a calculation field. Any ideas or hints on how to customize formatting would be greatly appreciated Cheers Gary Weisbrodt

I'm building a database that multiple users will be able to log into online. I've created a table for users. Each user has a unique ID#. I've then created related tables using their ID# as the related field. How do I make it so when a user logs into the database, it recognizes the user and allows them to only work within their ID#? Thank you in advance - Jon

I currently have a table of dates and if an entry is > a certain date, I want a calculation field named Status to be set to

Howdy, Ok, So I'm trying to keep track of personal leave hours earned and used. In the report, i want to display only dates that have a record of PL aquired or used, however, i can't figure it out and instead it displays all dates making the report quite long and ugly. Thanks for any support. Akira

I am trying to make a database that will summarise surveys. Each question has the answers: strongly disagree disagree agree strongly agree no onpinion I want to know how can i summarise the answers? i.e 5 Strongly disagree, 10 agree and 3 no opinion? I need to be able to do this for about 22 questions. Hope someone can help...

I have a database with mulitple tables. With one button I want to transfer a record from one table to another. Is there a way to do this other than copy and pasting into every field? Heathbo

In a Filemaker 7 database that has several layouts, how could you script a "back" button that would bring you to previously viewed layouts (and perhaps??? found sets :?) If anyone has any idea of how this is done - even at the very simple level -- i'm very curious to find out whatever I can. I tried searching for previous articles about this and didn't find anything.

Is there a solution that does NOT require FileMaker Developer that will automagically document my FileMaker solution? I'm not looking for anything complex, just information about which fields are where, which scripts refer to what, what is on layouts, etc. Any help/suggestions will be greatly appreciated. Thank you, Nancy

This will hopefully be an easy one, but I search around and couldn't find the answer. I have a DB w/ 20,000 + records. I want to find all records that have duplicate values in a certain field. Say I have a field called 'names'. I want to find all records that have the same value in the name field. I hope that makes sense, here is another illustration. Say there are many of records w/ Jane, Jack, Jeff, Karen in the name filed. I want to do a find, listing all records that are NOT unique in a given field. In this example, it would list records containing Jane, Jack, Jeff, and Karen. Can anyone help me out? Thanks!

I'm working on a fund-raising app for a non-profit group. They want to keep track of donations, pledges, etc. They've designed the DB, and I'm building it for them. However, on gift entry, there's one layout for gifts, no matter the type. I have a menu for type: pledge, pledge payment, matching gift, etc. I have a summary field on the gifts db that totals all the gifts by each person. So far, so good. However, if someone enters a pledge for $1000, then pays it off with two payments of $500, the total is going to show up as $2000... it counts every entry as contributing to the total. What we really want is a way to have two totals: all money pledged, and all…

i'm new to filemaker, can anyone help me? i'm trying view a subset of a number of repeating fields. for example, let's say repeating field WEEKS has been defined with every monday of dates 7/26/04 - 7/25/05, making 52 entries, but i only want to show 10 of these dates at a time, starting with a date that is selected in browse mode. i have made a popup list that shows all of these dates to choose from...now how do i make my layout dynamically show only these 10 dates? i took the specified date DATE1, and made a loop that went through WEEKS, incrementing COUNT by one each time to figure out the corresponding index number of WEEKS. question 1: is there an easier…

Hi everyone, I'm trying to create a packing list that its sectioned by Boxes and sub boxes. I will be shipping CDs, and each sub box will contain 10 of these. Each Box will contain a non-specific number of these sub boxes. Here is the format that I need the packing list to follow: Packing List SCOTUS Order Shipped 8/6/2004 BOX # 1 Sub-Box # 1 1

I've copied a page from preview mode and pasted into a container field. I'd like to then print the container field but everything I try comes out blurry. I've done this same thing in FileMaker Pro 6 and it's worked fine. I'm working on MacOS X 10.3 - FileMaker 7. Any help would be greatly appreciated.

I'm creating a Task table to store all the tasks I need to do for several areas. I want one place to go to see what I need to do. I have the tables: People, Organizations, Events, Projects, and Opportunities, all of which I want to create tasks for. I want to be able to view the tasks I need to do for all or any of these areas. I also want to jump from any Task back to the record that it is matched to within any of the originating tables. The problem is I can't link more than one table to the Task table. If I try to use extra occurances of the Task table, I get threaded links back to organizations for which I have people matched (I'm matching people and organiza…

Hello, some users of excel find it difficult to use fmpro because they haven't the possibility to create a crosstable or pivottable. ==> A crosstable is a summary of 3 tables. A little example. Suppose you have several buildings and you want to view how many studios, garages etc.are in the buildings. Table 1: building Table 2: elements (studio, garage etc) Table 3: building - elements BUILDING A B C D E studios 1 2 4 0 0 garagaes 2 3 0 5 6 appts 4 5 5 5 5 The problem is that it should be easy to add a new column for a new building AND that (suppose you…

Hi, I am exporting FMP data into another program which cannot handle any carriage returns. One of the fields has tons of carriage returns in it: some of them are at the end of the text, some in the middle of it, eg. University of Blah Department of XYZ I have tried using the substitute function to replace all carriage returns with spaces, and it works for the ones at the end of the text but not those in the middle. Can anyone help?? I have already tried the FMP experts email list, but no joy there so far. The only person to respond couldn't understand why returns in the middle of text should be any different to those at the end.

I am currently using Filemaker Pro 7 and would like to use a Dymo Labelwriter label printer....very nice unit, but I'm not sure whether it works with Filemaker. Has anyone had any experience with this label printer? Thanks

Seems that once I convert a file from 5.5 or 6.0 to ver 7, the visuals on screen are too large...by about 25%. I adjust for this by having a script set the viewable screen size to 75%. I'm sure this is the incorrect way to adjust for this but it is a temporary fix. My question is two fold. 1. What is the "standard" screen resolution I should be using? 2. What is the correct way to have converted files show on screen correctly?

The bug I found is about the Substitute Function However everyone can check himself: 1) Create a new fmp7 file 2) Define 2 simple text field (text1 and text2). 3) Create 1 simple Script in which Set field text2 as Substitute(text1; "sometext"; "someothertext") 4) go in browse mode and fill text1 field with text to reach more than 4.000 chars (obviously u must insert the word "sometext" of the Substitute function above.) 5) Run the Script and unfortunately you'll find in text2 field the word "someothertext" doubled (practically "someothertextsomeothertext") Please may anybody check it and give me a feedback? Thanks guys

I am trying to create a quote software for my company whereby I have created a unique ID# when the clients name is entered then you switch layouts and enter a room name and then you enter individual line items into a portal under this area. Then you enter a different room name and enter new items in the portal (etc. until you have entered all of the room and items necessary). My problem is keeping the unique ID# populated with the current unique id# in the room layout so that the room names are related to the current client. I can manually enter the number but I cant figure out how to autopopulate this field everytime I create a new record. I need this number to stay the …

I have files which I need to store for 10 years or for ever. If it's for 10 years, file storage will end 12/31 ten years later. Is there a formula which gives me based on the "end"-date of the content of the file (say i.e. October 10, 2004) either an expiry date 12/31/2014 (it must be 12/31...)or - if its for ever - a date like 12/31/2999??

Greetings! I'm new to the forum and glad to have found it. I own but don't currently have installed FM Pro 5.5. A couple of machines ago, I realized I wasn't really using it so didn't bother. Now I'm thinking about it again and also thinking about the current upgrade offer. Hence the questions. My primary use for FM would be as a digital image catalog. I've seen reference to that on the FM Page but no real information and I really, really need to know what file types version 7 recognizes. Specifically, I need to organize several Canon RAW photo types, primarily TIF and CRW images. I tried every search algorhythm I could think of but couldn't come up wi…

hi~ i am having a problem, yet again (yes ;-)), with printing tables with grid in IWP. apparently, the table view in Inernet Explorer shows grid, but when printing out the the page grid is gone... any idea how to fix this or..?

Hope someone is on at the moment (or soon)... I've done something dumb and can't get out of a validation loop. I have a zip code field defined as a required value. In experimenting with some other matters I created a portal that allows the creation of records in that file--but I didn't put in a zip field--nor had I yet added a delete row button. Now I have a record that I can't complete (no zip field) and can't revert or delete. I *do* have another window open for the same file, so I can access ScriptMaker. Is there any way out of this other than pulling the plug? Any help urgently appreciated. I'm leaving it open for now... RDecker

Filemaker 7 has crashed on me a few times... it is a repeatable crash. I'm using FP7 to connect to a file hosted by FP7 Server hosted on OS 10.3.3 The layout I was using was a business letter had a global container field that was supposed to be displaying a graphic (a signature) that was meant to slide up/down with the text of the letter. The graphic was a pdf imported by another user. She was able to see the graphic on her machine, I was not able to see the graphic (all of us on OS 10.3), and when I clicked into the container field, Filemaker crashed If anyone can tell me what's going on, please do !! thanks crash log: Date/Time: 2004-08-13 15:46…

If you view pretty much any layout in Layout Mode, It shows some kind of alternate text instead of the field name. What is causing that?

I've been using Filemaker for years and always used the copy/new record/paste methodfor creating additional related records in a related database. This always bugged me because you would loose whatever you had on your clipboard. Then, I learned the portal trick (goto field, goto last repetition, set field). That is certainly better but it still requires portals in the UI that we don't want. I'm wondering if anyone has found anything new that makes this any better that doesn't require spurrious interface items. Thanks for your help! Eric

Is there a way to NOT use portals if I want to have multiple records for the same ID shown? An example: I've got a participant number. Each participant number is unique. Each participant can have more than one appointment, but they may just have one. I'm trying to design a summary layout. I'm using the participant table to show most of the data but there are other tables from which I'd like to pull out data. As I said, each person can have more than one appointment but I can't figure out how to get the layout to show me more than one row if I don't use a portal. Is this the only way to get a repeating field?

I have a database that is being used on both Mac OS X and Windows NT 2000. In one of the tables I have an 'insert file' button. This allows the user to insert a .pdf file in the database stored as a reference. Here's the problem: When a Mac user uses the insert file button, other Mac users can access the file fine, but when a Windows user tries to access the same file, a 'file not found' error appears. The exact opposite is true if a Windows user is the one who inserts the file. I know about hard wiring file paths for individual files. Is there a way to get FM Pro 7 to create file paths for Windows and Mac on the fly, without my having to go in and specifically type in th…

as stated.~ :-p

hi~ this is yet another problem that i cant find a solution yet... for some reason the layouts are extended when being viewed in IE, and when one wants to print, the scroll bars appear! i figured that it's my layout that seem to be out of the margin, but even the ones that's within the margin is doing the same thing...

Hello, I have a self join relationship that I use to find a value in a field that the user requests. This all works great, except when I export to either XML or Excel. My numbers are not formated. They are just like I entered them. I have it relating to a layout were the numbers are formated and I have make sure the check box is checked to pass on the formating to the export. This is driving me crazy, the same export procedure works great if the export does not need to be related by a self join. What am I missing. Thanks for your help on this.

in the database that will update as I update the data in the record? The insert chart options don't seem to allow for this. Thanks, Vascular Researcher

Hello, I develop database applications using FoxBASE+/mac 2.0.1. This is a very very old database system that is nearing the end of the road (even though it works in Classic.) In looking for other solutions I am also considering FMP. Can you point me in a direction or give me your comments on this issue. Does anybody have experience in porting FoxBASE to FMP? Where should I even begin? Thanks for you time! Danbo

I have 2 fields in a table. Basically I need: if(Value in Field1 in any other record = Value for Field1 in new record) AND (DATE in Record = Date in new record) then disallow the creation of the new record. Please help me. I'm not that familiar with FileMaker. ~Jake

Ok, I'm new to Filemaker, and fairly new to databases in general. Here is my setup: I have a table called "Master List". This is a list of all contacts. I want to have 2 other tables, "Members" and "Leaders". Those contacts in the "Master List" that are members, I would like to dynamically appear in the "Members" table, and likewise, those contacts in the "Master List" that are leaders, I would like to dynamically appear in the "Leaders" table. Contacts can be either Members, Leaders or Both. I have yes/no radio button field in the "Master List" for both Members and Leaders. Is there any way to dynamically generate a table based on those contacts that have "yes" f…

I am having a problem with a calculation that is not working on the repetitions of a repeating field. it is to track a magazine subscription info. it works like this: 1. a date is entered in the 'invoice paid date' field 2. a field called 'first sub issue' then looks up the next value in another table which has all the dates for every issue published. [ie, if invoice was paid on 10/5/2004 and the next issue was published on 20/5/2004 and this is issue number 4, this will be the calculation result.] 3. a field called 'last sub issue' simply calculates 'first sub issue'+9. This all works perfectly in the first repetition of the fields, but not in any of the oth…

Hey guys, I have used FM5.5 in the past, but very, very limited stuff. If you look at the FM7 Inventory template you can see a tab at the bottom that says Acquired Info, what I want to do is add another tab to the right of that that says Resale Info and another to the right with Installation Info. Each tab will have it's own information pertaining to the product such as MSRP and some end-user related notes under Resale Info and a product list ( installation accessories, X Recommended X Required) with links to those Inventory items as well as installation notes under the Installation Info tab. I really need to pick up a book on FM ( any suggestions? ) but in the mean ti…

hi all. how does one make a find request within a portal and show only the found related records in the portal? i tried several times but it doesn't seem to work and keeps on showing all records in a related portal.

I'm new to FM but not new to databasing. I've got experience designing and programming PHP/mySQL databases, so I'm pretty decent at coding. I don't love it but I can do it. I'm currently working on a database for my clinic so that we can track patients. It's pretty basic stuff, thus far. Just contact info, dosing information, schedules. The reason I'm using FM instead of mySQL is that it's a pretty elegant solution for designing a UI to the database. I like how easy it is to use. My question is this: What do I need to get this sort of system up and running. Currently, I'm just using the demo version of FM7. In terms of deployment, I'm going to have several diff…

Any tips on troubleshooting this one? (I'm prob. doing something wrong...) I have a field validated and entered with a value list (pop up list) as either Yes or No. I can find based on those values manually with no problem, but when I try to script it, I get an error message, "No valid criteria." In the Find step of the script I specify "Perform Find [Restore]" amd specify: Finances::cleared: ["No"]. ('Finances' is the filename; 'cleared' is the field name.) I've also tried it with: [="No"]. Any help appreciated. RDecker

Thanks to Mr. Brill, I have series of Find and Constrain Record Scripts running on my data. Is it possible to enter text on the page that will state which scripts are currently running. I would like a summary of my sorts to appear in the margin. For example: Data sorted by 1) Technical Success; 2) Males) 3) Diabetics; etc. So that as the user examines the data, he knows the constraints on his data. Is there a function such as the <<field>> function that would print the script name on the screen? Thanks.

I am going to try and attach the zipped file again. Thanks to all who took the time to check it out. Dave EKGSTRESSTEST-6Copy.zip

I'm creating a grade book. I have a table that contains the scores of each graded item for all students, in all of my classes. This includes homework, quizzes, tests, final exam, labs, etc.. Each class may have a different set of graded items (some classes may not have a lab, for example). So in this table, I have a student ID, a class ID, the graded item category and the score. In a related table, I have a list of my students and on a layout I can summarize, using a portal, the total and average that each student has earned for each graded item category. No problem. What I'd like to do is create a field in my student table that will hold each of these averages…

Hey guys, I am a die hard MS Access man, but recently heard about FileMaker and am interested. I have a large database that contains a subjects photo and basic information with subreports containing more photos and detailed information. My questions are this, Can FileMaker handle large number of photos and info per person like Access? Do the databases become huge and bloated? I currently store only the links to photos in my databases to keep them very small and easy to work with? Any help is appreciated before I drop any cash. I have the trial version now to tinker with. Thanks

I recently moved (copied) an FP7 database containing over 6000 records of linked images off of an external drive and onto a hard drive so that I can serve it with FMS 7. I am hoping that the images can remain on the external drive. Does anyone have any suggestions on how I might update those links so that the images work again? Or maybe I need to re-think the structure of this database all together? Or is it possible to serve the original copy right off of the external drive, bypassing the need to correct the links? I guess this topic is relevant in the FMS 7 forum as well ...

I know this is going to be a simple answer but my brain doesn't seem to be functioning today. I want to make the current record the only record in a find so that when I use the replace function in a script that it will only affect the current record. I appreciate the help.

Hi. Never been a problem to enter a range for a query. Now I come across a solution where I should enter such a range AS DATA in browse (eg valid between the ages 0 and 12). In the past I used to work around this with 2 fields (begin and end of range) and I wondered if someone had tried something else? Range doesnt seem to work in browse. BTW, any idea to enter the data 'infinite'?? and thus (combining both questions) how to enter something like 'valid between age 50 and death?' Regards to every reader.

Have found a real show-stopper bug in FM7 re: import funtion on shared db's. Does anyone know if this will be part of the next FM7 release?

Can anyone help me write a script that allows me to find a set of records within the last found set. I have 100 total records for surgical procedures. I have a spreadsheet with totals for # of successes, # of males, # of females, average age, race, diabetics, smokers, etc. I have written scripts that will find just the number of successes and show the totals of males, females, etc. Now within that found set, I would like to further break down the data. For instance, how many of the successful procedures were performed on diabetic males, or smoking females, etc. Basically, I am asking whether it is possible for a simply Find Records script to fu…

Here is the problem that I encountered. I put it in two ways... illustrated and in words. If you can understand the problem in words, it will save some time... otherwise please read the illustrated way of showing the problem in an example. Word: ----- 2 tables related by a single field in which one allows addition and deletion of records depending on the other. When the field is changed in the primary table (the one that causes addition and deletion on the other) on the same record, the records on the second table losts its track. Diagnosis: relationship doesn't have the option of "if the field on the table has changed, it also changes the field on the field on t…

We use with FM Pro 4.1 Mac and FM Pro 6 MacOSX as ODBC Client and it works fine. Now I bought a update to 7 and want to use this FM pro 7 as a ODBC Client but it is not possible because this feature is not implemented. Comes this feature with an update or never? Maybe there exist a third party solution? Thanks.

Can anyone help me with the Remote Kerrnal? I have a database that I have converted and beefed up for rollout. Some of the files were FM 6 and 5, I converted and cleaned them up in FM 7 had them working perfectly. I then installed FM 7 on an OSX machine, I found the files on a client machine, I can open the files. however I cannot modify the records. I am told the remote kernal may be bad. any suggestions? I am also shy now to work too much in fm 7 not knowing when the kernal is going to be good or bad. Please help - I have 100's of hours in this project.

How can I add a user that can change all layouts and scripts except for removing the Admin or changing its password?

hi all, i have been trying to find out how to make cross tables (in layout) with much effort but no success. exactly how do you make a cross table, like MS Access's crosstab queury (i.e. a 2-D data table) in filemaker pro 7? your help is appreciated...

How?

Hi, I'm adapting the lending library template file to work with our library which lends out items to students. I'd like to set up a calculation so that a 20p fine is charged for each day that an item is kept after the due date. The maximum fine would be

Hi I'm just getting started with FM7. I see the only Windows platforms they mention are Windows 2000 and Windows XP. Will FM7 run on Windows NT? I had thought (mistakenly??) that Windows 2000 was derived from NT. Thanks for your help. Walt

I have just begun using FM7 and it takes about 80 secs to startup. Has anyone else experienced this and is there a fix for this?

Okay,I have a database for summerschool registration that I'm working on, I need a report to generate a list of students for any class that has been entered into the "Class" table so that if you would Select "Science 101" or similar you could call up a list of students in Science 101 any ideas?

I have a Purchases DB containing 2 tables, the first table (Purchases) contains the order information and the second table (purchasesItems) contains the line items to that order via a relationship [PurchaseOrderNumber = PurchaseOrderNumber]. My Question: Is there a way show related line items from the current found set in the Purchases table. Example: If the current found set in the Purchases table displays say Purchase Order numbers: PO.0001 PO.0004 PO.0020 I would like to create a GoToRelated or Find script which would take me to the PurchasesItems table and display all the related line items from the current found set above.

Goal: Easily convert all ole objects imported into plain text. Background: MSAccess database/table has ole objects which is used to store RTF (Rich Text Formatted) data. Since MSAccess has a very short limit on text fields, the developer used an ole object. I have purchased Filemaker 7 Developer and can import the MSAccess database/table via ODBC. Once I have completed the import, I could select each object (filename.dat)(one at a time) and right click to get the "export field contents' which will place the ole object into a separate file with the name of the ole object (filename.dat). I need the ole object on every single record (119) converted an…

I run a small fencing school. My little DB now has about 7 tables, with more than that replicated for setting relationships. I have a contact table with a contactID (key) and e-mails, phones, etc. I have a student table with various data. Each entry in the student table has the studentContactID of the student (the key), and up to two others -- one for parent1ContactID and another for parent2ContactID. I have a ClassList table with records that contain a particularClassID, a studentContactID, and other information. To obtain a list of students in a particular class, I simply find all entries from the ClassList table with a particularClassID. I …

I am going crazy. I'm sure that there are many posts relating to this subject but I cant find them. Someone please help me. I have two tables (FMP7) One is manufacturers and one is products. I want to choose the manufacturer and then only get the items related to that manufacturer when I am in a table I have named QUOTES. I have related the manufacturers and products table with a field called MANUFACTURERS_ID. I have defined a value list which should only relate the product to the manufacturers table and it only returns <no values defined> from the products drop down list (in the portal, in the quotes table) This is killing me. Please help. And put it in the easie…

Check this out : Where "Index" = 3 FM 6 : 10^((Index-1)*7) WORKS! = Returns "100,000,000,000,000" FM 7 : 10^((Index-1)*7) FAILS! = Returns "1.0e+14" FM 7 : 9^((Index-1)*7) WORKS = Returns "22,876,792,454,961" Are there any maths bofins out there who understand why it no longer works in FM 7?

Hi all, I'm trying to use valueListItems(relatedField) to record data from a related field. However, this command only return distinct items. The function will ignore any item that is similar. For example: If I have 2 items: "01/01/04" and "01/01/04", valueListItems only record one "01/01/04" and ignore the other. Does anyone know how can I get around this problem? Thanks, H.P.

Can anyone tell me if it is possible to use a runtime FM solution as a frontend to MySQL ? What version would I need (I am currently using FM 5.5 Developer) The bigger picture is : - I need to develop a networkable, non-web-based database system, for between 2 and 10 users (MySQL) - I want as rich a user interface for the frontend as possible (... FM) - I need to develop the thing very quickly (FM) - I need to minimise costs, as low as they can go (... using runtime instead of full version) - I want to eventually migrate the thing to a web-based solution (MySQL) I had a very quick look at Servoy, but found that it would be too expensive. Thanks much …

Hey all, I'm developing a multi-location inventory solution using a number of tables, 3 of these tables are: 1) Item - with fields Item# Description 2) Location - LocCode, Description 3) ItemLoc - Item#, LocCode, Quantity There would be a record for each item in each location. So if there are 2 items (1,2) and 3 locations (A, B, C) there would be a maximum of 6 records(1A,1B,1C,2A,2B,2C). After I create a new item in the Item table, I would like to create a record in the ItemLoc table if there is no matching record already existing. The solution I envision but do not know how to create is for a the user to be able to create a new record in the ItemLoc ta…

For Windows version of FileMaker Pro 7 trial version (English) when I run the updater the following Windows Installer error message comes up - 'This patch package could not be opened. Contact the application vendor to verify that this a valid Windows Installer patch package.' FileMaker Pro 7 and all other applications are closed. I wasn't asked to put in the original Windows XP disks. The patch package download is 'fmp_70v2_win_updater.zip' and 114,088 KB in size. There are still 24 days to go on this trial version. The only thing I can think that might cause this is there's also FileMaker Pro 6 on this computer. Any suggestions?

Hi I have a problem where the bounding box that is the actual field under a button (if it is a graphical button) shows up when I don't want it to. Is there a way to turn those off? They are just lines that indicate the actual field of "hotspot" under the button. Thanks STan