FileMaker General Discussions

I have a question regarding creating a formula. I need to create an average formula in one field D. It needs to accommodate the following conditions: If there is a score in field A, field B and Field C then divide the sum of these three by 3 If there is a score in field A and field B then divide the sum of these by 2 If there is a score in Field B and C then divide the sum of these by 2 If there is a score in Field A and C then divide the sum of these by 2 If there is a score in field A then divide by 1 If there is a score in Field B then divide by 1 If there is a score in Field C then divide by 1 Thank you to anyone out there who can help me with this p…

• 3 replies
• 965 views

danjacoby

February 6, 200124 yr

Hi, I am looking to rename 6 relational database and was wondering what method is the best method to avoid the sub-script from directing to the wrong database. Does anybody have any ideas on performing this? Any help is appreciated. Thanks in advance. ------------------

• 2 replies
• 1.5k views

pspafford

February 6, 200124 yr

You could try this: First find/sort the records required. Cha ge to a layout that has only the required firlds on tit. Use the "Copy All Records" command to concactenate the text from thenfields together, then paste into a global field. Use the global field for the mail process.

• 2 replies
• 683 views

stac_1

February 6, 200124 yr

I need help creating a report. The database is for keeping track of ticket sales thru a variety of outlets for tour dates. The report must display the number of concert tickets sold by the different outlet types (bookstores, churches, radio, etc.) in different cities that are part of a tour 'run' of dates. I want it to look like this: RUN [March] OUTLETS CITY1 CITY2 CITY3 outlet type1 outlet type2 outlet type3 I am having trouble getting the report to sort and display the data. It could be that I am clueless...... THanks, Ed

• 1 reply
• 646 views

LiveOak

February 6, 200124 yr

Hello All, Question about creating a "Report" layout. Is there a way to list records side by side in columns, as opposed to row (ie. next to each other as opposed to one above the other)? For example, suppose I have 3 fields (Date, Player, Coach). I want to be able view the data as follows (I've inputed fake information for the example): Date 1/25/01 1/26/01 Player Michael Jordan Kobe Bryant Coach Phil Jackson Phil Jaskson Any help would be greatly, grealty appreciated!

• 13 replies
• 822 views

BobWeaver

February 6, 200124 yr

Is it possible to attach a word document and if so how is it possible using Filemaker Version 5. thanks. [email protected]

• 2 replies
• 802 views

Vaughan

February 6, 200124 yr

Is it possible to index a calculation field that uses another field from another database? e.g. In the main database I have a field call "A" which has this calculation: Max(Academic History::Term) Any help would be greatly appreciated.

• 1 reply
• 3.8k views

BobWeaver

February 6, 200124 yr

Anyone know of guidance info for creating a plugin? Where can it/they be found? Respectfully Eun Mi

• 1 reply
• 628 views

john.daly

February 5, 200124 yr

Hi Folks, We have FM 5pro and FM 5pro Unlimited. We want to SSL support to this compination (Secure server) How can we archive it. We use Win2k server. Thanks for your helps, Yalcin

• 3 replies
• 1.4k views

Anatoli

February 5, 200124 yr

I have a new problem. I have two fields in a portal window (which points to an external related file) Amount and Phase. I want to total all the rows in the portal window that correspond to the Phase. For ex: Amount Phase 10 A 20 B 5 A The total for A should be 15, and for B, 20. Thanks in advance!

• 4 replies
• 736 views

Jessica

February 5, 200124 yr

I want to get all records beginning with the letter 'I' to sort first. In that field I started all records beginning with the letter 'I' with a space. When I sort they remain in the alphabetical order. I tried selecting custom sort and sorting by ASCII instead of English but no luck. It seems to me that I could do this with FM 4 or perhaps before I installed OS 9.1 Is this a FM problem or is it an OS problem or am I doing it wrong? Help please

• 2 replies
• 911 views

BobWeaver

February 5, 200124 yr

I want my windows to restore to the size I have designed them to be, not what Windows98 thinks is cool. Whenever I "Restore" a window after "Maximizing" it (using the buttons in the title bar) the window does not restore to the size I want it to be, rather it restores to some sort of Windows98 (or FMPro5) default size and position. How can I change the default size and position? Surely Filemaker did not leave out such an important feature. Thanks, Ed

• 1 reply
• 623 views

john.daly

February 4, 200124 yr

I am currently running online (job) application forms for two large UK blue chips. I am using WebStar 4.3 Lasso 3.6 and FMPro 5 Unlimited. I have been running all on the same server (i know it's not the best idea!) with no particlar probs (about 100 -200 hits a day and of course they only add,edit,search-for one record each). Do any of you know approx the threshold at which point I'll start falling over. A bit of a strange request I know but I need to know when to go cap in hand to get my RAIC, extra copies of software etc. without the hassle of having to set it up in an evening because we're going down in flames!!! Ta for your help

• 0 replies
• 884 views

scratchmalogicalwax

February 4, 200124 yr

So they want a DB that exports records in .mdb (MS Access) format -- of course, I'm on a Mac, so... I could set the export script on a Windows-based machine, but is it worth it? That is, can I set the export format as .mdb from a Windows machine?

• 0 replies
• 656 views

danjacoby

February 2, 200124 yr

Does FileMaker Pro have a reader associated with it? I am collaborating with someone who owns FileMaker Pro and only need to search their database. I do not need to edit/create records - just search/view. Please let me know where I can find such software if it exists.

• 1 reply
• 3.9k views

danjacoby

February 2, 200124 yr

Is there any way to increase the width of hte status area? I have layouts with names that are too long to show completely in the status area. I would like to increase the size so that I could see the full names of the layouts.

• 1 reply
• 856 views

Ocean West

February 2, 200124 yr

I am trying to make a report and I keep getting the same information even though I specify different query options. I have made a copy of my database and have recovered all of my files.....but...I still get the same report......with a different date. Any solutions???

• 2 replies
• 668 views

pspafford

February 2, 200124 yr

Everytime I open a record in the active list it recreates itself on the Data entry list, as a new record, despite already exising, essentially duplicating itself, but as a new record. I don't have any scripts running with such a command. Why is this happening? Eilish

• 1 reply
• 628 views

LiveOak

February 2, 200124 yr

I am trying to sumarize the cost of multiple entries in a portal, but that very same portal with the very same information, can appear on multiple records within the same database (they all have a common customer). I am trying to run a billing report for that customer and say, if I have 3 records for that customer, I now have the portal summary 3 times. I only need it summarized once within those 3 records.... how do I have a portal only summarize itself once while showing up over multiple records?

• 1 reply
• 642 views

signal

February 2, 200124 yr

I need to create a field the header of my list view that always shows the current date, so that when it is printed it is obvious when the list is acurate from. This field will never be modified, so telling it to auto-enter the mod date is no good. Any ideas?

• 1 reply
• 646 views

PinnWal

February 2, 200124 yr

I understand how to use the find mode. However, something strange is going on when I press the FIND button I created. It points to the script: PERFORM FIND [RESTORE] GO TO LAYOUT[FORM] EXIT SCRIPT For some reason, my Position field is always set to "Designers" even though the blank find form is empty. And no matter what I try to find, (employee name or another position), it always shows the designers... using my find button. Otherwise it's ok when I press the filemaker's FIND button. Strange! All I want to do is Search based on what is inside a field. (This is so simple but I cant' do it with a button) What is the best way? Thanks, J

• 2 replies
• 801 views

Jessica

February 2, 200124 yr

I am using Filemaker Server 3.04 and Filemaker 4.1 on a Macintosh platform with about 8 users. I keep getting this message from the FM server Unrecoverable Error Occured (10199) and the FM Server Quits. Any idea what the code indicates or means?

• 0 replies
• 682 views

S Purdy

February 2, 200124 yr

I have a field 'power' which has to be a number for sorting purposes. In almost every record this field contains a single 2 or 3 digit number. Sometimes it contains two number like '93 / 125'. How can I define a calculation field that just captures the left number. Using NumToText and LeftWords does not seem to work. Any thoughts? Help much appreciated. Chris

• 4 replies
• 661 views

LiveOak

February 2, 200124 yr

I need to create a field within my list view that retrieves ONLY the newest entry from a differant, repeating field. Right now it is only showing the OLDEST entry from the repeating field!

• 2 replies
• 549 views

garrythegarlic

February 1, 200124 yr

I have a report layout set up that I am having difficulty controlling the page breaks with. I have 3 individual parts that I want grouped together and not break between page breaks. I have a subsummary at the beginning, a body, and another subsummary. Basically it is a heading, some data, then a total. Is there a utility to treat the 3 parts as one and not allow a page break between the 3 parts? Hope this is clear. Thanks, Kim

• 3 replies
• 791 views

kim

February 1, 200124 yr

I'm building a Kiosk solution and have 2 related questions: Is there any way to get a layout that is used for data retrieval to display in the middle of a screen, instead of in the upper left corner? Is there any way to put a frame around this type of layout, so it stays where all the other layouts are which are dead center and not full screen length? I assume because this layout is used for data retrieval, FM5 automatically adds a scroll bar and utilizes the entire screen length. Thanks for any suggestions. Steve

• 1 reply
• 784 views

Chris Wood

February 1, 200124 yr

Hi. I'm in a position where I have a DB that has multiple uses, with only slight tweaking of each layout. Is there a way to automatically associate a layout with a record so that FileMaker will change layouts when browsing from record to record? It would be easy to associate a record with a layout by using a value list and a script, but how can I make FileMaker execute the associated script when browsing? jeff

• 2 replies
• 996 views

mr_package

February 1, 200124 yr

I am using version 3 of the SDK binder so that I can have a multi user runtime solution. When I bind it on a PC it runs fine, but when I try to access the files over the network using the Hosts button I get the error that "Filemaker cannot host or be a guest of a file because the Filemaker file used for TCP/IP networking could not be found" Any ideas?? ------------------ Stephen Lawler Dublin, Ireland [email protected]

• 1 reply
• 731 views

LiveOak

February 1, 200124 yr

I have a database that has 3 fields and 100+ records. Is there anyway to display in browse mode more than one column of records? I can set it up in preview mode to view more than one column but I am restricting acess to edit only so my users have no way to get back to browse mode. Thanks, Brian

• 1 reply
• 657 views

john.daly

January 31, 200124 yr

Using Filemaker 5 (win) and want to store images in a container field. The database also needs to be accessed through a network, and when I enter an image and store the reference as opposed to the actual image, network users cannot access that image from a different machine. Any hints on how to get a network user to read a path that will find the image? Or any hints on any way to make it work over a network?

• 0 replies
• 577 views

gedb

January 31, 200124 yr

If your product database does not contain unique occurances of each product then you should create another level. For example You may have a product database ID / Item 101 = Universal Widget 102 = Left Handed Widget 103 = Right Handed Widget And you could have sub levels for each product. A seperate file would be a child of the main product.. 100.01 = Universal Widget (Small) 100.02 = Universal Widget (Medium) 100.03 = Universal Widget (Large) I hope this helps a little. Inventory systems can get very complex.

• 1 reply
• 786 views

PTurcotte

January 31, 200124 yr

Hi I am looking for a database template that will do scheduling for me. Any ideas?

• 2 replies
• 779 views

Ocean West

January 31, 200124 yr

Hi,I am a new file maker user. I have a problem. We developed a complex program using fm5. The program consist of 15 files. The total size of the files are 5.81 MB (Windows). Our database run very slow. What we can do to make it run faster? Reduce file relationship? make it be a runtime application? Thank's Artana

• 5 replies
• 885 views

Robert R

January 30, 200124 yr

Hi, I have a loginscreen with a login and password field but I don't want the passwordfield to be exposed. So is it possible to make a passwordfield in FileMaker like the ones you can make in web forms?

• 2 replies
• 817 views

LiveOak

January 30, 200124 yr

Is there any easy (and free!) way yo disable the Quit option in FMP on a Mac ? I have a quit button that I need the users to press, rather than them using the menu or apple-q. Thanks

• 3 replies
• 778 views

yafreax

January 30, 200124 yr

I have a membership database that is accessed by 2 other people on a network. I have script that runs when the database is first open, that says.... If Status(CurrentSortStatus) * 1 Sort [Restore, No Dialog} End If I don't know why, but whenever the other two people connect to my database, they immediately experience a sort....even if I have sorted the database already. The sort is done on surname and first name after that. It's happening every time and it just seems very odd. Any advice welcome, Phil

• 0 replies
• 789 views

Phil

January 30, 200124 yr

I have two departments who want to share a FM DB across a small WAN. The performance is poor, so I had the bright idea of locating an FM Server on either coast, and letting the daily edits stay local. I would then somehow sync the two using scripts overnight. The new import feature in FM5 allows this, in a messy sort of way, except for deletes. I don't know how to accommodate deleted records. Also - am I way off base here - these files use a lot of scripts, so I don't believe offering them using the web interface would help - I don't think you can run scripts in the browser. Any ideas to help would be much appreciated.

• 3 replies
• 727 views

George

January 30, 200124 yr

I have a scrit that collects certian data, I call them media_encode, media_title, media_URL etc. I have a database that coresponds with this data. what is the applescript phrase to create the record tell application "FileMaker Pro" open file "macintosh HD:StoryDatabase" create new record {cell1:"test"} end tell I can't get this to work thoughts?

• 1 reply
• 714 views

BobWeaver

January 29, 200124 yr

I'm new to filemaker, so there is probably an easy answer to this. I inherited a program that requires the user to start a new record by entering a number. The number has to be "not empty", and "unique". The problem is the user can't get out of the screen (cancel) the input without first typing in a number. This is annoying in the extreme. Any ideas?

• 1 reply
• 860 views

Kurt Knippel

January 29, 200124 yr

Hi all, I'm trying to figure out how I can write a script that will keep track of how many times a specific user prints a specific report/layout. Is this possible?

• 1 reply
• 1.5k views

yafreax

January 29, 200124 yr

If a user has a quotation mark (") in a field and I want to remove it, how do I go about doing this? I tried: code: Replace(description,""","") which would obviously replace any quotations in the field with nothing, but this does not work. An example would be: Description field: "This is driving me nuts" I would want it to be: This is driving me nuts Is there any way to do this? Thanks, Eric

• 4 replies
• 1.3k views

airbaal

January 29, 200124 yr

Help, I have a PO form in PO d/b with a portal window that has several details per PO, that is stored individually in PODetails d/b. All I want to do is have a button that jumps to that other file with the related record based on the contents in the portal row. I have an external script in the PODetails d/b that does: Enter browse mode[] Go to Layout [Layout 1] Go to Related Record [Relation1] where Relation1 is relationship based on PO ID (from PO) and PO ID (from PODetails) which is wrong since I only want to see the exact detail in the portal row, not all details regarding that PO id. What should my relationship be? and what is wrong with my script? THanks, …

• 1 reply
• 606 views

BobWeaver

January 29, 200124 yr

HI, I have a task schedule set up. When a task is completed I would like to send the complete record to an other fm file like completed orders.fm5 and remove it from the schedule file so as to not clutter things up. I have set up a script which exports to a temp file and and a completed order file which imports form that file but it is mighty cumbersome and also can crash fm. I am open to any options your help is appreaciated. Raif

• 3 replies
• 688 views

raif

January 28, 200124 yr

where can I find definitions of invoice terms like "line item"

• 1 reply
• 920 views

LiveOak

January 28, 200124 yr

Hi, I would like to split the list view into two collums, much as my header says , so that the different records are shown in a 1) on left 2) or right 3) on left 4) or right and so on. Is this possible? thanks Raif

• 1 reply
• 1.1k views

danjacoby

January 28, 200124 yr

I have the following situation, and it has probably been answered here several times, but I haven't been able to find a solution. I am trying to related a master file to a contact file where someone entering in data can pick from conditional popups, and add new items if needed. Say, Customer Name Customer Contact (multiple per customer) Product (multiple per customer and mulipule per contact) Product Division (again, per customer/contact and product) The trick is, I want to pick a customer and see only contacts for that customer, then pick a contact and see only products for that contact, then pick a product and pick from only products for that product. But, …

• 0 replies
• 735 views

abridges

January 27, 200124 yr

How can I prevent the user from deleting records from the menu while allowing him to delete records through a command button? I only want the user to be able to delete records created today. Where does FileMaker get today's date from? Does it get it from the FileMaker Server? Or the users' computer?

• 3 replies
• 677 views

manitobaangler

January 27, 200124 yr

Being new with Filemaker, I have looked at some templates to get an idea of what type of user interface looks good. I really like the "tabs" type of interface at the top of each layout form, rather than the Menu method, because of the one-click interface. How does this get setup? Any help would be greatly appreciated.

• 2 replies
• 691 views

righty

January 26, 200124 yr

I am new to the forums and I am sure this topic has been discussed, but... FileMaker 3.0 and 4.0 use 99% of the CPU when any FMP dialog box is open under Windows 2000. This is a real problem, especially for laptop users (try leaving a dialog box [eg: ScriptMaker] open for awhile on an 800MHz laptop and see how hot it gets!) Does anyone have some background information on this problem? Does FileMaker, Inc recognize the problem? Thank you.

• 0 replies
• 1.3k views

kazanjia

January 26, 200124 yr

quote: Originally posted by Robert R: How do I change the caption on a command button? Open the status area and select the font tool (the "A" button) then click on the button. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-=

• 2 replies
• 846 views

Robert R

January 26, 200124 yr

I am going to publish a db to web with FMP Unlimited. I am going to use Dreamweaver Ultradev 4 for the web site and ODBC for db connection. Is my choice ok ? Any suggestions ? ------------------

• 5 replies
• 1.3k views

Anatoli

January 26, 200124 yr

Just a quick question. How do you redirect to another layout in another file? Preferably through a press of a button. Thanks!

• 6 replies
• 928 views

Jessica

January 26, 200124 yr

I want to select a 'PROJECT' in a look-up field. The field selection works, but how would I attach the following script to the look-up field for execution on exit Set Field ["globalProjectlID","modelID"]. I want to use this to create a related record. Many thanks.

• 1 reply
• 798 views

LiveOak

January 25, 200124 yr

Hi all, Need some basic script help with FMpro. I'll disclaimer myself by stating upfront that I'm so used to using Access, FMpro is quite different (all most too simplistic??) I have two dbs that I use. In the first DB1, I keep track of my current and ongoing project, each project is assigned a unique number. In the second db, I'll call it DB2, I keep track of my completed tasks for the projects. I've defined a relationship between the project ID# field in both dbs. I know that I've done this part right, because, the second db pulls information (like the project title and due date) from the first when I enter the project # in. Here's what I'm trying to do: I wan…

• 4 replies
• 796 views

GuildGirl

January 25, 200124 yr

I do not have an ISP that provides CGI capabilities. I am currently using a free hit counter, but don't like the fact is is redirected to another server just to record page hits. Is there any way to use logging in FMP Unlimited or through IIS to provide information for a hit counter?

• 1 reply
• 1.1k views

Kurt Knippel

January 25, 200124 yr

I finally have the time to look at FM5 and I downloaded the trial version. When I open my 4 databases and type in my admin password everything opens fine but I cannot access layout, scripts, etc. The templates that come with it allow me to access the entire file so I know it's not a trial limitation. Any thoughts? Thanks, Nati

• 1 reply
• 654 views

LiveOak

January 25, 200124 yr

I sent this once, and it appeared, then disappeared. So, take two... I would like to print, at the bottom of each page of a summary printout, the following: "Page ## of __" with the underscore part being the total number of pages. How do I do that?

• 1 reply
• 698 views

BobWeaver

January 25, 200124 yr

I handle registrations for a boy's camp. One field that is entered is the boys birth date. Since FileMaker treats a 2 digit year from 00 to 89 as a 20xx year, there are often incorrect entries if someone (often me) forgets to put in all 4 digits for the year. I have set up the field name (birthdate) to change to ERROR if this happens, but this is not sufficient to be noticed easily. Is there a way to make it change to red or flash or some other way to make it obvious that an error has been made? Dave

• 1 reply
• 723 views

Chuck

January 24, 200124 yr

I am attempting to create a database involving a large quantity of digital images using Filemaker Pro 5.0, rev. 3, running under Windows 98. This is a volunteer project for an historical society, involving nearly 35,000 images of old 18th and 19th century wills. The purpose of the database is to allow patrons to retrieve images of the wills following a search in fields for names, townships and years. The wills were microfilmed, then converted to digital images by the state historical facility in a TIFF Order II, Class F, Group 4 fax compression format. The images are on a series of several CD-ROMs, with subdirectories for ranges of years. Unfortunately, FileMaker Pro …

• 4 replies
• 786 views

john.daly

January 24, 200124 yr

Just a quick question. How do you redirect to another layout in another file? Preferably through a press of a button. Thanks!

• 1 reply
• 651 views

BobWeaver

January 24, 200124 yr

I have many files that need dates entered into its records. For one file, I built a file that's a small calendar that pops up when a date is clicked on, then the user picks a date and that date is issued to the date field of the original file. So far I've figured out how to make this work for various fields in one file, but how do I make it work for various fields in various files with only on calendar file? Thanks.

• 1 reply
• 671 views

LiveOak

January 23, 200124 yr

We have developed a very sophisticated EDI 810 and 856 solution (for several large retailers) in FMPro5. Am willing to exchange info with someone who has devloped a successful BOM (Bill of Materials) solution. Email [email protected] ------------------

• 0 replies
• 1.1k views

FM_Aster

January 23, 200124 yr

Okay LiveOak and DanJacoby, your help has been great! Things are working great! Well almost. I have two more things that I can

• 2 replies
• 683 views

LiveOak

January 23, 200124 yr

Sabes es bueno poder escribir en espa

• 1 reply
• 754 views

Ocean West

January 23, 200124 yr

How can I create a field with repetitions taked from another field?? Is it possible??? For example If numb_pay(field number)is 20, pay (repeating field)take a 20 repetions too. TKS God Bless you

• 1 reply
• 680 views

Chuck

January 23, 200124 yr

I have a few tables that, combined, have the necessary data to create an invoice: Transactions contains all the details about the payment, shipping, customer info, etc. Orderline contains the line items for each order. There is a one to many relationship from transactions to orderline. Products contains product information. It is related to orderline because orderline only contains the SKU for a product and the subtotal (quantity x price). You need Products to get the product name and price per unit (especially when there is discounting involved). This is pretty much the way the tables are downloaded from the ecommerce software I am using. It is simple enough to cre…

• 1 reply
• 576 views

danjacoby

January 22, 200124 yr

I was at the recent MacWorld and during the demo of FM5 and the FM folks said that the you can now trigger a script when a selection is made from a popup list or menu. I can't seem to find anything about it in the documentation. Can anyone point me to it or show me how this is done? Thanks, Way

• 4 replies
• 742 views

Chuck

January 22, 200124 yr

Has anyone had any experience making FM5 work with Pegasus E-mail ?

• 0 replies
• 593 views

dobrorod

January 22, 200124 yr

I have the following AppleScript: tell application "FileMaker Pro" open file "Logfile.fp5" with password "Admin" end tell However, I am getting errors when I run it, specifically, error -10011. What am I doing wrong? Best Regards, Jeffrey Ellis

• 1 reply
• 712 views

BobWeaver

January 22, 200124 yr

I have created a series of layouts to serve as a slide show presentation using buttons to move through the slides. For presentation purposes, I would like to eliminate/hide the vertical and horizontal scroll bars and the top menu bar. Can anyone help me with this? Is this possible? Is there a FileMaker solution or is it an OS solution? I am using both Mac and Win98. Thanks in advance. -Jeff

• 4 replies
• 641 views

Vaughan

January 22, 200124 yr

On an input screen the inputter will enter a leave date, leave hours and then select from an popup menu a three letter code. I want to transfer the leave hours to a field which name is the same as the three letter code. e.g. 1/21/01,8 hours, CWL. Transfer 8 to a field called CWL. Right now I accomplish that by clicking on a button that runs a script. However it requires the inputter to not forget to push the button. Is there a way to automate that?

• 1 reply
• 1.2k views

BobWeaver

January 21, 200124 yr

I have not been able to get any results from an answer to a previous question. Maybe I am not interpreting it correctly. I will pose it as simply and detailed as I can: I have one file called test. I consider it the related file. It has 2 fields: 1. Name text indexed 2. City text I have a master file called mtest It has 2 fields: 1. Name text 2. City text lookup looked up value: copy from "test.fp5"::city "If no exact match do not copy" is selected "Don't copy contents if empty" is checked. Look up a value from the first matching record given by the relationship: test Define Relationship: Related name: t…

• 3 replies
• 602 views

john.daly

January 21, 200124 yr

I have two databases employees and Jobs On the employees I have a field that has buttons of Dept. A, B, C, D. some employees may work in more that one dept. In Jobs I have two fields. Dept and employee. I won't the employee list to only show the employees that are marked for that Dept. Can this be done. Devin

• 3 replies
• 696 views

Chuck

January 21, 200124 yr

Is there any way to stop a startup script that has "Allow User Abort" turn OFF? (I know...why did I turn that off during development?!!) I've gotten myself into a loop that won't let me get into scriptmaker and change my mistake!! I have a backup file but I spent several hours making some serious changes and don't want to start from scratch again.

• 2 replies
• 1.3k views

macavity

January 21, 200124 yr

Help! I have Invoice d/b and InvoiceDetails d/b. Ex: Invoice#100: Grand&Toy InvoiceDetail#1001 Staples InvoiceDetail#1002 Paper InvoiceDetail#1003 Labels When I create a new Invoice (#100) with 3 details, it should simultaneously copy 3 records to InvoiceDetails d/b. This InvoiceDetails d/b should contain every detail from every Invoice record. I am having trouble with the scripting to copy records to the InvoiceDetails d/b. (THe number of details should be dynamic and a button should allow user to add new detail) Or should it even be copying? Maybe it should be the actual records from the InvoiceDetail d/b and a portal should be used to …

• 3 replies
• 1.3k views

Jessica

January 20, 200124 yr

I have used Filemaker 3.0 on Macs for several years and am quite familiar with the product. I recently installed Filemaker 5.0 and updater .03 on my PC which runs Windows 95. For some reason when I'm in LAYOUT MODE and I copy and paste a field (in the same layout or other layout in same file) the pasted field does not appear when I switch to BROWSE MODE. The repasted field appears as though it is still in LAYOUT MODE and cannot be accessed. Is this a feature/problem with FM 5.0 or is it a problem with my installation? Thanks, Vince.

• 2 replies
• 597 views

Vinny2

January 20, 200124 yr

Anyone know how to disable the start up screen and "opening xxx as a guest of xxx" dialog boxes on startup. I have heard that developer can do this but I am hosting on FM Server. I just upgraded to Server 5.0, do I have new options now? ------------------ Edward Newman, MCSE Senior Manager Universal Security Systems, Inc.

• 1 reply
• 762 views

LiveOak

January 20, 200124 yr

I would like to create a way that I can go to a layout and have it only show certain records. Example: I have some records that are label in a field

• 1 reply
• 767 views

Kurt Knippel

January 19, 200124 yr

Hi Does anyone know of a way of accesing image filenames (and paths if possible) of pictures imported into FM5. I really want to be able to achieve a sort of "collect for output" as per Quark Xpress. If this is too complicated just a pointer to where the image is would be nice that I could display in a field. Thanks in advance. Andy.

• 1 reply
• 678 views

yafreax

January 19, 200124 yr

I have been around the FMP package for about six months and am not familiar with the program'shistory. Will someone kindly advise how often FM Inc. brings out new versions. i.e. Corel brings out a new version every year, bugs and all...like a Cash Cow. Was wondering about FM Inc. Respectfully, Eun Mi

• 1 reply
• 708 views

Ocean West

January 19, 200124 yr

What if I would email an invoice made in Filemaker to a client who doesn't have Filemaker ? ------------------ Yeti

• 11 replies
• 1.1k views

Pengo

January 19, 200124 yr

dreamweaver wrote: quote: i am trying to show only the first 20 records of a search and sum all the other records found as a 21st recors called others, any help guys?

• 1 reply
• 801 views

john.daly

January 18, 200124 yr

I've made a script to perform a subscript: Perfom script (subscript, Extern:"invoices") When I run this script it partially works (but that's a different story..), but what bothers me is that a little (*) appears behind "invoices" each time I run it. When I doubleclick on the script the (*) disappears. Do I need to worry or just ignore it and get on with it. ------------------ Yeti

• 1 reply
• 1.5k views

Kurt Knippel

January 17, 200124 yr

I am using a repeating field with 200 lines to comprise the body of a proposal. In this case FM is replacing what was previously done in Excel. Here is my dilema. As in excel, I need to be able to "add" a line in the middle. Oops I forgot to sell the customer 4 widgets, and that should go between the dingbats and thingamabobs. The only choice I have right now is to copy and paste of write a whole lota scripts to make a move up or down button. This seems so simple. Any insight??? ------------------ Edward Newman, MCSE Senior Manager Universal Security Systems, Inc.

• 1 reply
• 659 views

danjacoby

January 17, 200124 yr

I'm trying to make a relationship between two records based on a text field. This text field in the Master file may not contain all the same text as the related field, but the related field would contain all the text in the Master File match field. Filemaker book says Formulas work, but is that only for numbers? Can someone suggest how this might work?

• 11 replies
• 876 views

signal

January 17, 200124 yr

We are a school trying to install a French dictionary into FP5 for our French teachers. I'd appreciate any insight that could help. TIA, Mike ------------------ Michael Kane Comuter Technician Sewlyn House School [email protected]

• 3 replies
• 718 views

john.daly

January 16, 200124 yr

HI I m trying to accomplish the following Im using Filemaker pro 5, I've created a DB in order to keep up with all the jobs we have. Each job is allocated a job No. everything is working fine except I need a calculation to complete the DB. I have 5 feilds, each feild I need to give a seperate value eg.

• 2 replies
• 1.9k views

Carlos

January 16, 200124 yr

Hi all We have been running FilemakerPro Server on a NT4 machine for almost a year, without any major mishaps. This morning, the Server crashed, and the backup tapes we had been using show the backed up FMP data as being non accessible. This left us with no other option than to rebuild the server, which I have done, with the main concern being to get FMP up and running again. Well, the serever is up, but when I was installing FMP Server, the installation asks for the installation code. After pulling the Comms room apart, you guessed it, no sleeve that should have the number on it. I did the obvious, phoned the number that appears with the limited amount of docum…

• 4 replies
• 733 views

LiveOak

January 16, 200124 yr

Use the Save a Copy As command from the File menu or in a script. I actually use a script that runs automatically each time you exit the databae and rotates through three different backups i.e BackUp1.fp5, BackUp2.fp5 and BackUp3.fp5. That way you always have a copy of the database from the last three times you closed it or activated the back up script.

• 1 reply
• 636 views

kie

January 16, 200124 yr

Well, The subject pretty much says it all. FMS 3.0 is installed on a WinNT SP6 computer. The server service start up fine, and all databases are opened. Unfortunately, none of our clients can see the databases (or the server) as online when they click "Hosts" in the 'Open Database' box. Even when I manually define the host (type in the IP adress), it does not see the Server/Databases. The Server PC performs well in other functions of the network and has the latest FMS patch installed. Anybody have any idea what is causing this ?

• 2 replies
• 614 views

Vaughan

January 15, 200124 yr

I would like to use FMP5 Server and FMP5 Unlimited running on two NT boxes (one server and other workstation) to publish 15 DBs to an intranet of approx. 125 users of which only 10 to 15 will be concurrent users at any given time. The DBs are mostly less than 5000 records. The environment is a Novell Network 4.1x, Windows 95 clients. Question: Are FMP5 Server and FMP5 Unlimited capable of handling this environment or do I have to look at something like Cold Fusion? I understand FMP5 Unlimited is single-threaded? True? Mike

• 1 reply
• 1.2k views

Kurt Knippel

January 15, 200124 yr

I'm running FileMaker 4.0 (server version is the same) and more than half the time I attempt to launch the program, I receive an access violation error message from Dr. Watson before any files are opened. Any ideas on how to correct this? Thanks. Barbara

• 2 replies
• 773 views

Barbara Prine

January 15, 200124 yr

My FileMake Pro 5 User's Guide says on page 2-5 "If you're working with related files, you can add records to the related file as you enter data in a record in the master file." "You can only add related records from the master file if the relationship is defined to allow the creation of related records". If I have a master file of names related to another file with names, addresses, phone numbers etc. and the relationship is defined to allow creation of related records, and the name in the master file is related to the name in the other file, and the master file looks up address, phone number etc. in the other file, should adding a name to the master file and fi…

• 1 reply
• 619 views

Chuck

January 15, 200124 yr

Hi, Installed a filemaker file and is on the internet through web companion. But it has always on top black frame where home and help menu are. Is there any way to change this pre configuration, new link and menu name within instant web? If i go into cdml now it is to much. Later will find time to try that but now need Pretty soon that use. I connected filemaker 5 file on the web with a web style soft grey . I s it possible or not suppose to be the matter of filemaker not made for? will i hear anything from you?

• 2 replies
• 698 views

tilmes

January 15, 200124 yr

Dear FileMaker Users, My FM Help file refers to a 'New Request' option for doing multiple finds (an 'or' function). In my version of FileMaker Pro (Macintosh, 4.1v3) however, the commands 'New Request' and 'Duplicate Request' are not on the Mode Menu, and indeed are nowhere to be found! Can I get an upgrade (or patch) to correct this? The problem existed under OS 8.5 and still under OS 9.0.1. Thanks! Daniel Rosenfels

• 2 replies
• 758 views

rosenfels

January 15, 200124 yr

Help! I'm wondering how I can change the docket # automatically using the first 3 letters of the Company Name and then some numbers after it. For ex: Company Name = Nortel Docket ID = NOR100 This should change as company name changes. Thanks.

• 2 replies
• 842 views

Jessica

January 15, 200124 yr

I am designing a "donation" file for a NPO somewhat like was discribed in a thread back in December started by Ron Fugazzi. (I am just now catching up on my mail). What he described sounded a lot like what I am doing (a renovation of what I have worked on for 6 years). I use FMP5. PC platform on a network. Previously the bookkeeper had to enter deposits on excel, enter totals to Peach Tree, and post donations for receipting on FMP. I am trying to cut out the extra work and narrow it down to FMP and Peachtree. I have come up with three related files. Deposit Deposit Record Donor Record We have many donors, some of whom give to several "funds" month…

• 3 replies
• 737 views

radams

January 15, 200124 yr

I need a Filemaker 4 (Trial) Version to read a file from a colleague of mine. Does anybody know, where I can get one? greez chefsalat

• 0 replies
• 1.5k views

chefsalat

January 14, 200124 yr

You'll have to help me out. Do you mean a "draw" in the sense of a amount issued before a commission is earned OR a "drawer" as in the place where dollar bills and change are kept in a cash register? If it is the latter, take a look at www.posdirect.com. I've done business with them over the years and just met with them at MacWorld Expo. They should be able to provide what you need, if it's a "drawer". -bd

• 1 reply
• 761 views

Bikeman17

January 14, 200124 yr

Just wondering if anyone knew a workaround or plug in that allowed the use of more than the first 15 digits in calculations. I was caught off guard by this. 15 digits is a lot. Generally it will work, but not using the rest of the data to process some calcs results in different answers. This is not acceptable when digits 16, 17, 18, ... are very important. Thank you JW

• 13 replies
• 925 views

LiveOak

January 13, 200124 yr