FileMaker Legacy fp3 and fp5

I need some expert advice. I am using FMP to generate announcements for a class web page at a university. I have the professor use a web-based entry form for the records. For the body of the announcements, he needs to be able to use indentations and other formatting styles that he writes in a visual-based web design program. I want him to be able to just cut and paste the HTML straight into the announcement field. When he does it as is, it scraps all the code and treats it as text. Is there a plug-in to do this, or is it simply a matter of writing extra CDML into the page to recognize HTML. Any help would be greatly appreciated.

I am using File Maker Pro 5 to create a school e-mail service to inform teachers when they are to cover lessons. However when I import the information about the staff the data for one record is automatically divided into 2 different records, is it possible to combine 2 records, because if it isn't I will have to send each member of staff 2 e-mails, which is very unhelpful. So if it is at all possible could you inform me of any methods in which it is possible to combine 2 records into just one. Thank You Miss Betteridge [email protected]

I need some HELP! We use FileMaker Pro 4 We have a classified database and I can't get the issue number to show as an active ad. Status: should be active If(CatFlag="S" or CatFlag="H","ACTIVE HEADING",If(WeekofYear(Today+5)-1 * Start Issue No. and WeekofYear(Today+4)-1 * End Issue No. or (End Issue No.<Start Issue No. and Start Issue No.+Run For>51),"ACTIVE",If(Classification Number="99","ACTIVE",If(WeekofYear(Today)=End Issue No. and PAY METHOD*"FREE","ACTIVE","INACTIVE")))) Start No.: should be 2 If((DayName(Date Entered)="Sunday" and Time Entered >61200), WeekofYear(Date Entered+5),WeekofYear(Date Entered+4)) End No.: should be 3 If(Run For="99" or…

Is FMP patched to 4.1v3? Is the TCP/IP networking on the computer configured correctly and working?

It's times like these, i feel inadaquate (like when i can't spell too . . .) Anyway, this seems like it would have to have a simple solution, but i just don't know it. I have to develop a inventory control that keeps track of different companies shells (printing term). It obviously needs to subtract and add from the number of Quantity on Hand each time some are removed or added. I was thinking initially 3 DB's. Main with all company info and Current QOH. Then a Removal DB and an Addition DB. IS THIS THE BEST WAY?:? and if it is, i have already tried it, but i can't figure a calculation or script that would correctly update the Current QOH?!?!?! Is it just me, or…

English Hi, all 1)I have my DB with a some repeting fields, my questions is. Can I paste the Current date, just with a click? or a tab? this is in a repeting date field 2)In the same DB I have a script to paste some information from 2 fields (pay, date) the script it's to paste this 2 filed in a last repeting field and when the repeting filed it's full send a message i.e.: SCRIPT Cut [select, "date"] Go to Layout ["Payments"] Set field ["Last(howpay)"] Paste [] Go to layout ["oroginal layout"] Cut [select, "date"] Go to Layout ["Payments"] Set field ["Last(howpay)"] Paste [] Go to layout ["Original Layout"] With this script doesn't work, you know…

I need to input chinese words into my FMP5 database. But the words inputed are not what i have typed!Why? And, how to solve this problem? Anyone know the solution, please feel free to reply me.

I run an automobile dealership here in Arizona and am looking for something that will allow me to keep track of the number of contacts, sales, write-ups, demos etc that my salespeople are taking. Is there any template or fully written program I can use with filemaker out there. I am attempting to do it myself but I don't have a lot of free time to devote nor do I have an in-depth knowledge of Filemaker Pro 5.0. Any and all help would be greatly appreciated... John R. Ellegard [email protected]

I have a customer DB I have a job DB which has a menu filed for customers. It also has a radio field for open or closed. I have a invoice DB which will have 2 fields to connect it with a customer and a job. After choosing the customer, I would like the job field to only show "open jobs" for the customer previously choosen. Any help is greatly appreciated. After seeing this, it should help me with a lot of future relationships. Thanks in advance

I'm using FMPro 4.0 on both a Mac 9600 with 248mb ram and a G4 with 384mb ram, and on both systems, all FM dialog boxes display text that is small, jagged and compressed to the point that it is unreadable in most cases. It has done this from day one. Is there anything I can do to fix this problem? None of my other programs do this. Thanks, Michael McKenzie

When using the "Send Mail" script step, what happens to the "mail" that you want to send? How does FileMaker communicate with your email server. I am using FileMaker 4.1 on a Mac that is connected to Tufts University's network. I use Netscape for email. I have been told that FileMaker can't export email to Netscape so I downloaded Eudora and set that up. I am still baffled. I would like to be able to send a personalized email message to members of our mailing list. I can export a usable list of email addresses easily enough, but I was hoping to use the "Send Mail" feature to personalize them. Anybody know how to do this? Chuck put a useful link to an article he wrote--…

I am currently using FMP 3.0v4. I am trying to set up a report that will give me turnaround time of working days (mon-fri) on how long it takes to complete jobs. I've set up two fields and date in and a date out. Using these 2 fields I'd like to calculate the number of days. For example if a job comes in Thursday and out on Monday I'd like the result to be 3 days. Please let me know if there is a way of doing this. Thank you in advance

I have a Vendor database that I have set up radio buttons to show active or inactive. I have the hoices manually put in in the field format. I have a separate database for invoices. I have a menu field for the vendor name but I only want it to show active vendors from my vendor list. Sorry if this has already been asked or answered but I am stuck. Dave

We are using Filemaker5 Unlimited currently as a web server along with Filemaker5 Pro Server as a site for our databases. Both computers are Macs. We are using Home Page 3.0 for Web interaction. How do we make our Web server site secure? This would be the first step to taking payments over the Web. I'm new at this, please help.

On the first of january 2002 a dozen countries or so in Europe will convert to a new currency, the Euro. Like every other currency this one has a special symbol (like $, or fl). It may seem aerlu to start this now, but in due time we'd like to show dutch guilders as well as euro's on our invoices.... So: can anyone tell me how to get this currency symbol in Filemaker? TIA ------------------ Yeti

I am trying to find a way to get a summary of how many projects were done this year. The way my database is set up is that for each sku there is a separate record. However eash project has several sku's with the same project number. I want a summary that will count all records that have the same project number as 1. For example: Project # 463-01 has 4 sku's Project # 475-01 has 10 sku's Project # 480-01 has 2 sku's in total there is 16 records created what I am looking for is a summary that will let me know that 3 projects where done. Please let me know how to solve this problem. Thank you in advance.

I am wanting to use FileMaker Pro 5 as a front end for MSSQL Server 7.0 -- on a Mac. Is this possible? I was just on the FileMaker site and it appears that only Windows is able to access SQL Server. Any ideas/help would be awesome!

Does anybody have a solution for including formatted text in a calculated field that is used for the Email Body? I have a calculated field that emails users Username and Password back to them and I would like it to look like this: Save this information for future use- Username: Whatever Password: Password I type the calculated field this way but when the email is sent, no carriage returns are displayed and the text just shows up in one long sentence.

It might be the time of year (miracles and Santa Claus) but when I delete a record in a related file (invoices) the record also dissapears in the adressfile! I checked the relation and the box for whiping related records if the record is deleted in the active file, but it's unchecked. What's going on??? It's my last day at the office this year, so I wish you all a merry x-mas and a happy new year. Keep up the good work!!! ------------------ Yeti

Sorry, but how can a cost be <25 and >50 at the same time? Give this a try. Case( Cost <= 25, Cost * 2, Cost <= 50, Cost + 30 Cost <= 100, Cost + 50 Cost <= 200, Cost + 75, 100) The last value is a default, if none of the tests succeed. The Case statement performs the tests in order, so an "and" criteria is not needed. -bd (engineering major)

I have a solution that has a lot of value lists which have default values that are then added to by the user. I also have global field values and some global repetition fields (I know, I know, I shouldn't use them). How do I move all this 'stuff' to an upgraded solution without having the user involved? I'm running version 5 developer under Windows.

Capt Kurt: I want to transfer all of items in all of the value lists to the new solution, as well as other global values. Since the solution may exist on hundreds of PCs (or thousands if I'm lucky), it must be a totally automated process. I know I can get the value list items out using the design functions, but how do I put them into a new solution? What about other globals that need to be moved? Someone must have needed to do this before me!!!

FileMaker Pro 3 We have G4s, G3s and IMacs, most using the 9.04 OS, and when we print the program crashes. This is only happening when we are trying to print. Any suggestions? Thanks Heather

I am a systems manager new to a school and I am currently creating a database of student records as well as schedules of each class. The way my database is setup is one layout that would contain that student will all information classes, grades, first name, last name broken up into 12 quarters. Then separate layout for each quarter for grades classes, class location, teacher, and day, ECT. Example: Jim Smith Class name Time Day Teacher Grade Classroom Math 1 4-7 Tuesday Bill 10 201 Science 5-8 Wed Mary 10 202 History 7-10 Thursday Jake 10 219 The problem I am having is that the fields

I have a large number of fonts on my system because I do a lot of graphics work. Whenever I start FMP5 it takes it forever to load because it scans through all my fonts. Is there any way to stop FMP5 from scanning all the fonts? Thanks in advance for any advice!

Hi I know you shouldn't style individual text elements within a field but... I need a calculation to find italic/Bold text within a text field and replace with "tag & StyledText & tag" (any plug-ins out there). or if this is not possible, have a dictionary of words that should be replaced. If the former is not possible has anyone got any pointers for creating this! T

Hi. When exporting the ''return'' key in a text calculation field and importing into Quark Xpress I actually get the ''enter'' key which forces a new text box in quark instead of just returning the line. I have tried using <n> an Xpress Tag that gives a soft return to bodge the job, but this isn't ideal. Grateful for any ideas. Cheers.

Does anyone know how to configure DDE Share so that a Filemaker data copy will paste into Excel under NT? I've got a rough idea but working out the exact configuration is proving a pig.

This would be done by creating a "compound key" upon which to base the relationship. For instance, in a timecard database is would be fairly inconvient to have a separate file for each employee's timecard records. With a simple key, each entry might be a date. With a compound key, each entry in the timecard file could be based upon an employee ID and a date. For instance: CmpdKey (calculation, text) = Right("0000" & EmpID, 4) & Date The perferred solutions is to use one file. For example, with four separate sections a report needing data from all four would be very difficult to create. -bd

Hi this is what I am trying to achieve I have three number fields "begin" "end" and "interval" I want the values of begin and end to be based upon interval so the user sees this all in years... Begin End Interval 0 1 1 1 5 4 5 10 5 10 15 5 I know it can be easily done with a script but I want the user to see the values being entered automatically for begin and end any help is greatly appreciated!!! THANKS [This message has been edited by krusader (edited December 28, 2000).]

quote: Originally posted by namadany1: I have a large database saved as an SDK (don't need the software to run it). Can this run on a PC as well as a Mac? I assume you mean that you created a runtime with the SDK. All executable files are OS specific, unless you are running some kind of emulation software. So you will need to use the Windows SDK in order to create a Windows runtime. However the actual Filemaker database files are cross platform. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-=

I have a small network (up to 8 users) running an application in Filemaker v4.01 Would like to install the Server version to improve performance, but I can't find it anywhere! (I used to see it all over the web, but since version 5 came out, nobody carries v4 anymore. Puzzles me, as from what I understand, the 2 versions are not compatible to be networked, so there should still be a large demand for the older version) Any help is appreciated

Hi All-- I am currently working on a database containing over 100 layouts. However, I will end up with over 200 layouts by the time the project is finished. I have these reports grouped under a heading like (QTR1 Reports, QTR2 Reports, QTR 3 Reports, Yearly Reports, etc.) The new upgraded version of FileMaker Pro only displays 1 column of layouts (instead of all layouts in multiple columns) with an down arrow so you can navigate to the other layouts, very slowly! This just makes creating other reports very time consuming. Is there a way to turn OFF this option so that all of the layouts are shown in multiple columns or is there a way to organized layouts in extended …

Need help resolving this: I have a DB that allows clients to assign dates to records. When those dates have arrived FM does a search for records whose dates are valid and displays the items. It works like a To Do list. Problem is this: Clients need to be notified daily of birthdays. Birthdays are in the past. So a simple Status (Current Date) match does me no good, but I need to be able to find birthdays that are today and any days that have not yet been checked. (If my clients do not run Filemaker for a few days, they need to be notified of all birthdays that have happened since the last time they were notified.) Another trouble area for me is the fact that if they run …

Is it possible to display related fields, under condition one of these fields matches a given condition (=, <, >, ...)? Actualy I have members of a company, that I'd like to display with the company informations but only if they are still in the company (0/1 field). However, I'd like to keep these records and the company they used to belong to even if they go away... Thanx for help and happy new year! Nico

Hi All, Have a big problem with printing in Filemaker (version 4.0). I have a database designed for a company. The main purpose of the database is to generate reports. The reports tend to be big, like 200 plus pages. The printer (which is shared) is linked to one computer (windows 98)in the network (windows 95/98/NT network). If anyone sends the report to print through the network to the printer it prints about 30 pages and then just feeds the rest blank. They called me and I went in and did a workaround. I set up filemaker on the computer that had the printer. It still printed only 30 or so pages and fed the rest blank. I determined that maybe it was a memory problem …

I have created a FMP db for the web. I have got it hosted using Web Companion from my home using a cable modem. The 'problem/question' is this: It's sloooowww. It doesn't look anything like the actual file does on my desktop. What do I need to do to make it look and run like it does on my Mac&PC? Any help and suggestion will be greatly appreciated. It

I have been supplied a Microsoft Access Database, and was wondering what would be the best way of importing it into Filemaker Pro. Could I use the ODBC driver for Access? I am on a Mac, and understand that Access is not available on Mac, but could I do the import from a PC?.....Or, should I export the data into an Excel spreadsheet, then import it into Filemaker. I have tried this method, but it didn't export all my records...only 65536 out of the 79000+ records. Is there a limit?

I can't get auto-filled data to appear in a new record.htm so the user can see the info for those fields. After the record is submitted the info is there correctly but it doesn't show in the new record.htm. I've tried to use the cdml tag: [FMP-Field artNumber] in a textbox and not in a textbox as is used for the display. My guess is it's not accessing the dB in order to display this info only the field names. Thanks Wayne

I have a web page where I have automatic filled fields for a new record. Unfortunately I can not seem to get the auto-filled info to be displayed when adding the record. It appears the problem is that the dB is not being accessed BEFORE displaying the new_record.htm in order to display the auto filled areas. How do I get the web page to see the auto-filled areas so it can be seen by the user as the record is created. I have used the cdml tag: [FMP-Field artNumber] within a text box and without for testing. Neither pull the data from the dB. Thanks Wayne

I am having difficulty sending email using Outlook Express 5.02. I am using the following formula "mailto:" & STDBNHGVencon::email & "?subject=" & subjectforemail & "?body=" & emailmsg Copy The subject and body text both appear in the Subject field of the email msg. Any ideas? Thanks.

Hi I need to return a date in a text calculation as 11-Mar-00 from an existing field example Name & " " & Date & " " & Cost "John 02-Jun-00 10.00" I'm currently using DD/MM/YYYY with "DateToText(DateFrom)" in the calculation but need it formatted with short month name for export! Can anyone help? Happy New Year T

For some reason, Filemaker Pro 5.0 v3 takes over 2 minutes to initialize when I first run it on my Win95 Pentium PC, 64M RAM. I've uninstalled and reinstalled it and still a problem. Resetting cache doesn't help. I also tried installing it as a test on a good Win 98 running laptop and it initialises fine there. MS Access also starts up just fine on both machines. FM used to be much quicker in the past on this machine. Anyone know what it's doing for so long behind the splash screen and Initializing.. message? Mike

Hey, I was wondering if anyone has run into this problem & if they were able to solve it? When printing a report with a field that is larger than one line & it is set to slide up & reduce the size of the enclosing part, there is a large blank area at the end of a sub-summary when near the bottom of the page, instead of continuing to print. While not the end of the world, I was hoping someone knew of a way to avoid having this blank space appear. Thanx in advance, I hope I'm being clear. [This message has been edited by PinnWal (edited January 02, 2001).]

Hi, I'm an FM newbie and have in mind the solution but no idea how to achieve.... I'll describe what I'm after and if you're of a mind please respond. Opologies if this is all too simple ...... File A : People file / FirstName, Surname, FullName, PersonDodID File B : Time sheet / EntryDate, EntryTime, PersonDocID The issue I have is that there are going to be many many people listed in file A and I would like an elegant method for selecting a person. I could use popup fields, but feel they are only good for 25 or less selections. In my mind I'd like a feature where users could enter the first few letters of the firstname or surname which would then restrict the p…

I am unable to create ODBC DSN entry for a FM database. The FM drivers appear in the list; however, I am unable to create a System DSN or User DSN. I am able to create a File DSN; however, this setup is much slower than User DSN and even slower than System DSN. Has anyone else encountered this problem before? I get the following message, "The Setup routines for FileMaker Pro ODBC driver could not be loaded due to system error code 126." Then the next error displays, "Could not load the setup or translator library." Can anyone help me out? ------------------ Thanks, Kevin Yahoo! Messenger: prof_bunsen

I am new to FMP and I am having problems with relations. I have four DBs. One contains information about user (Name, Address, etc). The second contains information about the vendor (Name address, etc.). The third contains information about sales using info from the other DBs. The fourth contains a list of Cities, States & Zips). I have ID numbers for each record in the City/St/Zip file as well as the User and Vendor files. The city/state/zip in the User file is displaying the City/St/Zip combo using a popup list and the relationship. Every time I change the spelling of the city/state/zip everything works great. Now when I create a record in the sales DB it bri…

Hello all... This would be the final key to my scheduler file I am working on. I have fields named 'Start' and 'Ship'. I need a 3rd field (call it 'Dates') that will do a calc that I cannot figure out.... If I enter 1/1/2001 in 'Start' and 1/5/2001 in 'Ship', I need the 'Dates' field to look like this after the calc: 1/1/2001 1/2/2001 1/3/2001 1/4/2001 1/5/2001 I have written out the script, to figure it out logically, but I'm not sure how to translate it into a FileMaker calc... 'Ship' - 'Start' = 'x', 'Ship' (new line), 'Ship' + 1 ('x' number of times) (new line). Am I think of this correctly...? Basically, I need to have the 'Start' and 'Ship' - and all d…

I don't know what I'm doing wrong and I've tried following the manual but that was hopeless. With sentences like -"The master file for one relationship can be a related file for another, and a related file of one relationship can be a master file for another." I don't know how anyone can get any useful info from the manual? Here's what I did: I created two separate files (TEST 1 and TEST2), each file contained a Field Labeled TEXT and the field type therefore was text. Then I created another FIELD, in both files, labeled NUMBER and this field type was numerical. Now both of the files had different names (TEST 1 & TEST 2)and both live in the same folder on my h…

Okay, I've played with FileMaker 5 and have been impressed. I'd like to publish a few databases on the web but I'm finding the "Instant Web Publishing" limitations unacceptable. I've worked with GoLive 4 and found it a useful tool. With GoLive 5 now available, it provides some useful upgrades. I've got a Beige G3 300Mhz machine with a static IP hooked to the University backbone. I'd like to combine these resources.... Is someone using GoLive5 with FM Pro Unlimited on a Mac? Is it reasonable to combine these tools to create educational college level courseware for survey research classes? Can you recommend some useful resources that will enable efficient integration…

I have a scrolling text field which is physically located on Layout Pg 1. The text field is rather long (about 2 full pages). When I print Layout Pg 1, the scrolling text truncates at the lower limit of the physical page. Anyone know how to get the scrolling text field to print out in its entirety when Layout Pg 1 is printed? Thank you. Respectfully, Eun Mi

I am using fm 5 and have created an invoicing app. I have inv_hdr and inv_items tables related by invoice number. In my customer table, each customer has a discount level of 1-10. My products each have a price for each of these values 1-10. So if a customer who has discount level 3 is created an invoice for product "abc" the invoice lineitem would retrieve the price that is in retail3 from the products table and place it on the invoice line item. This all works well on the second and greater line items of the invoice, but not on the first line item. I have a relatively simple line item layout of "Qty, prodid, length, description, price, extended". I can fill in the…

I want to write a script to allow a field containing HTML code to be sent as an email that will show up as a web page (not the HTML code itself.) Can this be done with the built-in mail function and Eudora?

I use summaries to print checks. Thanks to Bob Weaver, I can now number the checks sequentially. My problem is I need to put a checkmark beside each check number when I reconcile, and of course you can't enter a checkmark when in Preview. I don't want to export to Excel. Anyone have any ideas?

Hey, thanks in advance for any help... I'm developing a replacement for a contact/mailing list.... Currently, there is one list with about 2000 users, and a whole bunch of other specialized ones. The difficulty is that many desired finds are composed of records from multiple lists. Thus, I am combining all lists into one master database. Simple enough... The difficulty is that the original list of 2000 is very important data, and should only be modified by one person, whereas I want people to be able to add/modify other records. Question: What are some ways that I could go about having one main database, but making certain records (say, primary key # < 10000) un…

New to FM, and I'm creating a database (for class) with the need to add a button feature to play (or bring up ) a QT movie. I can't figure out how?

Hello all. I hope someone has an idea for me: We have a Job Info file that contains project Job Number, Start date, Ship date, estimated hours, etc. We also have a Calendar file that, when using portals and relationships, we had it pull the Ship Date for each job and place it on the correct day. (Our calendar is set up as 1 record contains 1 week)... Also in the job file, using a FileMaker Tech Info article, we are able to calculate how many business production days we have (No Saturdays or Sundays) between the Start Date and the Ship Date. Using that number (say 10), we divide that by the estimated hours (say 400) to get hours needed per day to complete the project. …

I have a portal from a media library database. The media library has a field that notes which project each tape in the library belings to. There is also a project database, in which there is a portal that lists all of the tapes from the media library that are for each particular project and is related by the library's project number field and the project detail's current project number. This works fine for tapes that have only one project number in the project field, but for tapes with, for example, "1001, 1002" in the project field, the tape will not be displayed in those project's portals. Is there a way to get them to be listed, possibly by looking for a partial s…

I am new to Filemaker. I have the job of changing an existing file that has a repeating field in it (6 repeating unique payments). Which I have to show calculations for commissions with things like (Should Be Sold Price : / Total Lot Price * $ Value Shipped) for several sales people in a repeating fashion. I currently only seem to get 00.00 on entering new payments! I tried get repeatition but this only seems to work for one. How do you set up repeating calculations....perplexed!

I would like to see if I could create a field that will give me a running count of record used in a cretin field. Example: I have a value list with "boy", "cat", "dog" in it. I would like this NEW field to contain a running total of all the records that are using "boy", totaling with a Number. So if "boy" were used in 6 of my records this field would contain the number 6. Can this be done? Thanks, RET

Problem is this - I have created a cheap "installer" using Aladdin's Stuffit. I create a self-extracting archive and it extracts the files of my runtime solution on the desktop of the windows user. I have it place a shortcut on the desktop so the application can be easily opened. When users start the program using the shortcut, they are notified as each file opens that the files are write-protected and cannot be modified. If they open the files directly by clicking the application icon, the files open and can be modified. -No problems- Any ideas?

I really do need help with my problem. I have created a collection program using 3 files: "CASES", "NAMES" and "PAYMENTS". In CASES I maintain the general information on my clients (the following are self explanatory field names), eg fileno, casename, originalamountowed, dateofclaim, balanceowed. In the PAYMENTS the fields are fileno, casename, transactiontype, dateoftransaction, transactionamount, balanceowed. The CASES file will only have one of each fileno. The PAYMENTS file may have many payments relating to each fileno. My problem is creating a formula that uses the originalamountowed from CASES, and the fields from PAYMENTS to record payments in PAYMENTS so th…

Is it compatible with Windows 2000 professional. Can I go from 3.06 to version 5 as an upgrade or do I have to upgrade to version 4 first. Need help.

I'm creating a database for a group that has ever changing reporting requirements based on the values of a few different fields. I want the default requirements to be set as a new record is created, but then the user should have the option to change those requirements. My current plan is to use a categories and an items database in the following way: 1 -- Include in the Categories database one field for each possible requirement. Each category will have a binary value for each requirement, designating whether the requirement is a default for that category. 2 -- In the item database, various information will be entered, followed by a "Choose Category" value list and a…

I have a service call database. I need to assign a unique number for each call. The first part of the number is the date. The second part of the number is to be the number of calls taken that day up to that point. So, the first call on January 4th 2001 will be #010104-001. The fifth call on that day will be #010104-005. The second call on January 5th 2001 will be #010105-002. Any clues on how to generate that 001, 002, 003 sequence and then restarting the next day automatically. Thanks.

The straight forward (and clean) solution is to put all four price lists in the same file and use the index to select one. Another option is to use four layouts, one with a portal to each of the four files. Enter the price list selection into a field (could be a global) and test the field to select a layout to jump to. -bd [This message has been edited by LiveOak (edited December 22, 2000).]

I would like to know if you can use seperate records that are indexed records? I have 7 indexed records in one form that i would like to seperate in different froms, reports. Can this be done? RET

Hello, I'm evaluating FMP because I'm setting a database shared through an intranet, with a few data and low access requests (a priori). FMP seemmed to be a good solution, but I have some questions that I couldn't find the answer, on this forum, neither on the fmp web pages. - Am I constrained to have one web page per data file or could I built many of them? - If yes, isn't it sometimes easyer to write scripts intead of using the fmp interface? - There are layouts, but what if I want a page holding requests on nearly all of my datas? And what if I want to show informations only if a related field has a correct value? - How are the read and write access handled? …

Any one who will listen, I know every one hates repeating fields here but I was thinking... If I use a main file with a standard field containg "x". And I have a releated file with repeating field containg 2 records with values "x,y" for rec 1 and and "y,x" for rec 2. Both records are accessable via the relationship. Doesn't that make a strong case for repeating fields? G

Does anyone know if there is a way to get FileMaker to interface with Quickmail. I have read that it only works with Claris email programs. I was hoping there might be a third party plugin.

Hi-- I am using a modified version of the solution for Security Access at the FSA site: http://www.filemaker.com/fsamembers/downloads_fsa/files/Security_Article.sit.hqx (basically, limiting certain records so that they can only be viewed by the user who created them or the Admin for the file). This solution works fine, however, I can

I'm trying to import a scheduling database created by a third party into FMP so I can show on the web and have it be interactive. The problem: how to import this data that has been created in this form: Date Bball Wrestling Squash 11/01 H@COR COL@B PR@PE COL@B H@COR D@Y 11/03 D@B COL@PR H@Y I want it to end up in FMP with following fields: Date Sport Matchup How can I do this w/o spending much time preparing my excel database? If it took too long, I'd just retype all by hand, and insist that the schedulers from this point on use my FMP web site to enter. Thanks Bevin

Does anyone know how to activate a script based on a particular popup menu choice? For example, if there are three choices under a popup menu, A, B, and C, choosing A would run script A, choosing B would run script B, and so on. Thank you! Jeffrey

I have a company file and a related contacts file. I am keeping track of the contact phone numbers in a repeating field. I know, I know, don't use repeating fields. But, over in Company I can see all of the contacts for the company in a portal. As I enter or highlight a contact in the portal, how can I show the phone numbers for the contact? I thought if I just put them on the layout they would show up. However, only the phone numbers for the first record in the portal show no matter which contact I am working on in the portal. Thanks.

Is there a script that when user name and password are entered correctly within database "A", it will then open database "B" that corresponds with the individual who has been assigned to that database. Database "A", would be used to authenticate access - It would contain 3 fields username/password/and database Any help would be appreciated!

In FM 5.0, is there still a limitation on text-based relational keys of no more than 20 characters? One of my relationships is creating odd results that could be explained by this limitation. Can anyone confirm this, and possibly provide a workaround? I have some fairly long compound keys that I'd like to use.

Hi I want to setup a timer for a quiz type of program I am developing the timer would count down to a certain number and then would automatically take the user to the next layout how can I make a timer like that???... THANKS

I am trying to create a formula to calculate square footage. I have a field to enter the area and a field to identify the local measure via radio button selections: "sq feet", "sq meters", "sq tsubo". If sq feet is selected = 1 x area; if sq meters = 3.3 x area; if tsubo selected = 35.5 x area. Thanks

Hello, I have a web page that makes a find request to a articles DB using a single text field, the value of this field is used to find the articles in the database. I thought that if I captured this value I could then do a calculation field that could give me the number of occurrences of the search term, this could be done with a PatternCount function, and this way I could sort the found articles by their relevance. How can I do this? I have not found a function to catch the current search word. I thought there was a CurrentParthArgs or something with web companion but I can't seem to find it. If you do a Find at the FileMaker web site it brings results with a "Relevance …

Hi, Just some questions about filemaker. I come from using Access2000. Recently, a friend told me about filemaker and after visiting filemaker website, I am quite impressed by it. However, I like to know its limitations before buying it. This is what I found out. Access uses 1 database file with tables, relationship, VBscript etc in it. FileMaker uses many files as tables. So how does it do the relationship? This the script as good as Visual Basic? When hosting a website in a NT with Access support, I can use ASP to connect to the database since the webhosting also has the driver. Can filemaker database be connected through ASP? What if the hosting company does not hav…

I am trying to delete a container field; however, it is not doing anything. I have already removed the field from the layout and when I try to delete the Container field from the list of defined fields, nothing happens. I don't get a confirmation, warning, can't perform operation, you don't have rights...NOTHING. I am not sure in this DB was created in FM 5.0 on a PC, and I am currently working in FM 5.0 Unlimited on a NT Server. Can anyone help? ------------------ Thanks, Kevin Yahoo! Messenger: prof_bunsen

I got this .fp5 file and when I run it I don't see any duplicate record in the form view or table view, but when I export the data using file-> export I see duplicate records in the text file... Please help !! Thank you, SB

I need to know how to perform an "if" function within a relationship/portal. For example, File A is related to File B using 2 relationships. One relationship is based on a number, the other relationship is based on a profile. It is possible (and probable) that a record in File A will be related to a record in File B using both the number relationship and the profile relationship. I need to run 2 different reports - one based on the number and one based on the profile. The problem is, if the record in File A is related through the number relationship, I don't want it to also appear in the Profile relationship. I can't simply omit the record because this same record m…

I have two db's, one for construction sites, one for all of the separate jobs we do at each site. There is a portal in Sites that shows the jobs. I have script in Jobs that sets a global field with the Site number and then runs an external script in Sites that finishes the job by entering find mode, setting the Site number field to the freshly populated global field back in jobs and then performs the the find. It works. So all is well. But, when I try and go back the other way, it stalls. I have a button in the portal, so when I click the button, it sets a global field in Sites to be the job number of the portal row. Then it runs an external script in jobs that en…

We have a bunch of letters in FM Pro 4.0 that I need to export to Word. I have been trying to find some sort of way, but am finding myself deeper in a confused state. I dont want just fiels, I need the full letters. Thanks for any help you can give! Keri

Hello All: New to Filemaker...Access and VB 6 user. When installing Filemaker Pro 5.0 v 1, I followed the following steps (once the full install was performed): ODBC Data Sources> [Add] Create New Data Source > Filemaker Pro version Not Marked [Finish] I received the following error messages in succession: ODBC Administrator Error: the setup routines for Fielmaker pro odbc driver could not be loaded due to system error 1157. Driver

Is there a way of having a particular portal entry highlighted or coloured so that it stands out?. I have a particular stage entry that occurs during a specific change and I would like to show this in a different colour for easy viewing. cheers in advance

quote: Originally posted by yafreax: okay, maybe i'm not thinking hard enough, or maybe i'm just out of luck. (probably the former), any way, what i need as follows: i have two databases, the master file is Jobs and the related file is Actions. In side each Jobs record is a portal in which users can create new records in the actions file. It relates using a calculated Job Number in the Jobs file. Within the Actions file and within the portal is a field that is a check box that is clicked when the action is completed (this displays a "Yes" in the related record). What we would like to do is have a list view that would list the jobs from the Jobs file, and list…

I have set up an Apache Web server running on a Mac OS X server and I have installed the Filemaker web connector. After following the instructions I have been asked to type the URL http://127.0.0.1/FMPro?config to set up the web connector on the server. When I type this I get the message "Not found. The reported URL/FMPro was not found on this server. Can anyone help.

I

have 800k records. sorted by nsn's (field 1). want to sort by Field 1 & Cage code (field 2). Want to find & delete duplicate records only if field 1 & field 2 match = duplicate. Did counter if statement(if counter=relation::counter "unique","duplicate")this gives me 4 solutions: Unique - U, U-dupe,d-u, & D-D. want to delete d-d. Find doesn't recognize d-d, b/c it is a calculation. Any suggestions?

We're considering upgrading from FMP 4.1 to FMP 5.0. What are the relevant issues we will need to address. Are 4.1 files perfectly compatible with 5.0?

We're considering upgrading from FMP 4.1 to FMP 5.0. What are the relevant issues we will need to address. Are 4.1 files perfectly compatible with 5.0?

I have the following databases: People Jobs Events A job can be related to multiple people and a job can have multiple events. The client wants a report of jobs with events separated by people. It would be formatted something like this: Bill

I have an inventory database to keep track of parts used to assemble systems. I have the following files. Parts file with all of the machined parts along with descriptions and initial inventory and current inventory. Product File with the various products built using parts and the qty of each part required to build it. Update file that allows me to add inventory to any part. Current inventory in part file equals initial inventory plus sum of update quantities. Invoice File where invoice number and Products Sold are entered. I am using a Portal on this file to display the actual parts being used. This displays the data from the product file but when I try to ca…

this is related to my last posted question. . . okay, i used the sort function in the portal to put the completed actions on bottom, but i ran into a problem. On the data entry screen, i also use a portal to put in new actions, and if the portal is sorted by whether the action is complete or not, then the actions are out of order. So if i put something in yesterday that i completed and something in today that i haven't completed, today's shows before yesterdays. i don't want this on the data entry screen, jsutthe reports screen. I tried to duplicate the relationship then sort by date, but it doesn't display all the info correctly. Instead, the first related record …

Is there any way to add functionality to the Table view ie. Buttons. It would be nice to allow my users access to the table view and then allow them back to the form view. I am restricting their access to menus. I need to get them to Table and back without menus. I need buttons.

Has anyone (besides me) encountered problems with the Import Picture command, specifically an error dialog reporting that Claris XTND system did not initialize? I've replaced the XTND components with fresh copies from another machine, but the problem persists (which is a real pain, since one of the things I'm trying to do is build a file containing 750 student photos).

I'm posting this here because I've lucked out elsewhwre and am getting desperate... Developing an FMP 5 solution over NT, I'm scripting DDE commands that work at first, then quit working. I believe this has something to do with the way NT handles application memory. Has anyone else experienced this? If so, do you know of a workaround?

To be honest I'm not familiar with Instant publishing. Do the scroll bars appear in other browsers like Netscape, or different versions? If they do not, then it's an IE rendering "feature" and there's not much you can do about it. If they appear in all browsers, then it's probably meant to be like that. Try selecting a different style or appearance and see if that helps. Otherwise either learn to live with them, or turn your hand to custom web publishing.