FileMaker Legacy fp3 and fp5

i understand i'm not approaching this in the most efficient manner, but i haven't seen anything else doing what i'm trying to do here. please help in anyway sample.zip

Is there any known maximum capacity in FMU v5.5? How many file can i host without any error or problem?

I've inherited a a sprawling (68 tables) FM database with many field definitions and relationships. I'm trying to get a handle on it all (running FM 6.0, not Developer), and I find it increasingly annoying that every time I open a Define Fields or Define Relationships dialog box, I have to resize the column headers so I can see the entire field name or relationship name or whatever. Along the same lines, in the Define Scripts dialog, some script steps (like SetField) are truncated such that I have to open the Specify Field dialog in order to see what field is being set. And the Perform External Script doesn't say what external script, just what file. Is there a…

Hi, Does anyone experienced this ? Sometimes, when creating a new relationship, FM doesn't let me open the "Reference" box for me to choose the right-side file. After quitting FM and having launched it again, it works fine. Kind of irritating... FM 5.5 on Mac OS 8.6 Thanks.

When I add a new record in a db, the record is added at the end of the file, so I sort the database in startup script to get the record in the correct place. When I reopen the database later, unsorted, the record is still at the end of the file -( This of course means I have to sort the db each time I open the database. No big consequence when working locally, but when working via WAN for example the sorting takes a g e s ... How can i renumber or reindex the records permanently once sorted so that they stay in the same position? Can I run a script on shutdown that renumbers or reindexes the records?

I've searched these forums looking for an answer to this question but haven't found it yet: Is it possible to automaticaly open databases when FMPro (or FMPro Unlimited) is launched? In other words, when I start the application can I have the application open the databases for me? I have about 10 I need to have open all the time, and want them to re-open automatically if the machine gets rebooted, for example. Thanks, Robert

Why can't I do a search in the header area? I need a layout to show the title of the project and then all the related items to that project. But I don't want to have to show the Project title, with every single record. The layout is in a column. I have the project title in the header, with all of the records in the body. Any ideas? Paul

User - "We should be able to create reports to include any field we need to include open as well as closed records" - Basically they need customizable reports based on what is being requested. My thoughts were that I could do it two ways. 1. Discuss with the user what reports they would need and come up with a fairly complete list of reports that would meet almost any need ahead of time or. 2. Create a layout that allows them to select which field goes in what column, thus allowing them to build the reports as they need it. Is the second option even possible? This app was written by someone else and the users want to add functionality to it. Any suggestions?

I am running a database on FM Unlimited 5.0. There is an inventory file with a portal to a related file showing activity against the inventory record in the main file. My problem is that when I do a search if there is only one match the portal is always empty. However, if there are several matches the portal (for the same record) contains the correct data. Has anyone experienced this before - and how did you resolve it. Any help is greatly appreciated.

I believe this is a calculation problem. The data looks like this; Each record has three fields <State> <Miles> <Gallons> We process fuel taxes for truckers and must create a report that totals the amount of miles traveled and gallons of fuel purchased in each state. We will enter Data that looks like; <AZ> <151> <200> <CA> <132> < > <NV> <115> < > <AZ> <100> < > <NM> <200> <150> etc... I need a field that will total miles by state, and another field that will total the gallons purchased by state. Any one have any suggestions…

So recently I went through one of my databases and I have found over 200 records from a specific Date, 3/13/2003, that no one ever entered. The records are all from old information. Now it could be possible that we crashed that day. So am assuming that the records could be the result of that crash. But why such a large Number? Also I cannot find them when I type, "3/13/03", I must type, "3/13/2003". Now is there anything I need to worry about with that database. Should I do a save as clone and re-import all the records? has anyone had this problem?

I have just upgraded two machine from NT to 2K. On one filemaker 5 still works, the other it doesn't even bring a window up but I can see the process running in taskmanager. Any suggestions would be great. Andy

Please, i need connect 2 files. I need that with a button in file A open directly a file B. I can do that but no directly, i put in a button an option "Files" - "Open" on "specify Button" but this option ask me what file i want to open, and i want open file directly.

Is there a way to insert a tab in a script? What I mean is this: When you are writing a script you can put in a return character to indicate where you want a new paragraph. (i.e. "Little Miss Muffet

Hi, all. I'm certain that this is an issue that is very common and so hopefully the answer is easier than I think it is. For my report (and nearly all reports) I have a Trailing Grand Summary with the report totals. My problem is that this part often gets orphaned on to its own page! It looks really bad to have a report like: ------------------------------------------------------------------- Clothing...................$10 Jewelry....................$15 ... Department Totals..........$50 <new page> Report Totals............$1000 ----------------------------------------------------------------------------- Is there any way of ens…

I need to attach a list of contact phone# as a footer to a layout. I can do that by insert an excel sheet in layout mode. The problem is what should I do to allow user to edit the list in browse mode? Thanks in advance!

Hello All, I'm hoping someone can assist me with a problem I'm having with the formatting of something I'm working on... Is it possible to make create a template in such a way that at the top of a page, I would have some constant-information, have a section full of variable data (which can range from one line to many lines), then continue onto a second page with more constant-information show up at the top, variable data continued from page1, and finally more constant data at the bottom of page2? To clarify, there is an example below... For Example: ~Page 1~ Constant-Info (perhaps a company logo, addressing-info, and letterhead), Variable-Info (…

Hi, I have an e-mail address database that 5 other files need to have access to. I'm using the SMTPit plug-in to facilitate e-mailing from these files and in the 1st db, I've scripted an "add" button that opens the e-mail db, allows the user to select a recipient and then pastes the e-mail address in the To field. This works great with the first of the 5 db files but I can't figure out how to make it work with the others. I can script opening the e-mail db but when I select a recipient I'm taken back to the 1st. database (because that's where the script tells it to go). I need to figure out how I can tell the e-mail db which of the 5 db's to return and paste to. Does…

Not knowing much about programming< Is there a way to make a database I make separate from Filemaker, for example like a program someone created. I know you can lock things so people can't can't change anything, but is their a way so all you see is the database and know menu's? Scott

I'm an ex-Windows user trying to switch apps to Mac. I have several databases that I've set up in Access in which I heavily depend on crosstab queries (pivot table queries). Before taking the plung to migrate to FM can anyone tell me if FM can present data in a crosstab/pivot table format?

Does anyone know if there will be a problem running databases from the system folder. We are using the Windows platform and am using the auto-update feature to upgrade databases as well as plugins for our clients around the state. Thanks Stu

Hi there, While performing some tests on a calculation, I went into a huge mistake, referencing the field it self with a getfield("my field calc") and it takes me in an endless loop forcing me to qui FM. But I can't get back to the file. How may I solve this :??

I have a boxed, unregistered, unused FilemakerPro v5 Unlimited available if anyone is interested!

I have a boxed, unregistered, unused FilemakerPro v5 Unlimited available if anyone is interested!

This happens across all databases in the particular FM 5 install. If you are in layout mode and you want to drag a field to move it elsewhere in the layout it duplicates that field instead. How can I get it back to just move a field when I drag it? I checked all the preferences and menus but can't find any setting that would seem to create this behavior. Thanks for your help.

I have a file [Mfr] that has 2 fields. I have one formatted as UPPER CASE and the other field formatted as Title Case. I have a file [Cont] that has a portal from the [Mfr] file with the above two fields in it. They have also been formatted to UPPER CASE and Title Case respectively. My problem is the names in the fields from the portal are shown the way the data was entered into the filed in the [Mfr] file. So if one manufacturer was entered as FORD and the other as chrysler, that is just the way it is shown in the portal field even though the text formatting is set to UPPER CASE. Is there a way to fix this so all names in this field are UPPER CASE? Thank…

I have a Filemaker 5 Server/Host in an Apple OS9 Network with several Clients. In the Filemaker Database the User can listen to many Soundfiles, normally. Sometimes the linking is lost and you get the error message "File could not be found...locate file again". The Database and the soundfiles are on the same server but on different harddrives. Is that a problem? Sometimes when you relink a file the other files in the same folder are atomically relinkt too.

i've read in several places, these boards included, when laying out dbs, or even before you're laying it out, that it's helpful to graph the way you want the information to flow. i think this is a great idea, and to some extent i wish i had done this. i now have 5 files with the smallest at 30 records and the largest at 650 records. i'm very happy about the way i've designed it/it's designed itself, i'm learning as i go. but now i wish i had documented some things (relationships/match fields/etc) better than i have done. does anyone have any advice for "back-documenting" a fm db? i would like to improve the way i have things set up, and i am positive there is much…

I'm not sure into what category this question fits, so I thought I'd post it here in the General discussion. I was talking with a friend who develops databases and uses a program called ACT (window-based). He said he is able to attach other documents (e.g. Word documents, Excel documents, etc.) to a database record. Is this possible in FM Pro? I have a Contact.db in which I keep track of all the times I've contacted people in my database. It would be great if I could attach all pertinent documents to that record. Anyone know if that's possible? Thanks. Dan

Im researching about filemaker and php, i ended up at FX.php's program. Im just confused, is filemaker web companion different from the web connector? Or they are bot the same?

What I would like 2 do is 2 have my main menu screen appear in the background (maximized) when calling up a calendar to the front(reduced).

Hello, I want know if it's possible to redisplay only one ignored sheet whitout oblige to display all ignored sheets. Thanks Michel Langlais

Hi all, I have problems configuring the Web server connector: Whenever I type http://localhost/FMpro?config my browser doesn't find a thing. My Filemaker databases are open and shared. Web Companion is set to use port 591 What am i doing wrong? Any suggestions are welcome. I have tried specifying port 591 in the server settings of my mac osx server, In the tab web service, is this necessary? when I start WSC by doubleclicking StartFMWSC.command. It innitialises FMWSC and then immediatly logs out. It says it initialyses FMWSC with following setting : port :8888 backlog : 50 etc. Yet I have specified another por…

Hi. I posted a little while ago with some questions on legacy versions of FM. The answers were really helpful. Now the company I work for is about to make the jump to OS X and I have a question I can't find an answer to anywhere else. The office needs just three people to use FM and one file on it. Including the server, there are four people. If I buy ONE copy of FileMaker for the office, can it go on all four machines? Or will FM do a network check like MS Office does and only allow one machine to run it at a time? This is a small office and every dollar is really examined. The cost of FM and similar software may very well decide if the office wills swit…

Hello all, About every other day or so, a FMP-6 database I built crashes while doing a date search on about 8000 records. It also will randomly return a no records found response to a known good date range when the starting point is all records. The random crash is corrected via "Recover" while the no records found problem is recovered via a re-start of the Host CPU. The system is configured with a 2.4 GHz P4 CPU, 256 MB ram, 40 Gg Hard drive and running Win 2K. Machine as the host with no other apps running. There are 5 other clients (also Win 2K)on the system doing routine queries on the database. They each open via the "Open remote" command. The clients have …

is there any way to have a serial # subtract 1 increment if a record is deleted exp. (0001, 0002, 0003) say 0003 is deleted, next record is normally 0004, can i make it 0003 without going into define fields? can i print in layout mode and have the field names appear in each field. thanks for any help you might offer, and sorry if the questions aren't clear

Please i need know if can i do an executable file with filemaker pro 5

I'm trying for the first time ever to publish a very very simple database online for our camp coordinators to enter in product information on the road. I go into FMPRO UNLIMITED and share the database and set up all of the important info to get it shared. I go into my web browser and type in the 192.168.x.x and the port number that I told it to use "84". I get the screen and it shows the database that I'm sharing...I click on it...it waits for a few seconds...and then FMPRO UNLIMITED crashes and quits unexpextedly. EVERYTIME. I've installed the webconnector files...but I'm not really sure what those did or how to use them in this instance. I'm runnin…

Here is the fun question of the day...We have a multiple database filemaker sales solution and what I need to do is create a report listing the quantity of sales of one item per month. We have a line items file which contains a record for each time the item was sold. I was thinking that I needed to setup another database and have four fields in it, one the item number (in which I would create a relationship to the line items file using this field) a date from field, a date to field, and also the amount sold field. In the amount sold field, there would be a calculation that would use the date from and the date to field range and use that as the range on the line items d…

I hope there is a simple solution to my question...as I'm new at Filemaker. I created a multiple file program. In this program the files operate with the window maximized at all times. I would like to open all of the databases (about 30) with minimal flashing after the user logs on. Can this be done? How? Thanks for reading my post. -Todd

Hey there! I wanna make a FM app. which works as a photoalbum with the possibility to choose different layouts en pagestyles. So on each page i can select a picture with some text then i go the the next page...and so on.. After this i want the possibility to upload the whole FM album with FTP, this has to happen userfriendly so on background or something.. Somebody knows if this is possible in filemaker pro 6.0?

Hi Can anyone confirm if filemaker(6) supports composite key relationships and if so how these are created. Thanks Iain

I have learn filemaker for 2 month, now i want to buy a filemaker book to study, got any recommended book that is suitable for me, i already got the basic idea and skill of develope filemaker system.

can someone tell me how those cool layouts are done in the templates in 5.5 i am particularly interested in the personel records where it seems like there are tabs and the layouts are on the same page any tutorials would be greatly appreciated how are the scripts worked so you get to each layout

Can someone offer me some insight on this? I have an 'Artist" database that I have included in this post. There are 2 layouts, "Artists". and "Artist Report". When you enter data in the "Artists" layout it then displays the spins in a column on the "Artist Report" layout as well as the week ending data in the header for that Artist. As we enter new records we date them exactly 7 days apart. What I would like to do is to get the "Artist Report" to display not only the current week ending date and current spins, but also the previous week ending data and the previous weeks spins. I want to be able to do a find for a particular artist, then go to the "Artist Report" layout…

We recently upgraded the OS on our machine to win2k. Everything works great, except for a little anoying problem: We are using FMPro V5.0v3. In the Status Area (far left hand side of the screen) the Layout Pop-Up Menu has changed slightly. We have quitea few layouts, and in the past, the layout pop-up menu would create 3 columns with all the layouts defined. Now under Win2k we have just one column, and a down arrow at the bottom which allows us to scroll down the list. This scrolling is not nearly as convinient as having the multiple columns appear. Does anyone know how to change this so we get our multiple column listing back? Thanks, Ron

I have the common problem of system/document formats for date/time being different on the machine I develop the files on to the machine that I install the files on for the clients. I know that I can use a startup script that includes the line: Set Use System Formats (On) But is there any way to actually change the document to use the system format permenantly, instead of every single time the document is opened? It seems a bit ridiculous to have to do this every time the file is opened!

Browsing other Forums, I just ran accross a post that leaded to 51 answers about FM in ArsTecnica. It seems though that not many FM developpers are frequenting this Forum. Struggling discussion about an article, leading to some debate about FileMaker vs Access.... link to the post It seems that the topic, opened in March and which last post was in May, could be reopened by some of you guys. There is also an active topic about FM and MySQL on this board... P.S.: I'm not a member of this list, and surely won't be as I see the unfriendly way they chat there. I just found it interresting the way they are arguing and "wrestling" about a simple "article…

I'm on the latest trial version of Filemaker on my Mac OS X and my PC. I saved a FM file on the Mac and e-mailed it to my PC, where it couldn't be opened. Filemaker said it was not a Filemaker file or was severely damaged. I tried this many times with the same result. What could be happening here? Oddly, any file I e-mail from my PC to my Mac OS X opens fine, it just doesn't work the other way around. Thanks, Corey Martin

Does it seem counterintuitive to anyone else that when you drag the contents of a field to another field FileMaker does an insertion rather than a replace. Dragging "Joe" into a field that already had "Bill" gives "JoeBill" as the result instead of replacing Bill with Joe. This may be a feature request for FileMaker, unless someone has a way around this. Would it be possible to write a plug-in to change this behavior? Perhaps I'm missing the utility of having an insertion rather than replacement. Thoughts any one?

When viewing records in a FM database using View As List feature, it may desirable to change or highlight the record that is currently being accessed. Is there any way to change the color of the background of the current record and then change it back to the original color when the record pointer moves to a new record. I think there was a post on this forum that addressed this but I haven't been able to find it. Thanks The Mad Jammer And Then...There was nothing

Hi, I've just built a test of a new server on an OSX 600 mhz iMac with 512mb of ram and FMPro 6 unlimited I'm finding that it's serving custom web publishing pages at a snail's pace compared to v5 running on an early G4 450 where they work very quickly. I'm using the same databases which were created in v5 and the same cdml pages. What can I do to make it run as quick as the Classic version? There's no difference with no other applications running and I'm reluctant to put it onto a quick G4 until I get a reasonable performance first. thanks, Jeff

Each day I need to; 1. Find all employees who have a birthday on todays date

How via a script command do you set the current layout to only print the current record or print records being browsed? It doesn't look like Page Setup saves this choice so maybe this cannot be restored via a script??

I have a zip code DB for the US. Does anyone know where I can find one for London?

I converted a .fp3 file, from filemaker pro 5. it converted successfully but when I open the file it give me the message "This file cannot be opened because it has one or more fields based on languages not supported by this version of FileMaker Pro" Please Help!! Thanks SB

So I've upgraded to a new G4 with 2GB of RAM. When I opened my Filemaker Pro 5.5 Installer a window appeared saying that I didn't have enough memory to continue and that a minimum of 8MB was required. Obviously, Filemaker doesn't know what a Gigabyte is. Does anyone know of a workaround for this?

Have any one created a "tree view" in Filemaker? Just like the tree view object in Visual Basic? in List Mode.... I know it is possible to make "tree view" using portals. But I wan't to use them in a List View (View as List) Mode. I have an email client (sort of) database in filemaker, and I want to create a tree view on the left side for Inbox, Outbox, Sent etc... just like in Outlook. Any Ideas? Any sample files? Thank you!

Filemaker 5.5, FM Server 5.5 It looks that the user dictionary is limited to

I was after, if possible, a script or some way to have TEXT not printed if a field calculation was not used. If that particular calc. is used then the TEXT will show/print. EG. PRINT VIEW 2hrs X $50.00p/hr= $100.00 CALC USED CALC NOT USED If there is NO input for the Calc to be used (not needed), then the X & the = will not be printed. The reason i want to do this is for a QUOTE FORM. When certain aspects (fields) are not used then i dont want to see the multiplication and equalls signs on the layout when it is not required for that particular QUOTE. Any help wo…

I am a 10-year on and off FMP user, and recently on all databsaes I have built, when I move a field on any layout, it copies itself, which is a real pain. I have not found any documentation on this. I checked prefs and have tried other computers, and am at a loss. Any thoughts? thanks for any guidance.

I was wondering how and when a record gets locked by another user accessing it. For example: does related records gets locked too ? Does the record gets locked even if the user doesn't have write access to it (or to any of the fields in the layout he is on) ? How does SetField[] and Replace[] behave when they try to edit a locked record ? Last question: I'm using data-files to store data and interface-files to display data. "Interface" files have only global fields and one calculated field set to 1. Those files have only one record. In order to have access to data, every user opens the "interface" file. So users are accessing different records on the d…

I have an inserted object that is activated to allow the user to work with a mapping program. It works very nice. However when the map program is being edited the size adjustment boxes are present. Is it possible to get rid of, or hide, these surrounding adjustment boxes as I don't want the user to be able to edit the actual box location or size?

I am relatively new to Filemaker so I'm hoping to get some advice from the experts. I am working on a Filemaker system that creates records when items get moved from one location to another. There is no location data, just records that show what quantities have been moved. The system does child to parent lookups but not parent to child. In other words, you can easily see where something came from, but when you are looking at an old record you have no idea if the item you moved is still where you put it. That complicates any kind of Find where you want to know what is in a location. The problem: We want a report on what is in one specific location. …

Hi........ I am running Windows Xp..home edition. I copied filemaker files to a cdrw disk formatted using Direct CD. When I try to open the files either with Filemaker 4 or Filemaker 6, it opems in restricted mode, and will not let me do anything with the file. I copied the files back to a zip disk, and the files open correctly, without a problem. Does anyone have any ideas on what is happening here? Thanks Russ Bunker

Is there a way to make fmp ONLY save to disk manually? No auto backup, just the dump command.

I'm pretty new to FM. I've been searching these boards and found many useful suggestions. But here is a specific to my case and I'm hoping someone can point me in the right direction. The setup: a small movie production company with 5 or 6 iMacs and iBooks link via ethernet/Airport LAN to a hardwired eMac shared file server. The eMac hosts Prairie Server/Quickconference and FM Server 3.0 simultaneously. The only FM database is a phone log that is constantly being updated - about every 4 or 5 minutes from any of the Mac terminals. The eMac server runs FM Server 3.0 and the rest of the Macs run FM Pro 4.1. The Phone Sheet database is hosted on the eMac server. Ther…

Hi guys, In layout mode when I try to move the fields by just dragging them somewhere, FileMaker thinks I want to copy them, and does just that. I am not holding down any other key, just dragging the mouse. Machine is Cube, with OS 10.2.6 and FM 5.0 running on it. This is the first time I've seen this, has anyone experinced anything like this before?

After some time (seems time is random) Filemaker will generate an error of "Database Not Open" when users try to connect to the web front-end I have created (when, in fact, when I look at the console, FMP is maximized and running-all DBs ARE open, I can perform things on the open DBs from within FMP itself). I'm running Filemaker 5.0V3 (unl) and web connector 5.0V6 under Win2kpro. Has anyone seen this before? Once any user gets this error, the web front-end is useless (for everyone) until I restart Filemaker. This is a major concern! Please Help Addition: It appears that whenevr this happens this appears in the web connector error log: [28/Dec/2000:15:58:28 -050…

Anybody know of a way to navigate from field to next field using the "Enter" key instead of the tab key? It'd be a whole faster for our data entry people who are used to 10-key entry. Thanks!

I just posted a qustion, but cannot find it, I'm afraid I did something wrong, so I'm asking it again.... We have databases on two systems, both are running under OS10, one is FMUnlimited, another is FMServer. On those systems we have related databases.. Relationships FMU->FMS work fine, hovewer when we opn database on FMS it cannot find the related files from FMU and we have to choose them manually. What can be wrong here?

I'm wondering if any of the pre-V.5x versions for pc have appletalk as an available protocal. I need to use my XPpro system on a Mac/Appletalk based network, and while I have Appletalk set up (filesharing is available) my version 3 F.M.Pro does'nt give me the option to use Appletalk. Was there ever a patch? Do ANY versions on pc support this?

Okay, I thought I'd had problems before, but now I'm totally stuck. I can't even open FileMaker. If I choose it from my startup menu, if I click on the program itself, if I directly try to open an .fp5 file ... I get nothing! There's a pause, and sometimes the hourglass icon, and then it just stops. No error message, nothing. This happened on a colleague's computer last week, and I rebooted her machine and it went away. This morning it's happening on mine, and restarting hasn't helped anything. I don't know what forum to put this in, so I'm just hoping somebody can help. I'm (not) running v6 on Windows 2000.

Hello, I have 40+ FM files open during use. Getting to the desktop is a big problem as the user will need to minimize all windows before reaching the desktop icons. Is it possible to run all FM files in a single window/frame so the user will only need to minimize one frame? As the database is gettig new files regularly it is impossible to handle this with scripts. It's running on FM6 and Macs. Any help is appreciated...

Is it possible to download a demo version of filemaker pro 6 unlimited to see what it can do? I cant find it anywhere. Many thanx in advance

I have begun to have a problem recently in that when I attempt to start Filemaker by opening up a file from the desktop, it lauches Filemaker but not the file. I have to double click again to get the file to open. I am using 6.0v1 and OS10.2.6. Any help? Thanks

Hey - Now that I have a dedicated server to FMP (Not FM Server) and have actual user levels... my question is this: To launch/access the databases now, users must open FMP on their desktop, click "Hosts" to get connected to the FM Server, then select one of the non-hidden databases available to them. There's GOT to be an easier way to get into them from the desktop! Shortcuts/aliases aren't working. For regular users it's annoying, for the minimum access users, it will be way too confusing for them!! (We haven't told them it's on their machine yet!) PLEASE TELL ME THERE'S A BETTER WAY.... THANKS!!!

Hi, I have a FM database with some 200 properties/histories listed. Each property has an address and the names of several past owners. Is there a way to develop an index for this report that would show all properties and what page they appear on and all owner names and what pages they appear on? Thanks!!

Quick question... I need filemaker to round a number, like 8.33333, down to 8 instead of rounding up to 9. Anyone have a solution?

I am trying to create reports to tell me how much sales tax I collected and owe each six months, as well as monthly income reports. Someone mentioned last Fall about using the New Reports Assistant. Where do I find that and how do I run it? Kathy

I really hate asking for information when I haven't contributed to the forum knowledge base, but here goes: In configuring FMP 6 on XP Professional, under the 'help' menu there is information on 'registering' and 'help on web' and such. I don't want to give network clients access ... I'd like those features greyed out. A custom install is not an option....any ideas? thank you

hello, does anyone know how to host the database while using relationships from another file? thanks in advance

Is there a way to show what the

How do you change the alignment of the part labels from a horizontal format to a vertical format. I'm referring to the <header> <body> <footer> etc. Larry

Hello, I have done some searches, and come up with very little on the subject of checkbooks. My reason has to do with a small business (publishing and mailing a periodical) I run, previously having done the checkbook in an old MS application called works. I maintain my mailing list in Filemaker. I have moved to a G4 mac from an older machine, and fortunately, I suppose, can no longer run works and have moved to MS Office. I have always wanted to do all of my business record keeping in Filemaker, as I felt I could integrate mailing list, revenue, and expense functions in one application that could greatly automate my tax preparation challenge. I do not find …

We use a database in our office that is housed on our Mac OSX server (XServe). It is accessed accross in single user mode by 8 different users at various times. Some of the users are Windows XP users using FM6, some are Mac OS 9.2 (using FM 5 and 5.5) and some are Mac OS 10.2.4-6 (using FM 6). What is happening is that this database is frequently requiring the use of the recover function to be opened. A couple of weeks ago even this wouldn't work, so I rebuilt the database from scratch and imported the data from the previous day's backup. I thought this would solve my problem, but now I am having to recover the file again. Does anyone have any idea why this may be happeni…

Ok, so here is my problem... We have a 3 database inventory/sales solution. There is one big problem though. Our first database (Order Form) is where we input items that customers order into a portal that is in relationship to our second database (Line Items), and then from line items it brings the item information and current inventory on hand from our products database. Now here is the problem, some of the items we sell in dozen and single quantities and what we need is a method of when the dozen item number is inputted into the order form portal, have it take 12 singles off the single item product record, in the products database, instead of taking one off of the do…

Hi All, It time for me to upgrade from my Mac OS 9.2 Webstar 4.5/Web Server Connector to Mac OSX. The plan is to keep running FMU (v6) on a win2k box and upgrade the web server to something on Mac OSX. I would prefer to not buy OS X server and instead just use the built in Apache on OS X 10.2.6, so my question basically is: What does the latest version of FM Web Server Connector work with on MacOSX? Does it work without OS X server? Does it work on OS X 10.2.6 (non-server)? What versions of Apache does it work with? - Has anybody used it with Apache 2? My other option is to not use a web server connector and treat the win2k box with FMU …

I recently rewrote my batch file used to backup our FM Server 5. We used to just copy the hosted files without stopping and restarting the FM Server service. The new batch file stops the service, copies the files, then restarts the service. Then it occurred to me that I have a new problem: Automatically re-opening the files in Unlimited 6 once the FM Server restarts. It occurred to me that I might be able to use a daemon and run Unlimited as a service. How does everyone else get around this? Thanks in advance.

I would like to have FMPU run as a service on either a w2000 server or win xp pro machine. I also need to be able to use FMP on the same machine (for local users). I currently have FMP server 5.5 dishing up about 40 dbs, but only 10 or so will be needed by the web interface db to be shared. What are my options, (no I do not really want to buy another machine) My main problem is that aside from our server machine the rest are used by staff, and I don't want the FMPU closed down. Q2. Is there a way to run FMPU on a machine that is also running FMP Server. Cheers Charles

I'm getting so unbelivably frustrated over here. I'm running FM Server 5.5 with FM Pro 6 to work on it. I also have developer, but rarely use it. The problem I've been having is I have been making changes to scripts so they work properly (it's mostly for navigational purposes), and after I fix them, they go one as if I have never fixed them in the first place. I seriously don't know what's going on, and I'm ready to start punching stuff. I end up fixing the same scripts literally every few hours, and it's unbelievably annoying. What the $#@$ is going on?: Should I stop the FM server and work on the files directly from the server??? ahhhhhhhhhhhh!

Below is an if statement formula I am having trouble with. I get the error message "There are too few seperators in this function" Can someone help me get the syntax correct? If (ShipMethod = "Ground",5.95+AddWeightCost,If (ShipMethod = "2Day",8.95+AddWeightCost2,If (ShipMethod="Overnight",14.95+AddWeightCost2))) Thank you.

I have some databases running on FM server. Should I do periodical operations to keep my solutions running smooth ? For example, have the hard-drive to be periodically defragmented ? Have the databases to be optimized (assuming that some kind of low-level optimization exists). Thank you!

Simple. How do I get the layout in browse to have the "page look" where the form borders are "fixed" (similar to "page view". I know the fuzzy verticle bar in the layout mode marks that edge. But in browse how do i get the form not to expand to full monitor size??? Jonathan

The specs: Filemaker 4.1 database is being shared on Macs & PCs. The file is being hosted on a Mac and has been working fine for years. Lately, one user on a Mac OS 9.0 machine experiences dimming with some of her text when she opens the shared database. This problem does not happen with any other user who access the database from their machines. This user will see some of the text fine, but other pieces, within the same field for example, will have the text dimmed and other words will display fine. If she increases the zoom, or if she prints the record, the text and fonts are fine. She only experiences this problem with this one shared database. Other databases on he…

I see that FileMaker is offering a rebate on QuickBooks. Yet there is no standard solution for importing FileMaker into QuickBooks. Am I missing something here? Comments appreciated - Sam

I am currently running a network of Mac's and need to get all electronic transactions HIPAA compliant. Can anyone point me in the right direction, via referal or possible Medical billing Applications for the Mac that will be compliant with HIPAA regulations. Even a "grunt" would be appreciated at this point! Yes I know! Macs can suck!

I have recently put a Windows XP computer on the network and I have a 98 on there as well. The problem is when printing from filmaker v4 in XP the headers never print, but they still print from the 98 PC fine. Is there a way to fix this or is there something that I am doing wrong?

Could someone point me to something that might explain the Perform Find/Replace dialog? There's alot of new stuff there and I can't find sufficient literature. Thanks Ken

I have a set of 5 (or so) databases that are used for producing and printing calibration reports. We would like to use a laptop for doing this same thing on the road, but I'm struggling with exactly how to do that. Ideally, VPN would be best, because the on-site laptop user would have access the the most current information and I wouldn't have to modify the databases at all. It would be as if they are plugged into the network. But, this system would have to work virtually anywhere in North America, so a cellular phone hookup or 802.11 wireless hookup would be too spotty. I was interested in FileMaker Mobile, but my application seems too much for FileMaker Mob…