Finding & Searching

FMP documents well how to create a search then add to it by getting a new search (ctrl "N") from the request menu - if necessary ticking the "omit" box. I want to do the same thing in a script to include certain values from one field, but exclude values from another - eg everyone from City A who is not Occupation B. I want to use the results of a global field to define the "include" criteria so I cant "pre-setup" the search. Can anyone help me with the script steps ?

Is it possible to use the NOT operator in a text field or emulate this using a script? I am trying to do a multiple find using the following scenario: User Name (txt field) Location (txt field) I want to find all records in ..... (Location), but NOT ..... (User).

I think this is the right forum for this question!? I need to be able to search for all records within 8pm last night and 8pm today which has obvious difficulties to it since it spans over two days. And I want it to automatically via a script to print out at 8pm each evening. Also there is other problems from here on which I've posted on the Script Forum regarding automatically selecting which printer for each report whether its labels, Letter headed form or plain paper. The self acclaimed King of problems on the Forum! How do I do a FIND of all records entered from YESTERDAY 8pm until 8pm today and then get it to SUM this information into a report that states how ma…

i have a timesheet database for employees... I would like the employees to only have access to their own records and also for filemaker to only list their records and sort based on date. There are 9 employees and i have assigned each to a group and have made the appropriate passwords for them... however, i have not been able to figure out how to create a script that will find and sort based on their groupname? It is my impression that the find command performs the last find you did and you cannot set it to perform 9 different searches in one script? for instance...if i have an employee field... i would like to say... groupname is Robert and Employee field is RM the…

Try a literal text find as in " " ". Or maybe you can substitute the characters with "". HTH Old Advance Man

Hi... I have a table where Field1 contains both positive and negative values. I have a need to search for a set of records where Field1's values are outside of a specific range, ex: -3 to +5. As the range doesn't fall evenly on a number line, I cannot use the ABS[] value and just seach for values greater than X. Does anyone know of a way to execute a find (from within a script) to retrieve a set of records where Field1 is less than -3, and greater than +5? Is there a way to combine a NOT operator with the range span operator (...) from within a FIND[] step, from within a script? Thanks in advance, -KJ

Greetings, I am looking for a way to allow users to enter data into a single field / single find request, with each of the search criteria's separated by a symbol. For example User enters 1,4,7 into the RecordID field and return with records 1,4, and 7 as opposed to record 147. Is this possible without the user creating individual find request? Any ideas? TIA, -er

How do I search and display so that duplicate records only show once (FM 4.0)? My searches often produce several records for the same person and sometimes I need to show only one record for each person.

I want to print my records; I want to print out as a Table; I don't need to print out all the fields though, how can I do it so that only certain specific fields print out?

I inherited a database with 1000 records, keeping track of various services a student is recieving, as well as the services being provided by any given teacher. Each student (record) may have up to 10 teachers, listed in any particular order. I need to be able to find Teacher X and run a report on the students she is seeing and the time being contracted for. The database is set up with Teacher1, Teacher2, etc., through Teacher10. Teacher X could be any of the 10, depending on the other services a student is receiving. (The client doesn't have time or money right now for me to modify the setup. i.e., I have to make it work the way it is) So, how do I write a script to l…

I would like to place a set of records from a main database to new database. Is there a way to copy more than one record at a time. Thanks. Opal

i am setting up a database, just a simple one with names addresses etc of companies we deal with. The problem I have is that i want the DB to be sorted in alphabetical order of the companies' names. Sounds straight forward, I have setup a script to sort on opening. The problem is if somebody does a find then does show all, the records return to the order in which they were added to the databse. Is it possible to lock a sort order so that they are always in alphabetical order??? NB. Nobody will need to sort them any other way. thanks

I've seen LiveOak and others suggest that the fastest way to find records in databases with many records is through relationships rather than finds. I'd love to clear up the confusion, and get answers to these questions: 1) How does Filemaker work such that relationships are faster than finds (I thought they both worked from the same index). Knowing this will help me understand the ins and outs of all this. Would be much appreciated! 2) How do I do an AND find with relationships, e.g., I'm looking for all LASTNAME=smith, FIRSTNAME=john, and STATE=NY? As far as I can tell, "go to related" only brings me to a set of records for ONE relationship. Once I do "go to …

I haven't done this type of find before so I'm having some trouble. I want to be able to script a find to do a search by Cust ID#, that way when a customer calls and gives their ID#, I can just hit a button and find all of that customers previous calls by search for his/her ID#. Can anyone explain how to do this?

I need a calculation to arrive at the number of vendors used from a list of sold items.Each item has a vendor number.The find shows vendor 101 may appear 23 times, vendor 203 may appear 15 times. I need to summarize the number of vendors used. The answer I am looking for is:Number of Vendors= 2

I have a couple of databases that all require the same search process, but I'll describe the simplest example here and I'll try to work up from there for the others. Our school has begun listing scholarship applications in FMP 4.0 and we want to be able to search for scholarships which are still available for students to apply. Each record has a "duedate" field, as well as a "currrentdate" field. There's also a "status" field which uses a calculation (If[duedate>currentdate "A", "X"]) where A = an Active scholarship and X = one whose due date has passed. Ideally, a search of the database which is restricted to records with status="A" will only show those scholarships …

I am VERY new at FileMaker (use version 4.0 for windows). I have a database which contains the fields "FirstName" and "SpouseName" and have created two different layouts for printing mailing labels. Layout #1: <<Firstname>> and <<SpouseName>> <<LastName>> <<Address>> <<City>>, <<State>> <<ZipCode>> is designed for printing mailing labels for records which contain data in both the "FirstName" and "SpouseName" fields and contains the word "and" to seperate the two fields on the mailing label. (i.e. Linda and Randal McCurry) Layout #2: <<Firstname>> <<LastN…

I have several reports that calculate the number of hours each employee works. (hrswrked)is the field, which is a calculation of ending time minus starting time. I want to show a total number of hours for all the employees. I thought this was rather simple, I created a field (tothrswrked) that summarized the summary field hrswrked. When I run the report with the field tothrswrked in the grand summary, all I get is a ? mark in the field. I tried expanding the size of the field as I have discovered that filemaker will do this if the number exceeds the field size. However, I have expanded the field size to cover 6 inches across a page, and I still get the ? in the field…

I have a database with >50 fields. All fields should have an entry in them. For auditing purposes, I need to find if any field in any record has been left blank. Is there a way of listing the records (and possibly the fields) in which there is at least one field that has been left blank. Thanks for the help.

Create a summary field , ZipSum, defined as count of ZipCode. Create a subsummary part (sorted by ZipCode). Place ZipCode and ZipSum in the sumsummary part. Go to preview mode, and you should have your list as desired.

Can anyone tell me if it is possible to do a find so that it will locate a particulate word / name in any record and field? ie in excel if you do a find eg. Smith, it will locate Smith in any column and any row. Thanks in advance

We have an FM5.5 file we enter customer orders in. We want to improve its effeciency by being able to enter a number in the quantity ordered field and get the corresponding quantity discount price looked up from the product file. There may be 4 or five price levels based on quantity ordered. I can't figure out how to get the correct price into the customer order file from the product info file.

I suppose this is a pretty simple problem, but I’m a beginner and have some problems with this anyhow. I have a DB (let’s call it avr.fp5) that handles occurred accidents. It contains fields like: Sequence_number: (a unique ID) Date: (when it happens) Class: (What type of accident) Signature: (Who reported) And some other fields… What I want to do is to count all unique ocurrences of the field Class and put it into a repeating field. And I also want the Class name in another repeating field. Example: Sequence_number Class 12341 Technical 12343 Medical 12344 User 12345 Medical 12349 Medical 12351 User 12352 Medical I want the result t…

This is pretty basic, but I am designing a system for booking in our company's work. I have a DATE IN category (type = "date" in Define Field), obviously when the work is booked in by the rep. BUT how do I FIND from a specific date onwards? (I presume that I use the appropriate symbol, but which one is it?)

I have created an order form we fill in while our customer is on the phone with us. We enter the Product ID and auto enter the description. We offer quantity discounts, for example; 1- 12, 13 - 24, 25 - 50, 51 - 100. How can I get the quantity discount price to be automatically entered based on the quantity we enter in the quantity field? Thank you in advance for your help. Gary

I have two files A & B. I have set up a one to one relationship between them. From File A I'm creating a report that includes a summary field on a field from file B. When I do a find and sort based on the "dept" field which resides in file A the summary field that comes from file B does not reflect the find of the set I get from file A. The summary field displays the total of all records in file B. I realize my problem is that I'm dealing with 2 different found sets. I'd like to know if there is a way that I could solve my problem. Unfortunately File B is imported on a weekly basis from another app. and there isn't a way that I could incorporate all the data i…

having done a search(through the web browser), we get a list of results which is fine. Later on into the site I have a "Back to search results" button which needs to take me back to my list of results. How do I do this please using cdml tags? Using a javasript history is no good as the page can be accessed from all different areas of the site so a javascript wouldn't necessarily take you back to the rught place.

My find mode is grayed out , how do I restore the Find Mode...Thanks for the help...I'm new to Filemaker...

Hi, I have a database with +/-700 records and I'm performing a simple search (>0) on a non-indexed field (indexing not possible). At record 646 it's as if my find gets stuck. I can't cancel the find and have to force filemaker to shut down. What could be happening? Thankyou for reading and eventually answering this question.

How can I have a record when flaged to get transfered to another file?

How can I when finishing a record entry to have the cursor fly automatically to a blank record which is called "PARK"?

Greetings to the forum: My problem is the following, I have a database of clients which has a field type dates, it contains the date of the next visit and I want to select those that fulfill a range of dates, add two fields global type dates, date initial FECINI and final date FECFIN, I present a layout requesting this dates and I execute a script, but I cannot make me to take the range correctly FECINI...FECFIN. somebody can help me?, thank you.

hi all, before i dive into this i figure somebody must have done this before. i want to find birthdays for any date within usually a month period. so say everybody that has a birthday in june, but the 6/1/1925...6/30/2001 doenst' work. how can i find just the months for any year? all help appreciated! nati

I am trying to find all open trouble reports against one software version. I have two fields Status = open, work in progress, assigned etc. Status has 6 values. So my first find is to find all TR's that are open. I created a script and it works. The second part is I want to now find the Software version that has open TR's. Every time I try to find in the same script with the open find I get all the status options against the one software version. What I want is all the open staus values against one software version. Seems I can do either or but not both in the same script.

I

I have a commission report that summarizies the total commission due to each sales person on my staff. I have 2 questions related to this report - 1. If the find results in no records found, how can I print out a no commission due report? 2. I'd like to "save" these reports (find results) to have a record of what has been paid and for which projects. What is the best way to save these results? I have considered populating a 2nd set of duplicate fields with the results, but this seems awfully repetitive and not very efficient. Thanks in advance!! Randy

That's clear as mud. In Access I would create a parameter query and input boxes would pop up for the user to enter the parameters into. Don't see how to do that with Filemaker.

I want to apologize in advance for anything that may be painfully obvious to most FM users. My question is this: Is it possible to execute an SQL statement on a FM 5.5 database from within the database. Here is my situation, I have been thrust into the DBA position with out much experience in FM. I am finding creating reports quite difficult. I do have experience in some other RDBMS like mySQL and Access. I think that if I could just execute SQL statements on the FM database I could generate the reports I need and shorten my learning curve. Is this possible?

the admin responded with a link to that last question if you need it. But my original posting was on Nov. 5th - the only one - it says user KLA. It was regarding sorting for less than zero. Thanks [ November 12, 2001: Message edited by: KLA ]

Thanks for the tip about doing the search in the related file. It does work this way. But my problem is that i need to be able to search this info in the Master File - it's where all my "unrelated" job info is for the client and where my invoice layout is. Isn't there a way to search for the info in the Master file? It did use to work and the FM book says i should be able to do this. What's the logic behind this?

I'm exporting data from filemaker into MYOB but where an employee has entered a return/linefeed in one of the fields MYOB rejects that field. Is there a way to search for a return such as "/p" or something similar?

Hello all, as the subject said, I thought it would be simple but... I have a field that I imported from excel. The values of these are, for some reason in quotes. They need to be removed. I would like to ultimatly do a find, to get all the records that have a double quote. Then do a replace to remove the double quotes. First I tried puting just a double quote, then putting the double quote in double quotes, then putting the double quote in single quotes, then putting a single quote in double quotes ( I was getting desperate at this point) So I must ask the experts! tia Jerry

I have a file with many many records, all of which have at least one duplicate. I want to be able to find all the unique records and then delete the duplicates. Is there a quick and dirty way to do this? Susan

The simplest way is to add a flag field that you clear before the first find. Then, after the first find, set the flag field to 1 for all records in the found set. When you do the next find, include flag=1 as one of the search criteria. If you increment the flag field to 2 in this next found set and then do another search with flag = 2 as one of the criteria, and so on, you will not only have a progressively narrowing search, but you can always back up to a previous level by setting the search criteria flag>=1, for example.

I'm not very good with the restore options with find/sort but I have a question that I think might be able to be solved with it and need help creating the solution. I run one search, which could be a simple find with one request and only one field being used, or it could be very complicated with multiple requests and multiple fields being used. I then either modify that search buy adding information into a new field, or I use a completly new find. After the second find, a summary is shown for the user and I now want the user to have the option to go back to the records that they were viewing after the first find. Any help is appreciated.

I want to search a value list so that when the user enters the first alphabet of the word it shows all the items from the list with the first alphabet and then when he enters the second it searches for combination of first and secod alphabet and so on.Is it possible to be done using file maker. Thank You

I have a Tests file with 5000+ records. Many of the records have the same student_id (each record is an instance in which a student takes one of 16 different tests during a school year. Students take the same tests each year--if they stay in the same school they will have 96 records) I want to be able to find 1 occurance of each student. It doesn't matter which test/record is found. I just need to be able to tell how many different students are entered, and see their names and grad year. Thanks. Susan

I have a database that monitors people as they enter and leave a building. Each record contains a field for name, time, and one for whether they entered or exited. How do I search this database to find out when two people are in the building at the same time?

Hey Forum Friends, I have about five FM5 files that contain at least 85 fields and about 303,540 records. (this is the US census data) I have a relation between all files, so you can imagine the size of this combined data...(about 500 mb). When I do some reletively simple finds, it will take 15 to 20 minutes to search. Can I do something about this? What about indexing? Also, is there a TEMP file that FMPro5 creates when doing this search? I have to make sure my computer has enough space to perform the action. HELP................... TestIcons.zip

I would like to be able to display on a layout the find criteria typed into 1 find field whether it was for multiple requests or not. Is there a simple way to access this information in FM or do I have to write a script to go through each request and get the info in that field? If the latter, where can I put the info to display it? Thanks.

take a field, say field A. Use field A to do a Find & omit action This Find action produces a found set. Problem If you do another find (using field A), it is NOT confined to the found set produced by the first find. Instead, the second find action is applied to the whole set of records. I've saved various finds (all using the same field) as scripts and want to run them sequentially in another script. I'm getting nowhere at the moment. any ideas t

I need have MS Acces like 'group by' command to use with Filemaker. Valuelist is not for me, becouse I need to group by after find. ex. records are: 2 13 23 33 3 33 1 find finds with '3'. Result should be like this: 13 23 33 3 But with filemaker it's: 13 23 33 3 33 I don't wan't dublicates to on my result.... Is it possible to Group By with Filemaker? ODD_Clone.fp7.zip

I'm trying to allow users to search records, using two parameters, to produce customized reports. The two search parameters are presented in their own layout through checkboxes (using two predefined value lists). Once the user has chosen one or many options within each parameter, I'm then trying to write the script that matches up the checked options to produce the correct find requests. Example: Search 1 (options=1,2,3,4); user checks 2 & 4 Search 2 (options=A,B,C); user checks A & B I've successfully scripted finds for each parameter (using a loop, inserting calculated result into the field to be searched), but have not managed to figure out how to combin…

hi i want to do two finds in a sequence so the second find is on the found set created by the first find. I also want to use the same field in the first and second find. Then I want to save this different finds as scripts. Whatever I do the second find acts on the whole collection of records and not just the found set created by the first find. Where am i going wrong? tom. FMForumsList.fp7.zip

I need to search 2 sources for a single found set: source one is a field called : initialappttime, the second source is a field in a related database called followupapptime. I need the search result of both of these sources to appear in one place, layout: dailyschedule, in a columnar report. I am making speghetti of my script. Thank you for your assistance.

Hi everyone, I have a database that has a record creation date and time. I want to search for records that were created AFTER 3:00 pm yesterday and later. Question 1- Is there a better field that combines date and time?? Question 2- Should I create a field that combines (somehow) the date and time? Question 3- How do I search for yesterday? (//-1 or Today-1 don't work in a FIND) Thanks in advance- This forum is soooo helpful. Larry

Help a newbie out please. I am using FM4 on a PC. Is there a screen where I can display a list of records from which I can select individual records by ticking them off, or selecting all and then de-selecting individual records? Thanks for your help. Richie MyDream.zip

I have a problem: I want to be able to display those records that I have entered during the current session. In other words, I would like to filter the records down to those that I input from the time I opened FM Pro that day. What I'm trying to do is select this group so that I can print letters for them at a later time, without printing each individual letter at the time I enter the record. Right now I am using a button that omits the record after I input it, then going to the layout I want and hitting another button that shows omitted records. The drawback to this is that once I omit the record, I cannot see it until I have it show omitted records, so this is not a…

I'm in need of creating a layout which would contain summaries for each combination of values in several fields. i.e. field1 could be A, B, or C. field2 could be P, Q, or R. Field3 can be X, Y, and Z. I'd like to create a report where for each value in Field1, it displays a chart of field2 values against field3 values... Maybe I'm making it too confusing... The nuts and bolts of it is that I want to create a formula which would do the following: foreach (value in field1) count all records for which field2 == [P] AND field3 == [Y] (P + Y being examples) I can currently do this by making subsummaries of subsummaries, etc., but the report comes out to be…

I realize that deleting duplicates is probably very simple, but I have absolutely no idea how to do it and I have a million duplicates. Could you please help me? I work with IMac Filemaker 5.5 on an IMac. There are about 4,000 names. Thank you SO much!!! Yours, Kari

Is there a way to do a find by comparing 2 fields without creating a 3rd field(that would contain the result of the comparison)? for example, set field("field 1", ">= field 2") FM is not accepting this: it is not taking the value of field 2 but the actual field name...

I recive wrong search result when searching textfield as described below. Register contains following records in standard textfield: MSG 85/731 MAXIMO M MSG 85/731 MAXIMO M TRUCK MSG 85/731 MAXIMO L MSG 85/731 MAXIMO K MSG 85/731 MAXIMO K TRUCK MSG 85/731 MAXIMO J MSG 85/731 MAXIMO L TRUCK MSG 85/731 MAXIMO J TRUCK When seraching for MSG 85/731 MAXIMO M the result shows all 8 records !! When searching for MSG 85/731 MAXIMO L or MSG 85/731 MAXIMO J or MSG 85/731 MAXIMO K, I get the correct result (2 found records). When searching for MSG 85/731 MAXIMO TRUCK I get 4 found records. (All that contains truck). This is made i a Filemaker 4.1sv1 (swedish). …

Hello, this is my first visit to this forum; interesting so far. I'm trying to figure out if there is a way to perform keyword searches of documents linked in container fields. For example, if I've got some scientific reports stored and linked as .pdf or word files to my filemaker "document inventory" database, can I design a way for users to be able to search the linked files? When using the standard filemaker "find" mode, one can't search container fields as far as I can tell. Has anyone come up with any kind of solution that would address this? Thanks in advance.

I have a solution which is tracking special ed services recieved by each student and given by each teacher and school district. There are 14 disability areas and 14 different school districts. It's an inherited database and isn't set up great, but I've gotten it to work pretty well, thanks to some help from this list. Now the next problem... I need to create a grid-like report which lists the districts down the left and the disability areas across the top. In each "cell", I need the total number of students served in that district for that disability. I then need to divide that by the total population of the district to get the percentage. I can do the percentage part. …

Hi I have a report made by my login-logout control program... Sometimes, an employee log-in and log-out several times a day... then when a see the report, this employee has several records. I need to filter theses records in the way that I see the first log-in and the last log-out of each employee, with the same date. How can I do that : tks !

ok, i am pretty sure everyone has tried to do this at some point or another. Well i created a script that will do it, and it works great. Only problem is, if you do it with a large number of records (and it would be pretty pointless to do if you didn't have a large number of records) it eats up 90% of the CPU's processing power, and also takes a couple minutes to run. So it is really going to slow down my database when someone runs the script. And if more than one person runs the script, well i dont even want to think about that scenario. well anyway here's my script. code: Set Field [ gContactIDNums, Contacts for related activities::gContact ID Number ] …

Can I do it? I have birthdates entered in a date field 00/00/00.Is there a way I can find all the students born in a certain month? I haven't been able to do it. Thanks Ann In using FMP 3.0

Working again in my inherited database (too late to change the structure)... I have fields for 10 teachers (Teacher1...Teacher10) (Actually, the teachers are stored in a related file). For each record (student), Teacher X may be in any of the 10 teacher fields, or she may not be on that record at all. Each teacher keeps track of how many minutes she spends with each student. I have a report that gives me all of the students for a given teacher, the time spent on that student, and the total time spent by that teacher. Now I need a report that lists all the teachers and their total time spent, regardless of the student. How do I run through my entire database, pull out…

I would try a portal filter plugin. oAzium Portal Filter lets you add a "Filter" field to your layout and have your portal update on the fly to show rows that match that filter. It's like searching the portal instantly!

Hi people. I have this problem where you can select a product from a drop down list box. I have a Primary Key of a number for uniqueness of each product. Instead of having to put in the primary key and then by pressing tab the related records for that product appears, I want the drop down list to be able, on when the user selects a product, to fill in related records including the primary key, detailed description etc. This is probably possible (I hope). Hopefully someone's got an easy answer out there. There shouldn't be many problems since you are selecting a item which would be "unique". Thanxs Steve Griff [ August 13, 2001: Message edited by: Steve Griff ]

To find related records in a child file, I've been using the technique of putting multiple parent keys in a global field which has a relationship to the child, and then using GoToRelatedRecords. Works great but...how can I then further search the children? For example, by this method I can find all children of parents whose Active flag = Y but then what if I further want to only see those children whose phone = home? If I do a find of the children, I end up with all children whose phone = home, not just those children of active parents. This must be a common problem and I'm sure there's a technique. I just don't know it. Tanks.

Hi all together, I'm working in the field of biology/bioinformatics. I have generated a database of proteins. The most important field holds the sequence of the proteins which consist basically of streches of characters such as GGLKKLGKKLEGVGKRVFKASEKALPVAVGIKALG. Those sequences can be as long as 2000 characters. The task is to search in this field with another protein sequence for similarities and sort the result from highly similar (=identical) down to less similar. Up to now I have done this by incorparating the dos/mac versions of the blast program by the NCBI (http://www.ncbi.nlm.nih.gov/BLAST/blast_overview.html) which are called by send message commands etc. Fo…

When user selects "Cancel" during a find, how can user be directed to a different layout than the one used for the find? I tried the following, but get bumped back to Layout 1 when Cancel button is hit: Go to Layout [Layout 1] Set Error Capture [On] Enter Find Mode [Pause] Perform Find[] If ["Status(CurrentError)=1"] Go to Layout [Layout 2] Else ......... carry on with find Endif

Hi! It is quite simple: I created a layout used to search locations (cities) and/or dates. I created my own button 'Find' because in Find Mode I am not able to enter dates (...?). Anyway, when I press Find, it leads to a nice report, and everything is correct... except for the date. When I input my search parameters, I simply write down the date I want the report to begin with (this field is called 'DummyDate' and is used only for finds) and when I click Find, it places it in another field ('BeginningDate', which is used in my report) and performs the find. I have inserted stops in my script, and everything seems to work. It goes to my report... but when I come back to m…

I need a solution (script?) that would allow me to search a text field containing one long string for the presence of a sequence. I've read that Filemaker will only search the first 20 characters in a word, and 60 characters total. Can one make a script that would search the first left 20, then positions 10 - 30, then 20 -40, etc. Or is this not possible? [email protected]

Hi. I am using FMP 4 on the web. I am trying to pass both the name of the field to search on and the content of same field. I do a select name=field-name value=desired-content. It does not seem to work. I tried with the [FMP-field:field-name] with no more success. Is there a way to pass both arguments to the search function of FMP in a <select> the way I am trying. Any assistance would be appreciated. Bye.

I have a field of "Active Jobs" that's coming from another file through a relationship. When a user goes into the "Time" file to add time to a job he clicks on the "Job Number" field and gets a list of the active jobs. Cool! This works fine. But when you go into find mode and click on the same field it does not give you the list. Any ideas?

Hi! Here's the description: I have a library database, and I need to perform search on book titles. The problem is that some books contain articles inside themselves (implemented with related records). When a search is performed, I need to search for a "title" either in main book info, or inside articles which belong to that book. Currently, it is implemented so that user can either enter search string into "main title" field, or "related title" field in the search form. What I'm trying to do is to unify this search, so that in search form I have a single "title" field and the script would find books which either have corresponding "main" titles or "article" titles.…

I want to find "North West" in a checkbox field. That field also contains the checkboxes: North East, South East, South West. When I check North West in Find Mode, FMP pulls up all records North West entries and all with South West entries. To avoid this in a standard field, I would put quotations around my find request. Since, however, I am using checkboxes, I can't do this. Does anyone know of anyway to do this find properly using the checkboxes and avoiding the option of omitting the South West entries?

I have a huge data base, and I am trying to pull up the list of all the "names". I pull up the report and sort it by the "name" so that the duplicates are in groups. Now what I need is a list of the "names" with out the duplicates, so I know how many different names I have. I tried using the omit multiple but that one you have to do it manually one at a time. And it will take way too long. In Excel, it was easy, all you had to do in excel was select the entire and click advanced sort and it would automatically omit all the multiple. There has to be an automated way to do this...but i can not figure it out. Maybe i should post this in script board since it might be…

I have a table database (FM 5) in which I am recording a series of anatomical characteristics of different teeth (I am a dentist /researcher, sorry for that). There are approx. 5000 records (total group). Some fields (non-repeating fields) are pop-up lists with specific categories. What I am trying to do is after a specific tooth (e.g. front teeth) was found is to find out how many teeth in this sub-group (count I supose) are clasified as category A, B, C etc. (from a given field) and the percentage of this category in this specific sub-group. I hope I could make myself clear enough, because I really need help. Ben

Hey I just discovered something cool... this is version 5.0v3 but it may also work in v4 too (I expect it will but not tried it yet). I have a scripted search -- users clicks "search" button, script changes to search layout and into find mode then pauses to allow entry of criteria, when script resumes it performs find and changes to browse layout. I've just discovered that while in Find mode I can use IF statements to look at field entries in the find request, and perform text manuiplations them on-the-fly using SET FIELD statements. Heh Heh. This is way cool. I was having trouble with a find in a portal to a related field, specifically trying to find an *empty* field…

I want to find and replace some double quotation marks in a text field. I can't use the substitute function to get rid of them because it gives an error, it won't find the " character. Substitute(myfield,""", "") Is there a way?

Howdy, I have a Contacts file with a related Events file. I want to find the contacts that have no related records, i.e. the folks who have been invited to nothing. Poor fellows. Need to find them. Thanks! Kay.

I have a database of 25,000 songs that I have on CD. I don't know how to search for a range of artists say between the Beatles & the Blues Brothers. Or Titles say between ABC & Call Me. Can you help me. I'm pretty new at this.

I have two fields labeled start date and end date in a paid time off database for my company. I need to be able to search for any request that encompasses a specific date such as >StartDate and <EndDate, but when I attempt to enter the < or > symbols into the field I get an error because they're not dates is there anyway to enter these into the date fields in find mode in a calculation. Thanks

Hi..... I try to make a search in my master DB, when I change in my Record with the "Next record arrow" find a record in the related DB just to show me 3 Fields in my master DB, these fields show me a calculation, for example: If I have in my master DB in the field OT a record with 1 (this changes), so find all the records with 1 in my Related DB. Thanks for your help Jorge

Had a large database with roughly 6000+ records. For some reason the company split the db. The first field we do a lookup is Employee #. For instance, we enter a number in this field and 70% of the time it brings up the correct record. Sometimes it brings up the entered emplyee # with incorrect first name but the right last name. The only prob is the last name is inserted in the first name field and a different first name is entered in the last name field. Its like the records are getting cross-linked when it searches for them. This is not a relational db either. Just one long list of fields. Is there some way to defrag the records (other than sorting)?? Any ideas Thanx…

I have a large invoice database with a calculation field that calculates the total invoice amount less the total payment amount leaving me with the total outstanding. This field cannot be indexed resulting in the find being very slow. Are there any tricks that will enable me to speed up this search? Is there a way to automate the population of an indexed field based on whether an amount is owing in another field or not?

If a Find is performed and no records match, you get that Cancel, Continue or Modify Find message. If you chose Cancel or Continue, ALL RECORDS are shown and the find cancelled. Is there a way to get around the choices of Cancel or Continue, or to just to show a message saying "No Records Match, sorry!" and then go back to the records in the order they were in BEFORE the find was initiated? I know it has to do with turning the Set Error Capture on, and when the Status(CurrentCountFound)=0, setting up a message to show but I can't seem to get it to work properly. Is there some secret I need to know? Like setting the storage to Do not storeto get a field to hold the nmbe…

2 date problems I'd welcome some help with. I'm constructing a military history database for a friend. One of the files contains 2 date fields ('start date' and 'end date')in which you can record, for instance, the length of time a Commander was in a specific job. I'm sure there must be a far neater way of doing this as I now realise that I cannot find dates or periods of time that fall between those two dates. Eg: Job starts 5/5/1915, Job ends 5/5/1917. How can I use the data in these fields to indicate that the job was ONGOING in 1916? Secondly: it's not always possible to log complete dates. Eg: we may know that something happened in June 1918, but not the exact date.…

I have a table in another database that I need to access. I can access it however i can't access certain rows. I need to somehow do an equality check to then get a certain row in a table. How do I go about doing this?

OK....I am trying to access a two dimensional table that I created in a second FM program that will go look at the conditions and come back with the appropriate field, but I am having a lot of trouble with it going out and getting the specific field. It might be the calculations of it, I am really struggling to get this. For Example (If Total_MM = Fat_bicep and (age <=16 and >=29)), get that field. This is on a PC too. Any help or insight on this that would point me in the right direction would be greatly appreciated. This is a duplicate post (not allowed). Please answer this question in the "Relationships" forum. I'm closing this thread. -bd [ July 08, 2001: Mess…

In my database I want to search all records for the first letter in the first word of one field that contains company names, because right now if I serch for all company names that start with "A" I get all company names that have an "A" in their second or third word but not the first word of the comapny name. Is there a way of doing this? [ June 22, 2001: Message edited by: fbcenter53 ]

how do I find all records in my database that start with a certain letter?

I need help deleting a record in FM4. I have found the recoded but when I go to delete it nothing happens, no prompt or anything. Why is this happening? I have never had this problem before... normally it's an easy thing to do. Any help would be appreciated.

This is probably a 'stupid beginners' question, but here goes... I have a database with a text Description field that is repeated 6 times. Each description line represents a seperate item of data in that record. When I perform a search on this field, using the preview mode of a columar list/report, I get all the correct records but only the top line of the repeated field. e.g. If the data I want to find is in line 3, I want FM to return that line and not all/any of the others. Is this possible, as I really don't want to have just one data line per record.

Once a query is performed, and you are weeding thru the results and omit a record that you indeed want to keep, is there a way to undo that omit???

I have created a a layout where the user enters a begin date, end date and a gfield = ... . When I put these three fields together it is no longer a date. It becomes text.---> gBegin_Date...gEnd_Date <--- This is my date range for the search All three are global fields. I need to copy these fields into the report layout while in Find Mode. I also need to copy the user name. I can only copy one at a time so copying will not work. I cannot do a set field b/c the gBegin_Date and gEnd_Date are text. I also have another global field that is set equal to ... . ........Nevermind. AS I was typing I figured it out. Thanks anyway.

Is there a way to save query results? Ex - Perform a query "A" where some results are desired. Perform query "B" but then want to view the results from query "A" again. Is there a way to do this without re-inputting parameters of an entire query?