FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
can someone please suggest a solution. I have some databases that crash immediately after putting in the password. the odd thing is, the ones that crash on the Mac host open just find on the Windows host, and the ones that crash on the Windows host, open just fine on the Mac host. I need to host all the databases on the same box and have already tried recovering, cloning w/no records and importing, etc. all to no avail. I had read somewhere that the crashing might be due to a corrupt layout and that I should delete the layout, but how can I do this if I can even open the db on the box that it crashes on? also - it is true that I will have to run 2 boxes in ord…
-
- 7 replies
- 1.1k views
-
-
I am new to FileMaker Pro and am creating a baseball statistics program for my baseball team (i am a high school coach). I had no problem at all creating individual players stats records with formulas that will automatically calculate batting average, earned run average, on base percentage, ect. What I would like to do but do not know how is combine the stats from each individual player's record and create a team statistics record. This has to be possible but I have tried and cannot figure out how to do it. Any help would be greatly appreciated. Thanks.
-
- 2 replies
- 908 views
-
-
Hi I have developed a piece of software using FileMaker Pro 6. I am thinking of upgrading to FM Developer 6 to deploy this (using the developer tool - creating a stand-alone runtime solution) to our clients. My question is what exactly will they be able to access and screw around with. Would they be able to re-develop it for their own use - without our knowledge? I don't want them to use this for themselves in another way. If FM Dev 6 isn't the correct solution for securing the software integrity - does anyone have any ideas? Sorry if this is the wrong place for this, I couldn't see any where else it could go. Thanks Emma
-
- 4 replies
- 1.1k views
-
-
Have client that is using Novell Netware 6 (instead of previously planned NT - surprize!), w/ Apache 1.3.x running (finally). The client's outsourced network guys (ONG) have demonstrated a lack of knowledge in running apache let alone FMU. I know very little of Novell, and am having trouble detailing our needs. As I understand FMU, we need it running on the host AND the dbs open (all w/ the requisite web companion configurations enabled) on the HOST. The ONG's are suggesting that the application must have a ".NML" (some novell executable?) in order to run. FMU has been installed, but CONNECTOR has NOT. If we map drives from a station, we can get the application to ru…
-
- 7 replies
- 1.6k views
-
-
Hi..newbie here. I am working on a pretty ambitious project that involves manufacturing and production tracking...I will have a ton of questions to follow I'm sure...I've storyboarded a number of my database files that I will need and am currently stuck on the design portion. I have an 800x600 graphic image that I want to use as a background for my entire program. Problem is, (unlike Pagemaker, Quark, InDesign...etc..etc) there seems to be no way to "resize" the document window. I want my database to appear on the users screen (full screen mode) the same size as my background image.If the user uses a higher resolution I would like my image to appear in the same location b…
-
- 15 replies
- 1.7k views
-
-
Hi All, I have a database solution using filemaker pro 5solution. I need to make it as a web solution to accept form and stored into the database, login and logout function. Do you have any suggestion on the solution ?
-
- 2 replies
- 854 views
-
-
-
I would like to know ifwe can set automatic reminders, or program tasks like printing an invoice that needs to be printed on a regular basis ?? Thank you Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:
-
- 2 replies
- 908 views
-
-
How can I compare the data in one FM data base file to the data in another FM data base both having the same fields? I have someone in another city that inputs sales lead information. The original data base is updated before the new leads are merged into the original file. There are date and time fields for each record when they are created and changed. I need to compare the data in several fields so that the most current data is kept. How can I do this? Platform: WIN 2000 / Version: 5.00.2195 Service Pack 4 FileMaker Version: 6.0V1 Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:
-
- 1 reply
- 793 views
-
-
we need to update to fmp6 unlimited but hate to spend the cash with the feeling that 7 is coming. Does anyone have a hint of where Filemaker Inc. are at?
-
- 5 replies
- 2.1k views
-
-
Hi! Have you ever done so much research into an issue that you end up more confused at the end? Well, that's where I'm at right now. I'm about to attempt my first go into publishing a couple of db's on my XServer with FMU 6. Now I know I'm supposed to host my files on one machine and publish on another. I'm currently running FM 5.5 on my iMac at the moment, and haven't loaded FMU 6 just yet. Point of confusion: If I load FMU 6 on my iMac and publish the db to my XServer, then I should have unlimited clients accessing the db's online? Also, do I have to load anything onto my XServer (besides the db's) in order to handle FMU?
-
- 2 replies
- 1.4k views
-
-
-
Hi, we have a printing issue...we are printing postcards, so we set the layout so that the adress is printed where it should be.. The pb is the adress prints fine 1 card out of 3, the adress on the other 2 is misplaced..anyone has any idea .....?? Thanx
-
- 2 replies
- 1.3k views
-
-
I work with a 120 files filemaker applications, running with filemaker server and 30 users in a LAN. I'm having problems publishing my files with web companion. I active the plug-in, select via sharing the web style and the layouts, but nothing happens with some files. I can publish some files but others don't.
-
- 1 reply
- 841 views
-
-
Hello, I have a database with files numbers. I've made a script which enables users to choose numbers from an index window ("inser from index" script command). On some keyboards, users can select files numbers, in the index window, quickly from the numeric keyboard (the right hand side of the keyboard), some other must select the file number with the shift + number (top of the keyboard). I cannot explain on which criteria it depends (some keyboards are OK, other are not). I do not have this problem on Mac. Do you have the same problem ? Is there something to set in the OS, in FileMaker ? Thanks for any contribution ! Antoine MDP Qual…
-
- 1 reply
- 644 views
-
-
Hello, I have a database with files numbers. I've made a script which enables users to choose numbers from an index ("inser from index" script command). On some keyboards, users can select files numbers, in the index window, quickly from the "number keyboard" (the right hand side of the keyboard), some other must select the file number with the shift + number (top of the keyboard). I cannot explain on which criteria it depends (some keyboards are OK, other are not). I do not have this problem on Mac. Do you have the same problem ? Is there something to set in the OS, in FileMaker ? Thanks for any contribution ! Antoine MDP Qualit
-
- 1 reply
- 691 views
-
-
Hello, I have a horseracing database with over 50,000 records and climbing daily. Each record has over 200 fields, some data, some calcs. I think I might need to change the way the database works, but I'm not sure what is the best way to go. Because of the format of the the external raw data (past performances) each record is one horse in one race. By now I have different records for the same horse, where the horse has raced on different dates. It would be useful to have one record for each horse with its each previous run and associated data. I have thought a portal type of setup would be the way to go, but I interrogate the data in many different and at…
-
- 4 replies
- 1.3k views
-
-
Hi, How can i export records with desired filename? For example after my backup script runs then fm automatically save the records as a file name that according to system date (030131.tab -year/month/day-) Thanks Adam
-
- 4 replies
- 1.3k views
-
-
-
I deleted my other two post, please forgive the doble post. Are there any concerns I should have to upgrade from 5.5 to 6.0? I have heard that some layouts do not upgrade well. Also, does anyone know if there will be a newer version any time soon? Why upgrade to 6 if a 6.5 is in the works? Salesman PS: Again, please forgive the double post!
-
- 3 replies
- 777 views
-
-
When printing to the avery labels is there a way to tell filemaker to only print to certain stickers because I am printing addresses out onto the stickers daily and I don't use up the full sticker sheet. So I would like to be able to print to the remaining stickers the next day.
-
- 1 reply
- 716 views
-
-
Hello guys.. A few newbie questions which needs to be answered. I've been given a project which requires me to continue from the company's existing filemaker database (already up and running for quite a while). But i'm unable to go to the layout mode after i open up the program, any idea on how i can access to the layout mode, and how do i disable the layout mode after i have completed my form. Another thing is, how do i go about archiving the records in the database. Thank you in advance.
-
- 6 replies
- 1.1k views
-
-
I've been using the titecase option for text so that it capitalizes the first letter of every word I type in a field. Is there a way to set it so that the server will automatically do it for you when you type in a field instead of setting the option on every computer with filemaker.
-
- 2 replies
- 920 views
-
-
Hi, probably already answered a hundred times before - but I can't find them -( Currently FM unlimited connects to an external FM Server hosting some databases via the web compagnion; now obviousely I have to expand direct access to FM Server with FM Pro (VLA) via Windows Terminal Server. FM Unlimited AND the FM Pro (VLA) Version is planned to be installed on the SAME server opening the files from the external FM server box again - are there any problems or tricky steps to be considered? At least I heard that a combined installation of FM unlimited AND FM Server on the same Windows box causes corrupted files, slow access, ... Are there similar problems with a com…
-
- 6 replies
- 1.6k views
-
-
Hi, I need to get Filemaker Pro 6.0 onto two Mac and was wondering whether the installer allows you to install on two different machines with the same license, or, like so many of the newer installers, it coordinates things over the net to make sure you can't use the license on more than one machine.
-
- 10 replies
- 1.3k views
-
-
Does anyone have any information on when/if FileMaker will be phasing out older clients or server versions? Just trying to keep ahead of the curve (barely)
-
- 1 reply
- 1.1k views
-
-
I have a friend that use Filemaker extensively in his business. He wants to take on a new client, but they use MSAccess. He asked me to see if I could find a way that he could do business with this company. Import/Export Filemaker, Access, etc. Is there any way that he can get Access files into Filemaker. He uses a Mac. Thanks
-
- 3 replies
- 1.4k views
-
-
Hello Everyone! Does anyone know of a Filemaker shopping cart solution the we could implement on our web servers and have a link back to our filemaker solution for up to date inventory and order processing? I know they are out there but now when I went to find one, there isn't any... Any solutions? Best Regards, Austin
-
- 1 reply
- 718 views
-
-
First let me qualify that I am new at using FileMaker. We have a "small" FileMaker system with 20 files. Of which none are large, one has 22,000 records and the second has 10,000 records. The problem is accessing any of the data takes a very long time. I have read about people accessing hundreds of thousands of rows of data in seconds. Is this due to the speed of their hard drive? We have FM server set up on a Windows XP Pro machine with no other applications running on it. The machine has a 40 gig drive running at 5400 rpm. Would a 7200 rpm drive make a difference? I know that FM recommends SCSI but that is not possible right now. Thanks for the help!!!
-
- 4 replies
- 759 views
-
-
I'm a school "tech guy", and we have a school wide database.. Most of our "client" machines (all Macs) are running FM5.0. I'm beginning to upgrade some machines to OS X, and want to use the OS X native FM 6. However, we can't afford to move to FM6 for ALL machines at once. Here's my question; Can I develop (that is, change layouts, fields etc) a database on FM 6, to be served by our Filemaker Server to CLIENTS running Filemaker 5 AND Filemaker 6? I would not be utilizing any features that 6 has over 5 (that I am aware of) until we've COMPLETELY moved to FM6 in a year (maybe two... depends on budget...). For reference, I'm talking about a K-8 school…
-
- 3 replies
- 794 views
-
-
I would like to force template text (typed onto the Layout) to create a new page when that text exceeds a limit down the page. This is necessitated by an itemized list part that will vary from one item to many. Below the itemized list area, I have a Trailing Grand Summary part that contains calculation fields for total, tax, etc. Following that is a disclosure statement, closing and client's signature and date area. I could easily place the text in a text field except there is no tool that can draw a line for the client's signature and date in the (Browser) text field. One has to use the underscore key - not good. Thanks for the help.
-
- 4 replies
- 881 views
-
-
Hi, How can I find installation code of FM 5 for MAC 9.2 ?? I have bunch of client FileMakers, and there's this one Mac 9.2 machine I need to format and reload. I don't remember which physical copy of FileMaker is on it, but I want to load it after I format the drive. Otherwise i will be getting network errors, like "max no of clients is on the network, etc." In OS X I think it's in the Preferences folder, but in OS 9 I don't see it. Thanks
-
- 2 replies
- 808 views
-
-
In Filemaker (5.5), is it possible to create an element in the layout that is "draggable" by the user? I have a image (of a map) in a container field and would like users to place a dot on where they would like to go. Can anyone provide a workaround solution or some advice? Cheers!
-
- 7 replies
- 1.1k views
-
-
Hi All, I installed Webconnector to a Mandrake 9.2 with Apache. I compiled the necessary module for apache. Then start the apache and Webconnector with no problem. But when I enter the 127.0.0.1:8888, I can not receive any thing from web browser. I dont know what is the problem. I can not see any error in log file. Is there any way to change the initial settings for Webconnector? any help is welcome Y.C
-
- 0 replies
- 1.1k views
-
-
I'm working for a manufacturing company that has an Oracle based business information system (ERP). The ERP system does many things but falls short in certain areas. What I would like to do is use FileMaker to fill in the gaps. We would like to track a lot of information about our "installed base" (machinery that we have sold). The ERP system has a table that contains the SYSTEM_ID (primary key) and a bunch of other information including the customer's name, address, phone, etc. The ERP system however does not track any unique information such as parameter settings that we had established before the machine left our factory. I would like to use FileMaker to hous…
-
- 10 replies
- 1.4k views
-
-
I made a database with a lot of pictures, now I want to put a part of it on CD. When I select the records which I don't need and delete them, the database doesn't get any smaller, because it's not checking for unused blocks.. Why not? When I make the db completely empty it is checking for unused blocks and the size decreases dramatically...
-
- 1 reply
- 1.1k views
-
-
I would like to insert text into a report based on a field value. For example: I want to place a merge field onto a report that is enclosed in parentheses. If that field is not filled out, I don't want the parentheses to show up. How can I insert the parentheses only when there is a value entered that field that the merge field refers to?
-
- 3 replies
- 791 views
-
-
Post deleted by dchuhta1
-
- 1 reply
- 662 views
-
-
Hi I have a bit of a problem involving a Mac LC 475 and a FM3 database. I need to get the FM3 database off the LC 475 (running OS 7.1) and onto a Dual Processor G4 running OS X and FMP6. I've tried to put the database onto a floppy disk, but there seems to be a problem with the formatting of the disk - all I get when I open up in FM6 is rubbish. Can I transfer the file off the LC onto an older PowerBook (maybe a 3400) running OS 7.6 or 8, upload the file to a web server, and then download it to my G4. I really need some help here as the database is critical, and converting it to FM6 is very important. Thanks.
-
- 3 replies
- 1.4k views
-
-
I know it's theoretically impossible, but it seems so necessary that I thought someone here might have found a better workaround than mine. Here's the problem: Users create lists. The contents of the lists will frequently be edited and the lists are repeatedly consulted or printed out. The lists need individual titles that are not stored within the database. The easiest solution would be for the user simply to type the title into the header before printing. No dice, of course. The workaround I've found is so clumsy that I hope there's a better one: Scripted: User types info into global field. Information is looped through all found records in list. As the header w…
-
- 6 replies
- 1k views
-
-
Hi! I have to perform script without pressing a button, I want script perform by themselves, I heard about Event Manager, could you tell me if I can buy it or it's free?? If it's not free, how much does it cost?? Thanks!
-
- 0 replies
- 921 views
-
-
I have created a catalog where the products are sorted into lets say 10 categories so that we have a list with category headers before each list of product that falls into that category ex:SPROCKETS SprocketA SprocketB SprocketC WIDGETS Widgets A Widgets B The problem that I am running into is that I end up having 7 pages for items that should fit on 5. At the end of some of the pages there can be up to 3" of empty space, then on the next page it starts the new category that in some cased should fit on the page before. I thought that this would be fixed in the part setup by selecting "Allow part to break across page boundaries" but it isn't chang…
-
- 2 replies
- 863 views
-
-
Has anyone at Macworld gone by the FIleMaker booth and seen what they have? Anything remotely interesting? FileMaker 7 for example ?
-
- 1 reply
- 677 views
-
-
I have a friend who has an FMP solution and he wants to put it on a web site and make it available as a
-
- 2 replies
- 857 views
-
-
In another thread the topic of right click on Mac came up and got me thinking. I thought I'd throw this out to those of you that perhaps are not using the mouse to your best productive advantage on a Mac. With the advent of USB mice there is really no such thing as a Mac mouse anymore. For instance I use a Logitech wireless. has 8 buttons and scroll. The next trick is the driver. By far the best mouse driver out their is called USBOverdrive it works with about any mouse. You can find it at versiontracker.com. USBOverdrive allows you to set up all buttons and scroll to keystrokes for each application you are in, and the finder. So any command with a keystroke …
-
- 2 replies
- 650 views
-
-
Hello I've designed databases using filemaker pro and shared them by either individual computers hosting them or by using the server version. But I'm not trying to get my head round Unlimited. Here's the situation: we currently have two databases - one used internally (using First Point an access based database - pah!) and one published on the web which is hosted by our web people and is for public consumption. The two hold similar data so this is a silly situation. What I want to do is combine the two - is this possible? Can you work it so that the public only have limited access to the data - finding the relevant contacts they want but nothing more? I'm…
-
- 3 replies
- 1.4k views
-
-
I have read a white paper from filemaker downloads site in the address : http://www.filemaker.com/downloads/pdf/fmp_vs_browser.pdf So I can not understand it completely and my question is: Can I working a FM database between 2 remote PC's with an internet connection without a browser? And what I need for this to happen? Also I wnat to know if can it be with up to 2 PC's? Is that working fine without a browser? Thanks in advanced...
-
- 0 replies
- 764 views
-
-
i am trying to make a calendar i have not figured out how to implement a month view with a standard type layout (7 columns / 5 rows) any pointers will be appreciated (or any solutions i might learn from)
-
- 1 reply
- 935 views
-
-
Hi, I work in some languages, Arabic, Cyrilic (Russian and Bulgarian), Spanish, and Greek, in Macos 9 I have some Fm databases in more languages and work fine. but when I change to MacOsX 10.2 or 10.3 and open this databases, only see "?:?:?????" in the fields, and only writte "?????" when the text is in Unicode. Only work well in Spanish characters..... I can writte in TextEdit in Arabic, Cyrilic and Greek but don
-
- 0 replies
- 815 views
-
-
Rather new to filemaker and the forums here, so forgive probably the basic question. I'd like to link 2 pop-down menu's together, but with content depending on each other. For example, if the value in the first pop-down is 1 i'd like the second pop-down to show the values of value list A. But, if the value of the first pop-down is 2 i'd like the second pop-down to show values of value list B. How can I do this in FileMaker?
-
- 9 replies
- 953 views
-
-
I end up doing some repair/upgrade work on some of my commercial databases from my home. I connect via TCP/IP over the internet using the IP address of the FM Server. I end up late at night doing quick fixes and such when the users are off. Question - there are times I have to add fields, for example a calculation field and it takes FOREVER to add the field after I write the calc. I expect this, no problems. But when there's 3,000 or more records this can make for a long night of watching the hour glass. So... I was wondering if it slows the process if I do some other operations of the same machine while I wait for the field to go through it's processes. Like…
-
- 2 replies
- 659 views
-
-
I want to make a video database and I need that each video is visible through FileMakerPro. I found that per each record a jpg of the poster frame of the video it's stored within the database so it raises 15-20KB for each record. My first idea was to held up to 150000 records but then I realised that the database would be more than 2 Gigs in size, and this is the limit of FileMaker! Is there any way to store de movies and make them watchable throug FMPro without having to store a jpg for each movie?
-
- 5 replies
- 1.3k views
-
-
I have an Axim (Dell). I have set up FMmobile 2.1 on it. I have files that say they are configured correctly to be used. Once sync'd, I see the field, but no buttons, or field names. There is limited direction on using the program. Can anyone enlighten me?
-
- 3 replies
- 654 views
-
-
Is it possible to create fields in FM 5.5 that when I transfer them to my Palm, just by tapping them increases the value of a variable assigned to this field? Thanks in advance Pablor (This is a duplicate post, which we don't allow. I'm closing this thread, please answer in the FM Mobile forum -bd) [ September 15, 2001: Message edited by: LiveOak ]
-
- 1 reply
- 602 views
-
-
Anybody know if filemaker Mobile support network data transfert or you always have to sync data in the cradle. (i want to use a IPAQ with a WLAN adaptor to access a part inventory database.) If not, i suppose the only other way to do this is to share by the web a database that i will be able to acces on a intranet with my IPAQ : I'm new to this, so if anybody have better idea, i will be glad to hear of you.
-
- 1 reply
- 631 views
-
-
Hello I have two files were I record data from research. The thing is that, even if they have diferent fields, I need them to have the same sequential serial number. I introduce data on both depending the kind of data, but I realy need only one serial number for reports. I imput data directely on the files (a and : or using FM Mobile Any help Thanks
-
- 4 replies
- 913 views
-
-
I had purchased (but never installed) Filemaker Mobile for my Palm 505. Recently my cell phone was stolen and I was given a Kyocera 6035 phone with Palm OS (v3.5) PDA built in. After some effort, I was able to get it up and running and synching with my desk top (Mac Powerbook G4 / OS 9.2) Feeling foolishly brave, I thought I
-
- 1 reply
- 648 views
-
-
Help me, number/series of installation of the FileMaker Mobile 2.1 S.O.S [email protected]
-
- 0 replies
- 709 views
-
-
Hey! I have a database with seven fields with one possible fixed value in a Valuelist. the reason for this is that it works well on a layout in web companion with checkboxes, and alows checking, unchecking etc on the web. The record look like this: ID value A value B value C etc 1 A C 2 B 3 B C My problem is I now have the need to use these values in portals and for export so i need to make a new file with record that look like this: ID value 1 A 1 C 2 B 3 B 3 …
-
- 1 reply
- 1k views
-
-
A while back, I was working on my company database... I clicked on a certain file that holds the listing of all the company's Quoting info (so, a very important file) and the file "crashed"; that is, the file did not open and the FileMaker program was shutdown. Fortunately, I had a copy of the file that I had backed up just a day before that I used to replace the messed-up file. I know that there is a "Recover" option in the File menu that you can sometimes use to fix some problems, but in my case, this button/option didn't work. My questions are: 1.) What causes this sort of error? 2.) How would I go about fixing this sort of error (if possible)? In the ev…
-
- 3 replies
- 869 views
-
-
Can someone let me know if this can be done (easily hopefully). I need to enter data into a text field which, once all the data has been entered will be copied and pasted into another application which doesn't support importing or stylised text. I am using buttons to enter text strings which correspond to symbols normally used instead of the text string but which can't be displayed in the other app. The problem is each symbol has a "short" version and a "long" version of it's string (eg short is "FMP" and long is "FilemakerPro"). What I would like is to type into one text field but simultaneously generate an identical one except that when a symbol's appropriat…
-
- 2 replies
- 820 views
-
-
I have seen an example file (somewhere) that used "shift-clicking" field names to show a sort of tool tip style of help box for that field. Is the use of modifier keys like this a part of Filemaker of would it have been introduce by a plug-in or other method? Has anyone seen this or know how to do it, particularly the help-style boxes? Help would be appreciated. Cheers, Murray
-
- 2 replies
- 988 views
-
-
Hi there, now i want to try to create a changeable title for every field, that mean the title of every field can be change every time. It is control by value of another field. I have attatch a 2 file ( main.fp5 and Reference.fp5). In the main.fp5, i have create 6 field (ID, Name, Address, t_ID, t_Name, t_Address). The first 3 field are use to store data and the other 3 use as display the title. Right now i set this 3 as global field, but actually i want to set it as calculation field and point to the value of the field in Reference.fp5 with a relationship. The Reference.fp5 contains of 2 text field, "Title Name" and "Reference Name". "Title Name" is use to store the ac…
-
- 5 replies
- 698 views
-
-
Hi: I have been noticing these problems for a while now and I was wondering if anyone else has seen em or if its just my problem. FM Developer 5.5 and Unlimited 6 on Windows2000 Pro Sometimes when I am in layout mode, and I select objects (fields, boxes and such), the handles don't appear on some objects like they weren't selected. It seems to happen mostly when the objects are on a gray background. Then I have to deselect everything and try it again. Holding shift and trying to select them still doesn't work. Also, if the FM window was minimized, or focus was lost on the window, when it is refocused, both the vertical and horizontal scroll bars are n…
-
- 3 replies
- 645 views
-
-
Hi there, I am running PHP with FileMaker as data backend. The data is served to the PHP using FM Unlimted. I use FX.php class from http://www.iviking.org This class is used to talk to FM Unlimited to fetch the FMP data. The FM Unlimited returns a set of data in XML format that could be read by PHP using this FX.php class. Then the data is serverd through the PHP to web users. PHP & FM Unlimited is running in the same machine OS : Mac OS X version 10.2.6 PHP : version 4.3.3 ( precomplied version downloaded from http://www.entropy.ch/software/macosx/php/) Apache Webserver: version 1.3.26 ( came with Mac OS X) Machine: Power PC G4 …
-
- 1 reply
- 2.1k views
-
-
What is the "recommended" way to create layouts and scripts for an application consisting of a major file and one or more dependent related files? To be specific, File A is a movie database with information about particular movies. File B is a related file (to File A) that holds information about owned media (DVDs, tapes, laserdiscs, etc.) where each media has a specific owner. File C is a related file (to File A) that consists entirely of ratings by various people who watched the movie. File B and C are independent of each other. Assuming File B and File C information is too large to conveniently fit into a portal and must be entered on separate layouts, my question…
-
- 4 replies
- 785 views
-
-
Hey everyone! Anyone heard of any good programs/filemaker databases for trackign inventory purchases, POs and budgets? Just curious to see what's out there that I haven't found... M [email protected]
-
- 0 replies
- 830 views
-
-
Hi All, I would like to know that let's say I have 2 files , File A and File B . From File A , I create layouts so that I could manipulate data of File B, like I could delete or add data of File B or I can view data of File B. It is just like ACCESS . Can it be done in Filemaker?? Somebody can give me a hint, I really appreciated it. Thanks Anh Tran
-
- 3 replies
- 636 views
-
-
I'm not certain where to post this question - it's fairly elementary, but something I'm unable to figure out. I use FMP Developer 6 to develop a DB being served off a MAC to both Mac and Windows machines. In all layouts of data entry, I have a close button that goes to a main menu that indicates the user needs to go to FILE and then QUIT. However, every time I access the files on the server and open them up to make a change or two, or just run reports, a text box opens saying that the file wasn't closed properly - no matter the file. I'm afraid this is causing a lot of damage to the files. Has anyone run across this? I read some articles on this, and the…
-
- 5 replies
- 1.4k views
-
-
I keep getting 'field in use by another user error' I'm serving up a FileMaker database with lots of shared users and when people are on different records but on the same layout and inputing data through global fields. (some of these globals have dropdown catogary and sub-catogory fields when the sub catogary fields choice is dependant on the first catogory field selection). And I then get a script in a related database to create a new record and set field the globals into this new record. (i'm using a seperate globals database) any ideas how to avoid this problem?
-
- 3 replies
- 622 views
-
-
Hello, I'm having a problem with our order database. Two people are using the db. Every time one of the 2 wants to create a new order record a counter is increased and the order number field of the new record gets an automatically assigned order number. Works fine, except that every now and then (once in a month or so) they get two times the same ordernumber. I've already explained them that when they create a new order, they have to make sure the first field is filled in, and they have to switch to the next field (to make sure the new record is really written). But it still happens. What can I do? Could it be that my FMpro server (v5.5) puts his write-commands …
-
- 2 replies
- 674 views
-
-
I was given a database by my company to add a layout to. The database is for purchase orders and it goes back several years. My company wants a layout created in which they can view all the items purchased sorted by the name of the company purchased from with a total for each company. There are 4 fields (company_name, date, total, and item). The summary of the total would add up all the TOTAL fields for each company (this is how much each purchase amounted to). I tried to use the automated wizard that comes with filemaker but it isn't showing up correctly. In browse mode i have individual records and in preview mode it is all on one sheet. This is what I wanted however I…
-
- 1 reply
- 628 views
-
-
Hello, I'm trying to import data from a very old FM 2.5 database. Everything seems to import fine except for auto enter info such as the creation and modification dates. Whether I open the 2.5 file in 6, or import the data from 2.5 into a new 6 file, the data still doesn't show up. Any ideas? Thanks, Andrew
-
- 0 replies
- 666 views
-
-
I am interested in implementing the technique of saving "deleted" records into another database to track these. I have 15 separate dbs in my solution - is it better to have a "deleted" database for each of these or somehow combine a single database of all the db's deleted records? If this is the case, I'd appreciate any advice on how to set this up. Cheers, Murray
-
- 2 replies
- 893 views
-
-
I have one layout, with many calculationfields. It's for calculating prices for cardboard packaging. Choises for different machinery, printed or not, etc. etc. Is there a possibility in FM to make first all the choices and then start the calculations? Now the screen is being build-up (very slow because of the calculations I think) everytime one choice is made, and also when you leave the screen(layout) and come back to it again later.
-
- 4 replies
- 828 views
-
-
Hi all, I need a little help. I have a FileMaker pro 6 DB that has 30 or so fields in each record, one of which is used to print a badge number (a number field that auto enters a serial number that increase by one with each new record). I need to find a way for the users to blank all the fields in a record except for the BadgeNumber field -- is there an easy way to do this? The only way I've found so far would be to use make a script and use clear for all of the Fields except the BadgeNumber field: Clear [select, "FieldName1"] Clear [select, "FieldName2"] Clear [select, "FieldName3"] Clear [select, "FieldName4"] Etc. But that does not seem l…
-
- 5 replies
- 767 views
-
-
After I had to reinstall Filemaker Pro 6, it now takes about 60 seconds before the prog starts. It seems that it takes this time initializing. Before I reinstalled, I also removed everything out the registry. Strange thing is, that also a compiled DB takes that time to startup. Anyone a suggestion for this? Thanks, John
-
- 6 replies
- 724 views
-
-
Hi there, now i need to help one of my client which run fm on network wich Fm server to fix their problem which they say if they create a new record and fill in some data then let it idle, the db will disconnect from server, that is just a normal setting. Now the problem is after they open again, they found that all the data become blank include the auto generate data, but the record still remain. Do you all have any idea about this problem? Regards, Henry
-
- 2 replies
- 679 views
-
-
I am working on Developing a database for a nonprofit I work at - and here is my problem: I need to generate a unique, random seven digit number for each member. The number will be the primary key (match) of the database. I need the number to be generated for each new record so that it appears as soon as the opens. Some of my concerns are making sure that no one receives the same number. That this is done within filemaker - I don't want to have to make a list of numbers and then assign it to someone manually. I am very new to all of this so any help would be greatly appreciated. Rc
-
- 6 replies
- 688 views
-
-
Hello, I recently took over the computer maintenance tasks of a small company, about five people running filemaker to keep track of advertising contacts. One of my jobs is to merge all the filemaker documents into a master doc, which seemed easy enough, but I soon encountered a bit of a nightmare. First off, these guys are running FM 2.5. Second, and more importantly, the old computer guy who designed the database left on bad terms and password protected the database so layouts can't be changed. Is there any way to retreive the password? I assume not, but thought I'd ask. Beyond this, I guess I'll have to export all the data and recreate the database from the gr…
-
- 3 replies
- 675 views
-
-
I have a text field(field1)that is setup as check boxes with a difined list content as A B C D. I have a second calc field that has the values selected in Field 1. ie If A C & D are checked in Field 1 then the result in The calc fieled is A C D. My problem is that the value in the calc field are on seperate lines & will only appear if I extend the the field downwards. Is there a way to fornmat the values to read across my calc field seperated by commas. Steve
-
- 1 reply
- 609 views
-
-
This is more like warning than question. But maybe I am wrong. I can post to our FMU 5 text up to 64k through WC directly on port 591, but port is not issue. Because on the same CPU is running IIS on port 80, we are using Web Server Connector, which is working sort of OK. IMHO it is the worst software from FMI. Now, through IIS -- WSC -- Web Companion gets only post up to 3k in length. Maybe someone knows more or this will save someone gray hairs.
-
- 0 replies
- 1.4k views
-
-
I use SMTPit for my eMailing. I want to put all HTML documents into one folder so when I click the 'Select HTML" button you are always taken directly to the HTML folder. We have many offices and I don't want the operators to search around for the right folder. I need them to be taken right to the HTML folder. Thanks for your help, Bill
-
- 1 reply
- 676 views
-
-
Hi all Can anyone tell me what the difference is between FM Dev 5.5 and FM Dev 6? Is there any real benefit in going to v6? Thanks Greg
-
- 18 replies
- 1.5k views
-
-
I have a Drug database that we will be updating on a monthly basis however I need to update this data but be able to see the previous month's data. Any ideas on the best way to attack this problem. My thoughts are maybe have a field with the currect update version ie, month but this will be a rather large database and I don't know how this will affect performance. My guess is probably close to 250,000 records x 24 could be quite large. Any ideas
-
- 1 reply
- 709 views
-
-
I'm new at using FM6 and after making a invoice file and having it as I wanted I closed out and went to another application, On returning to my FM invoice data I found errors in the price of material and price of the labor field, They where switched in each field, Also the invoice number changed from the format general to currency? What did I do wrong ?
-
- 0 replies
- 674 views
-
-
Does anyone have any idea when the next release of Filemaker (Filemaker 7) will be released. I need to buy some new licenses and I would hate to see the new version released shortly after I purchase these. Echo
-
- 7 replies
- 1.4k views
-
-
I have a couple files (fp3 and fp5) that were deleted on our server. I used data recovery software to get the deleted files back, but they are all corrupted, well most of the are, and beyond the point of using the "recover" feature in FM. If there any other option I have besides sending the files out to FM Disaster recovery for $100 a file?
-
- 5 replies
- 1.4k views
-
-
Has anyone successfully implemented a Digital Signature Pad into a database? I would like some recommendations, and pro's and con's if anyone has any feedback on this. Thanks one and all Think outside the Box!
-
- 1 reply
- 1.5k views
-
-
Is there a way that I can disable the mouse scrollwheel so users don't inadvertently switch records? I read somewhere that if you hide the status area, it should prevent the user from switching records, but I could swear that it's happened to me even when it's hidden. Anyone else have this problem? I'm working in Windows 2000 if that makes a difference. Thanks!
-
- 6 replies
- 1.2k views
-
-
Is there a way I can disable users from using the 'Window' menu to switch between files. My user_db.fp5 file is just a list of the users and their passwords (I have a simple login script), and the users shouldn't have permission to access it. The only thing I can think of for them not getting into anything is locking the status bar on that file, and having a startup script for the file default to a blank layout? Any help would be appreciated, thanks!
-
- 2 replies
- 1.2k views
-
-
Hey there, I have in my hands copies of filemaker files, made with version 1.0 on Macintosh (yes, ancient stuff , I must convert those to the most current version. The question is how to do that? Because of my optimistic nature I tried to open them with the latest Windows version but it refused to do so, so it seems I would have to do this incrementally, from version 1.0 -> ?? -> ?? -> current (Windows). Can anyone here help me figure out which versions of FM I need to be able to do this? With thanks in advance Bj
-
- 3 replies
- 931 views
-
-
-
I want to insert a currency field in several different Form Letter layouts and have it print out to the second decimal place. Problem is if the field contains a value such as 200.40, it prints out as $200.4 instead of $200.40. How can I resolve this problem and still use a merge field?
-
- 3 replies
- 775 views
-
-
Is there a known/proven way to find a corrupt layout? Using Mac OS X and FM Dev 6.
-
- 1 reply
- 830 views
-
-
Am using FM4 & 4.1 on win 2000 server & 6 users, operating real estate system. Use it for recording properties, photos, produce window cards, strip lists, preparing contracts, sales reports etc GREAT!. We have a simple window display rnning on a screen at night with a simple script behind it that steps through the properties and displays photos and text. Works fine. Want to go upmarket and in our new office (in by christmas) have say 4 displays (multiple video cards on a PC) with 4 separate "scripts" or whatever running showing 4 different properties at a time. Assuming I can install 4 video cards in one PC to drive the 4 screens, how can I address them indi…
-
- 8 replies
- 1.2k views
-
-
Hi, we have a just fine working solution with Webstar 4, Lasso 3 and FmUnl. 6 on one eMac under 0s 9.2.2 running. Well, nice but awfully slow when more than one task happends. Now we want to change to the descibed solution with 2 OSX configured (via webconnector) Macs. Any comments on this? How much can such a system speed up under real world testing in comparison to the single eMac/OS9 configuration? Is there really a notible speed gain when using two machines?
-
- 1 reply
- 892 views
-
-
What do I need on the command-line to automatically open a certain file when starting FileMaker Pro? I'm looking to use Windows task scheduler to open a file at a certain time of day so it can start the today calculations before I come in. I also need to know if/how I can pass a password for that file too. Thanks.
-
- 2 replies
- 723 views
-
-
This seems like a simple thing, but I've been hitting my head against the wall for over two weeks. I'm a FileMaker dummy. I've read some books, but quite honestly don't "get" all but the most simple aspects. Unfortunately, I've inherited this db set, and now the users want to do more with it. Eeeek!! Background: We use JobCapture by Gluon to track our artist's time, which exports into a FileMaker db, plus some other db's I've cobbled together. We use FileMaker 5.0 w/ FM Server 5. I've got two files. One, Jobcapture.fp5, keeps track of time spent on how much artists work on a particular project, the cost, the hourly rate, etc. The other, called jobtrackCPDR.fp5…
-
- 2 replies
- 799 views
-
-
I'm trying to create a timeclock solution and am wondering if there is a way to insert the server date and time into the appropriate fields instead of the client station date and time? It would be a nice built in feature to have! Thanks, John
-
- 2 replies
- 744 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online