FileMaker Pro v7 – v11

Hi, I'm currently trying to convince my employer to get FM 7. I have used FM 5 in the past and even set up some simple db files. If all goes well, I hope to be posting some questions here soon For now I'd like to know how the advertisers at the top of the Forum page can sell FileMaker so inexpensively. Thanks, Deborah

Greetings - We recently converted to FM7. We are having dificulties with searches: 1) Searches on calculated fields are producing result sets of all records or none. We have a calculation integer field that produces a 1 or 0 depending on criteria, then we search for a 0 or 1 depending on what we want to find. Searching for zero produces the result of all records. Searching for a 1 produces no records. The field contains both 0 and 1 (doing a sort on the field shows both values). 2) No matter what field I choose, wildcards are not functioning. Both the * (asterisk - something there) and = (equal - empty) are producing no records found. Any one have any …

I've tried to create an "Advanced Find" feature in my database that searches on 10 fields in my solution. I've tried 2 methods... 1. The first is a 2 part script that enters the user into find mode for them to type their find criteria part 1.. brings you to a search layout, then enters the person into Find Mode part 2.. Triggered by a "Search" button..performs the find and if there are results, brings you to a results layout the problem with this was that after part 1.. if the person hits "enter" it just completes the find and the person is left with their results on the search layout! If this is the best way to go, is th…

I'm trying to create a music schedule that will view all musicians scheduled to play from todays date and all dates in the future, in a portal. My tables are Music Schedule and Music Schedule line item. My relationship is (Music Schedule) "Todays Date" greater or equal to (Music Schedule line item) "Date". I want to be able to schedule musicians in the portal, but when I type in the future date in date field, it reverts back to todays date. Thanks for your help!

How do I display dates > or = todays date in a portal? I have created a music schedule using 2 tables, "Music Schedule" and "Musiclineitem". I want to schedule vocalist to sing on certain dates, but I only want to display dates greater or equal to todays date. What is the best way of going about this in Filemaker 7? Thanks, Sam

Hi, I have a serial number that's part of a larger code. The number is basically a location code, year code, and serial number code... so "USA 04 1234" would be one example. The three components are all separate fields. Problem One. I wanted to use a portal to retrieve a summary field from another table, but then I realized I couldn't just reference the serial number (the 1234) itself because there are potentially two "1234", one for 2004 and one for 2005. So how do I use a portal? Can I reference via two criteria... the 04 and the 1234? Problem Two. I am used to the primary key concept in MS Acce$$, and one of the reasons why I like FMPro is that yo…

Greetings - FYI... When printing multi-page scripts I am getting a blank last page. In other words, I have a script that prints three pages and I get a third page that has a header and footer but no detail lines. Can someone else verify this behaviour? Thanks In Advance

Lets see if I can simplify that: DataBase A DataBase B rec_ID == link (relationship) In order to establish all the records in DataBaseA that are NOT related to B, my idea was to kind of "invert" their relationship. But how? I need to get all the records where link::link is empty... right? I tried it get these records, introducing the field: checkout_link = link::link and the self relationship in DatabaseA: checkout_link =/= rec_ID as the relationship but it doesn't work. Why? Checkout_link is supposed to be empty... I can get these records in find-Mode (seeking for the empty link::link), but I want it to be done with …

Hello, How can you custom sort a radio button set? It appears as though the program defaults to sort alphabetically. Greg

So I have upgraded to FileMaker 7 which has solved a lot of my problems from 6, but I need to convert my 7 file back to a 6 for another client. Any way of doing this? All attempts I have made have come up lame. Thanks in advance. KE

I have been charged with a project. It sounded fairly simple at fisrt but it seems to be getting more difficult by the minute. I'm completely new to databases. What I need to do is make a contact DB in which you can sort by different criteria. Sounds simple so far. In fact, I think there is a template built right in. Here's my problem: I need to be able to sort by different criteria and then be able to send mass emails to the resulting list of clients. ALSO, I need to be able to print mailing labels the same way. I first looked into this with Access but found there was no easy way to do this. someone told me Filemaker can do it but I'm finding little evidence in thes…

Well time for another problem. I have a database set up with a product table, line items table, and invoice table. It works fine. Now I would like to take it one step further. I would like to make a purchase order table, and keep track of quantity of items on hand, in the product table. So I make a table with vendors: kp_vendorID product product # price then a purchase order table: kp_POID kf_vendorID P.O. # extended price Total Tax etc add a kf_POID to the original product table and a quantityonhand field.. When that is done, and a Po is created where do I put the calc to increase the total in stock in the product table? Is th…

Made an earlier post and couldn't find it... Can someone help me with 7.03 update installation? Downloaded the huge file and tried to install it by clicking the setup.exe file. When I did I got..... Windows Installer Dialog box saying... Incorrect command line parameters Windows Installer v2.00.2600.1106 Portions of software are based in part on work of independent JPEG group. All I can do is click OK and close the dialog box. Any help will be appreciated. Thanks Mike

Hope this isn't too stupid a question, I'm no database expert. I need to update/combine a database with new information. I constructed a database (extremely basic voter information for a school levy) we acquired from the board of elections. I imported it directly into Filemaker and manually added phone numbers that we needed for contact info (phone numbers are not included in the original data we purchase). Each year, we get a new database from the Bd. of Elections and I need to update the phone numbers (along with a few other simple fields). Is there any way to match up the old information (name, address, phone) with the new voter data matched to the correct name, addres…

Hi, I realize that FM7 is not compatible with Windows 98 but is anyone out there using some kind of workaround such as remote access software or virtual pc software in order to enable the last few stubborn holdouts with Windows 98 to use FM7? I have a very important user that has already told IT he wants to keep using Win 98, since he owns the company I work for it's not like I can tell him to upgrade. Any help would be greatly appreciated.

You all probably know about the FM promotion where you buy a copy of FMP and give them the name of a friend to get a free copy. I'd really like to take advantage of this deal. Anyone wanna go in with me on a copy? I've got an educational discount, so it'd be $75 each. Lemme know. -t nb - I don't think that there is anything even remotely sketchy about this since there are no restrictions about who gets the free copy or what the "license" is.

im having trouble inserting a company logo (PDF format) onto one of my layouts. when i try to insert the file, i only get the icon along with the file name underneath. should i be inserting picture, object, or file?

I heard there is a way to publish a series of events (date, event, time,venue) from filemaker to the ical calendar. Can filemaker be used as suscription server for iCal? If so, how? Thanks

I've built a layout that I love, but it takes too long to load -- it loads in list mode.. and looks kind of like a spreadsheet but with lots of cool bells and whistles... I'm thinking I can dramatically reduce load time if I only load the first 30 records at a time and then have a "<<prev 30" "next 30 >>" option to scroll to the next/prev page of records. Could someone tell me the basics for how this is achieved ?

I want to be able to reverse the last change a user has made. Maybe the solution is incredibly easy and I'm just not seeing it

My main database file is severely damaged. Not only that, but whatever it was that corrupted the file, was saved with the backup copy as well. The data is still there but the table occurances in the graph have disappeard and all of my layouts give me the "table missing" nightmare. When I go into the graph and attempt to recreate the table occurances, it tells me that the name is not unique. This implies that the info is still somewhere in the file. I've tried running the recover utility and it tells me that the file was not created by filemaker or is severely damaged. Does anyone have any advice?

How can I set a script to re-lookup only in the current found set? Actually what is the best way to Create a new invoice record for every existing costumer record and do a (re-)lookup?

I am stumped why this isn't working. I hope someone here can help. I have 2 tables. Table 1 has a field named "Value". Table 2 has fields named "Total set value", "Value used", and "Value left". I have a simple script that checks to see if Value in table 1 + the Value used in table 2 is > than Value left in table 2. It looks like this If[(Table 1::Value + Table 2::Value used) > Table 2::Value left] Beep End If My problem is that the computer continues to think that Value + Value used is always > than Value left. Even if Value is set to 1, Value used is set to 2, and Value left is set to 100. Maybe I'm missing something. Any help given is …

Here is my issue: I have 3 tables, let's say Clients, Client_Relatives, and Client_Past_Address. I want to create a report in the clients table that gives me all of the related relatives and all of the related past addresses in one report. I am unsure how to do this. Can anyone help? Thanks in advance!

Hi all, i'm planning to develop an small applitacion (5 to 10 DB tables) using File Maker Pro. I used to develop applications before, but i'm new to file maker. I would really appreciate any recommendation about which documentation i should use (books, etc...). thanks in advance for help

Has anyone conducted benchmarks of commonly used techniques to see what the actual fastest way of doing things is? I'm interested in learning how different approaches to the same problem compare with each other. Some examples of things that could be tested: Is a record-processing loop based on an if test of a counter value faster or slower than one using goto next/exit after last? Is using a custom calculation faster or slower than performing the same calculation in a script step? Is it faster to simulate an array by using string functions, or using repeating fields? Rather than just assuming, or listening to conventional wisdom, I'd like to collect some ac…

Sorry, this isn't very Filemaker related but I'd really like the input of this community. I've only become interested in systems because of Filemaker. I've gotten a lot deeper than I had thought I ever would.. and hold a position that is very Information Systems Management related--- but I kind of fell into it. I love designing and building the systems... my question is.. I want to pursue more education.. perhaps a masters.. Maybe an MBA/I/S Masters or perhaps even some sort of Ph.D. or Computer Science degree. My undergrad degree was in bioengineering... with very little computer programming studies. Do any of you have any leads about any really …

Is it possible to use check boxes with value lists to input into a repeating field? Right now I seem to be just adding more text to the first repetition.

Now that my DataBase is really working nice, I start to worry about secondary aspects. One thing that bothers me for quite a while is the constant flashing of the layout, while aparently nothing is happening. It's like a refresh of the window, but sometimes comes like a continious flashing (2-3 times, 2-3 times in a minute). It seems that ever since I disactivated that "show field borders when record is active" tag in the layout Setup, this flashing appears less frequently... Whats the reason for the activitity while apparently the Database is "idle"

How can I stop the Closedown Script with a function ? My situation: I've got several Layouts but only ONE is allowed to be closed on! (because of Scripts) Appreciate any Help!

Hey, how can hide the (File, Edit, Insert....) bar? I need to hide it because the user is NOT allowed to Delete anything without a Password! I also need to know how to block the Contextmenu (right Click). Thanks for youre Help in Advance!

A question that I have in mind ever since I work with Filemaker. Clicking somewhere, anywhere, where there isn't any object often helps me to.. - make ugly field borders disappear - force calculation of a self-related field in some wicked Databases - ... how do I create the event "clicking on no specific spot" with the scripting features? I used to do dumb workarounds like opening and closing the Scripting tool, which gives me for some reason the same result, but I think its time for a smoother solution Martin

I noticed that if I put a text field in a portal with @@ it shows a running count of the records displayed in the portal. What the heck is this feature? I can't find it in the help, and are there more? Dave

Didn't know where else I could post this question, If somebody could help or direct me to a forum more suited let me know! Question/Problem: FM7 seems to shut off Font Reserve. I'm using the latest versions of each on Mac 10.3.4 - It happens on 2 computers in my office. Can't seem to find issues out there besides me. Anyone have this problem? goin' bonkers! Dan

When going from one file (displayed on th desk top) to another file (hidden), end up with a displayed window and a hidden window for the same file. This causes the displayed file window to loose the hand pointer over buttons, and the show hidden list won't respond appropriately (ie. the duplicate window name is at the top and below are the other window names; when I click one of the names in the list, the item below is shown rather than the selected one). Upon opening, all files have an opening script that make sure the file is on a blank layout (no access), the window tile is set to file name and then is hidden. My script in fileA is: perform (external) scrip…

I could have sworn I posted this yesterday but I cant seem to find it so if it's a dupe please disreguard, if not here is my problem: I have a database with auto entered serial numbers, the problem is I need to be able to enter numbers out of order as well as have the auto entered serial number pick the next free number. So far the auto enter works fine and I can enter an out of order number just fine, but when the auto enter gets to an out of order number that already exists it will still pick that number, I need it to skip numbers already in use... is this possible. Thanks.

This may alient professional developers; sorry if it does, but I have a fp5 file solution that was cheap to buy, but expensive to add users, so I am torn between continuing it or just starting over with something that will let me add additional users at no extra cost, save the additional fp7 software. I have a small business; every bit helps. My question, does a migration from 6 to 7 allow me to add seats to a single user file, or is this code buried somewhere that is not accessible, except to the original developer, regardless of the version.

Post deleted by Jamie Dahlstrom

I'm wondering if anyone has a good, helpful location to bookmark for reference when various errors are encountered with FM. Currently I am attempting to add a record to an FM table and am getting the following: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL I am a very novice user of FM, so excuse me if this is an easy one for you gurus. The above record creation was in an attempt to insert values for only a portion of the columns, not all. My initial thought was that there was a "required" column that I was not including on the add. However this does not seem to be the case. Here is …

I need some help being pointed in the right direction for a filemaker 7 solution that I am working on. I have been using filemaker for a while, but have just started working with portals in the last few months. I am working on creating a problem tracking system and here is what I want to do. I have 2 tables - equipment and problems. On the layout for the equipment table, I want to have a portal that will show all problems associated with that piece of equipment. I want to have a "new problem" button on that layout which will take me to the problem layout tied to the problem table. When I get to the problem layout, I want the devicename from the equipment table t…

Guys, I need some help here, I am totally new to FM, and I am not a DB expert, so I use the filemaker's template for Home > Photo Catalog database to store digital pictures... all works great, the problem is when I try to open a remote database... the database opens great in the network, but the images won't load... any of you knows how to fix the issue? The error is "file not found" in the image field. Where is the problem exactly? TIA, Steve

Does Filemaker have an easy way to copy a record and it's related records without having to do it all manually? I have a program that's used to enter quotes, the quotes are extremely complex with many related databases, my users want to be able to generate a new quote based on previous ones if needed since it can take up to 20 minutes to enter some of these quotes (they're for very complex fabricated parts). Thanks.

Is it possible to duplicate a table so as to avoid haveing to re-enter lost of fields? Kirsty

In fm 5 I used to be able to go to excel and get external data which would bring across data from fm complete with the field names. However I cant do this with fm 7 is there any way to export data with the field names attached? Kirsty

Why can't I change the font to webding anymore? After my upgrade to FM7, former fields using the webding font work fine, while new fields won't accept any change to wingding fonts. A warning appears informing that for storing reasons the field can't be set to that font. But this just Layout!!!!! To bypass this protection the user could keep alt-control pressed while changing the font. Would be nice, but it doesn't do so! Any comments? Cheers, Martin

I am haveing some problems with printing. I carry out a find then create a new layout useing the report setting. I can seethe data I want on the screen but when I want to print it, I only get the first line of data. What am I doing wrong?

I am using an unstored calculation to show how much of a check needs to be posted. The calculation is as follows: Amount - Sum ( CashReciepts::AmountCredit ) where the amount is in the parent file subtracting the sum of the credits in the related file. Works like a charm performed in the same file where the data is kept. On the contrary, through a file reference, sometimes the calc refreshes and sometimes it just doesn't feel like it (Until the calc field is entered) . I have the layout set to save changes automatically. I don't know if it's a bug or what, but it seems there are some small differences how files act through references and when data and interface ar…

I would like to keep a history or log of remarks that are entered into a specific field. Is it possible to allow a specific user to create a remark and then once they have left that field the remark cannot be modified? I need a history for a helpdesk like application. I need to be able to see all the remarks that have been entered as well as the date. Thanks for the help!

How do I remove the dotted lines that appear around all fields when I enter into a field? Thanks for your help! Sam

Hi everone!!! Im trying to figure-out if there's a way to programmatically check when a field out of 12 field was modified. I would like to know(via global field maybe) as soon as data is changed or added in a field on a layout. so if i have about 12 fields on this layout, i want to know when one of them is modified, and it can be anyone of them, its random. So i need code that could keep an eye on those fields, and the minute one of them is changed, i get a flag. Can it be done. Any ideas, tricks etc are more then welcomed and very appreciated. Thx. Pat.

is there any way to completely lock out accesss to the status bar?

I am starting to open my eyes to building preferences for my system... wow are the possibilities cool... I have a field in an accounts table called "group" I want to be able to assign each user to various groups: data entry manager director each with different privileges. Can I have the "group" field be a simple text field, and then if I want to assign someone to more than one group, just enter both group names delimited by a carriage return ?? I guess what I want to know is, can I easily test for Does a field = (or maybe contain) "y" when that field might contain something like this: g p x y z

I just upgraded to the latest version of FM (7.0.3 i think). Now when I paste text from web pages the text retains the formtting - bold, fonts, colors etc. This is a feature I definately do not want. Anyway to turn this off?

I have a repeating field.. with 5 repetitions. I want to make a script which, using a script parameter, will operate on each repetition of the repeating field. the script will simple insert a date if the field is empty for that repetition.. How can I do this ?? thanks

Hi, I have both FileMaker Dev 7 and Filemaker 7. I use dev 7 on a Mac, but am trying to use FM7on Windows. On Dev 7 I see it the toolbar there is the filemaker option where I choose filesharing. Where Do I do this on windows using FM7... and PS I am trying to use it on FM Server 7, I am new so please be patient.

Hi, I've been thinking about this problem for a while and I can't think of a way to solve it on my own!! I want a report grouped by department with a count of the number of students ID's in the department. Currently my records have multiple entries of student IDs. For example: Department of Education: 295321 295321 (same as above!) 456372 Department of Science 342133 342133 (same as above) 675432 Currently my report looks like this: Department Count Department of Education 3 Department of Science 3 I made a summary field on student ID. And this gives me a coun…

I just noticed on a test PC system that my popup layout select will not scroll beyond the screen height, as I develop on Mac, I never noticed this in the past. Is this a known problem or do I have something set wrong the on the PC. I'm using developer 7.0.3 and WinXP on the problem system. Rod

I have a solution with several tables and each table with several fields, is there an easy way to import the data to the new solution version everytime I update the solution?

I have a repeating field stacked vertically.. I needed to conserve real estate, so I turned it down to 9 point.. and have tried to make the fields as vertically short as possible.. when I click into the field though, the edit box that shows up is a bit offset. It's only about 2 pixels, but since the field is 9-pt text, it's visually pretty bad looking.. I've attached a screenshot to show you what I'm talking about.. any ideas how to fix or get around this : FYI.. the reason the edit box is pink is because i'm using the technique whereby you set the background to a color, make the fields transparent.. and put them against a white background so that the fi…

...an IRC Server ? It would be so amazing, if you could Chat live with one another or not ? WIth a simple app like this: http://www.hydrairc.com/ (PC) or http://www.snak.com/ (Mac). Thanks for your suggestions.

Hello I am using filemaker 7 but when I email from my file it always includes my name and address from my regular email account in Mac Mail. program coming with panther. I would like to use my anonymous yahoo email account as my header on outgoing mail. Is this possible and how? Thanks STann

I've hosting a database on FM Server 7 over a fast network.. The database only has about 1000 records in it. But, it has about 12 tables, most of which have fewer than 30 fields, however, the main table has about 300 fields in it... plenty of which are calculated fields. I have a startup script which detects which user is logging on, and then does a find to find the recrords that person is interested in, sorts the records, and brings them to a spreadsheet layout (built in LIST view, it has a few graphics on the layout... (small graphics on each record for little buttons), and a few container fields that I use for highlighting the record.. the problem is…

Hey Guys, I was wondering if any anyone can tell me, or if there is a tutorial on how to create an exe from the databases you create in File Maker 7. I have a small program that I found, that was written using File Maker 6. Within its directory you have the exe file itself along with various .dll files. Obvious being a self contained program, although it was written using File Maker 6, you can take that program over to any computer, even if not equiped with either File Developer or File Maker, and run it like any other program. I liked the design of the program, so currently I am working with File Maker Pro 7, to create a similar version of this program, to suit my pati…

Hi. A client is willing to upgrade to Pro 7 but wonders if it will run under Server 5 (or maybe it's 5.5). Since I can't find any mention of this anywhere, I'm guessing it's not a savory option. Anyone know? Thanks! Lurm

I'd like a script to go to a window name, if that window is open, and if it's not, then open a new window and go to a certain layout ? How is that possible ? Is there something analagous to If IsOpen(Windowname) :

Hi, Can someone help? What is the script statement for doing this please: if window "Invoice" is not present or closed, New Window "Invoice", h, d, ph, pv else goto window "Invoice" end if Thanks - I know it's got something to do with GetCurrentWindow or something but not sure what. Also, how do you copy from a field in one window into another window's field? I understand that you could have two windows open and be on completely different records, that stirs up a little fear of pasting into the wrong record - 'spose I can get around that but, is that correct? If you were to simply create a script that pastes into a field on the other windo…

I have built quite a lot of Custom Web Publishing-solutions with Filemaker 5.5 & 6 and have just recieved version 7. Now I am converting my solutions to version 7, but how can I test if my web-systems work now? What happened to Custom Web Publishing?? The manual only mentions Instant Web Publishing, which still, In my humble opinion, is useless for serious use. And I, of course, need to be able to test my pages before moving them to the server, physically another place in town. How do I connect to my web pages under FMP 7? Am I overlooking something obvious? Pleeease don't tell me they have removed this function from FMP 7! It is my main reason for using Fil…

I read this in a book. A find only searches in one table. You can set up an advanced find to look into several tables, but it will only return results in one table at a time. I am looking to use one exact copy of an interface layout to search into and pull up all records that have a mathing search term in all files. Example, I use find and search in a same name field for the word Beta, that should be able to pull up from several tables the matching field and all other feilds that were in those tables. The only way I know how to do this would be to combine ALL of my old table files from FM6, but I fear that would be a a mess of one huge file and b not a se…

Pardon my ignorance here, but i just can't seem to grasp the whole mutliple file vs. one file concept. I have a purchased multiple file application in 6, but it's too complex for my needs (advertising agency, job tracking, time and expense billing) so I was hoping to use some of the available solutions from FM and modify them. But that would mean having multiple files instead of one, which I have been led to believe is the real beauty of 7. From an "expert" standpoint, is it still "OK" to have multiple files? Or should I attempt to cut and past the tables from each file into one large file? I can have relationships between different files? But do those files have to be op…

Can I search a date field for blank entries ?

Can I force a user to use the dropdown value list on a field ? Note, I still want them to be able to type-to values on the list.. I just don't want them to be able to type something in the field (thus giving them the chance to try to enter something that isn't on the value list)

I can't seem to phathom why, in db preferences, there isn't the option to open with layout or run an opening script! Am I missing something? has it been moved? The reason why this is so dumb is because I have multiple windows and it seems to open with the last window that was at the front when the app was closed. This means I have to go to layout mode, open status area, select the right layout, adjust the window size, etc - all because on load I couldn't get it to simply run a script to take me to a certain window of a certain size. Surely I'm missing something here? thanks for your help

is there anyway of stopping a startup script from working before loading the database? I must be soooo stoopid - I created a new window in a startup script and noticed that under it there was another window there. So, I modified the script to delete the window FIRST before it creates a new window. Closing the window closes the database - I can't get in!! Help!!! What a perfect example of muippetry! Any ideas?

I am running FM Pro 7 in Windows XP. I have recently encountered a problem. The ctl+shift+d shortcut no longer brings up the define database window. I can still select it from the menu, but I can't bring it up with the key combination. Has anyone else encountered and fixed this?

I'm running Filemaker Server 7 on a Mac running 10.3.5, and am also running a few small MySQL databases on that machine. Could someone tell me what my options are for having Filemaker 7 read from, and possibly, write to, the MySQL database ?

Hello again! I want to know what I have to do if I want to autofill a field with content from other tables. Ok here I try to define my problem a littlebit exactlier (sorry for my funny english) Table A fields: userID; userName; userPath Table B fields: userID; orderStatus; item I choose in Table A the 4th record. Now I switch to Table B. If I make a new record in Table B, I want that automatic filled the field userID with the content from the 4th record of Table A field userID. I dont want to add the userID by hand it should happend automaticly. What have I to do for this? thx for any further help.

Hello guys! I plan to make my own DVD-archive. Please don't discuss like: "... there are good solutions outside ..." I WANT to make my own one . OK now my problem: How should I solve the problem if more than one user is using this application (database)?Yes they can work at the same time on the same Database, but I think that would never happen Following I planned before: One file; 1xUsertable; 1xMovietable; 1xMaintable the movietable contains all DVDs. the maintable contains calculations and some variables. And now the usertable? I don't know if I should make FOR EVERY USER A OWN table, or should I put ALL USERS IN ONE table. Is it possible to …

Hi there, am a novice so i am sorry if this is a common question...I have a database I made in FM Pro7 that i would like to use as data in Word documents (office mac 2004) the only problem is when I open the data merge manager and open the FM dialogue for data, it will not recognize any of my FM7 files, only my FM5.5....and i have lots new stuff with the new program! What have I done wrong? Thanks for nay thoughts and suggestions dillon [email protected]

I have installed the version 3 upgrade. Prior to the upgrade to version 3, in Filemaker 7 I had option to, when paste text in browse mode, to keep the text formatted as the layout was designed (ie: would not carry the font and formatting of where I was copying from, into the record, rather it would keep the formatting as you set it in the layout). Now it has reverted back to keeping the formatting of the where I copied from and I can not fnd option to make it keep layout formatting. - Arggg this is a pain in the butt and was one of the reasons I loved Filemaker 7, because you could achieve this without any scripting. I am thinking of reverting back to 7.0 but if any…

I'm trying to create a grid/matrix-style view for my current FileMaker project and would welcome any thoughts on the subject. Let me explain... I'm developing a system for a school. When a student signs up for classes, he/she has the option of paying over time. The student must be paid up by the time the class starts. So, I have an Invoices table in my file, a Classes table, and a Join table connecting the two. I also have a Payment Schedule table where the broken down payments due are stored. Let's say that John Smith takes Business 101. Business 101 costs $500. John will make five payments of $100. John also takes Public Speaking. Public Speaking cost…

I am trying to develop a method that will allow me to create an invoice in FM7 which has portal lines for the invoice items and will allow me to delete the whole record including related portal records if desired. However if the record is to be kept, it will assign the next correct invoice number to both the main record and the portal records to maintain the link. I have most of this working based on the main record being created with the ID field being the unique record number. When portal records are created they use this ID. On saving, the system increments a number from a single file table, grabs this number and sets the portal records to it and finally the main …

I can't figure out how to show one small window (eg pop-up help screen) over the top of a larger window. Using Go to Layout and Select Window commands, I keep ending up with just seeing one window. Is it possible to see more than one window from the same file at the same time? Thanks Philip

Hi, Has anyone noticed a few weird glitches on layouts? Like, 1. a portal list that is white on a white background with 0 point sized lines displays periodic thin grey lines every two or three portal rows. When you change the colour to a dark colour it is kind of alright but still hard to disguise what look like lines. 2. When you select a portal line and then not select it leaves a line across the bottom of what you pressed without refreshing. 3. When you have modifiable fields (Behaviour set to input and view on find and browse modes) - click and hold on the screen somewhere it highlights all the bounding box edges to fields that you can en…

1. Is there a way to transfer a callendar with schedules and to do items created in Filemaker into iCal? 2. Is there a way to transfer a spreadsheet created in Filemaker to Excel?

Am trying to install a 10 seat Filemaker 7 volume license on a Windows 2003 server, for use by Windows 2000 clients. The server is running FMP server 5.5 for normal use & the FMP7 is for testing, as we migrate our solutions to FMP7. The program runs fine, sitting at the server, but when I share the folder, even with FULL admin rights, I get "This application has been installed incorrectly or modified by another program. Please run the Installer to get a fresh copy of the application after determing the cause." I uninstalled, tried installing to the default C:Program Files directory, tried the v3 update, rebooted the server, stopped FMP server 5.5 services,…

I'm not sure quite where this question belongs, but I'm putting it here because most fundamentally, this is a question about v. 7's behavior... When I open a new window in a multi-table solution and go to a layout that is based on a different table that is related to the record on display in the first window, what happens? Does the new window display only the records related to the record on display in window 1, or does it show a different data set? I have a multi-table solution. In this solution, I navigate (using scripts) from one table to others, opening new windows as I go deeper into the system. So, a user opens a layout displaying a Customer record, which …

I have a relationship that shows the other users who are logged on in a portal.. I'd like to arrange the output so that the users aren't listed in a portal, but are listed similarly to how they're listed on this web site... Other users logged on: Tom Smith, Joyce R., Bob C., Frank A. Can I somehow concatenate the records that would otherwise just show up as rows in the portal ?

Is it easier to have multiple tables with many different fields rather than having one table with all the fields in it. Making it look like its another table. I'm soo disgusted with the complexity of multiple relationships within FileMaker. I think FileMaker should automatically create a relationship between tables when you create a field that equals a field in the other table. I find having to draw graphs is redundant. And then what sucks even more is I can't have more than one relationship between the two tables without totally screwing up my previous relationship. I'm starting to wonder why I even chose to use this pathetic program.

Hi! How can I make a calculation BETWEEN two Nummber-Fields ? e.g: If( "Between Field1 and Filed2"; OK; Warning) But you may have noticed the Between value is not valid. Please Help!!

I'm not using server. Is it possible for me to open FMP DBs remotely if they're in a previous version? Before I put FMP 7 on Panther, I was able to open FMP 5.5 DBs on OS 9 remotely from FMP 6 on Jaguar. Now it's beginning to look like I have to upgrade everyone (only three more stations, actually-) to move on. Thanks for reading this.

Hi, I am trying to create a report and I am having some trouble. I have Evaluation forms for different courses turned in by many students having fields - "Most Beneficial", "Least Beneficial" etc. I want to create a report grouped by the Course ID, containing all the fields in the Evaluation form. I've managed to get this far. So my report looks like: course ID 1 Most Beneficial : All Least Beneficial: handouts Most Beneficial: None Least Beneficial : Teaching Course Id 2: Most Beneficial : All Least Beneficial: None Most Beneficial: …

Is there a script step or plugin that will allow you to send a message to another user that is logged onto the database ?

The "Evaluate" Function; Evaluate ( expression {; [field1 ; field2 ;...]} ); is suppose to allow more than one field "trigger" for the evaluate function, but when you try to put more than "field1", eg. "; field2", it gives you a "Too many parameters" error. Any one else running into this?

someone can yell at me if they'd like for this question. how do i switch users without exiting out of FM?

I am trying to automate a message which will pop up if you enter a social security number in a text field. The text field is more or less an area for comments and may contain anything from one or two words to a hundred or more. I want to make the automation where it will not allow the user to move on until the social security number is removed. I tried using a pattern count like this........ PatternCount (CustomerInfo::Textfield ; /*###-##-####*/ (1 )) but that only works when a ss number has all 1's. I tried using the @ and # symbols but FM doesn't recognize the symbol as a "wild card". HEEELP!

Sorry, If this has been posted a hundred times, My brains hurting as I've been having loads of fun with FileMaker 7, understanding the new fundamentals. Im trying to rebuild an existing application that I've built with v6 as I think this is the best approach for me - converting was a real nightware. Anyway, I have created a text field called Type, and the user enters data into it via a value list popup. the valuelist contains for e.g. cat,dog,mouse etc, Is there a way I can enter Cat, but the value that is stored in my Type field is "C" (i.e. the first letter of the value for my selection. ) Thanking all in advance. Jalz

Hey folks Can I combine existing seperate database files into one master database? I have to get together an asset management system and I wanted to be able to give the Users, Hardware Assets, and Software Assets unique databases. I tried making a master list that contained all the fields I wanted for the three databases and then created three layouts accordingly. The problem was that I would create a record for a piece of hardware in the Hardware layout and then create a record for a user in the User layout but the two layouts don't share the same fields and when I went to enter a new user record I would mistakenly be adding the information to what seemed to be…

Is there a way to change FM installation number without reinstalling FM... Which file need to be delete FM Windows version... tks

Hi Guys! Got a small problem, as follows: Ok I've got Dropdown menu showing a few values out of a value list which is taking its info from a Table. Now the first record has an ID

How do I take the value from a summary in table 1, and show it in table 2? Portals don't work, creating a field that links to the summary doesn't work.