Finding & Searching

I have been given a database of several thousand records. The records consist of only one field which holds a UK town name. There are a considerable number of names, probably also serveral thousand, which are shown by a brief check of the database. These duplicates have been produced by error or because there are towns with the same name anyway. I need to identify and delete any duplicates which exist. Have tried Find with ! in the search field but this identifies all duplicates including, as it were the 'original' entry. What I need to do is to leave one record of any particular name but identify and delete any other records which have the same name. …

Please refer to the sample file at http://www.duke.edu/~jiehuang/Distinct_test.fp7 In a patient_visit table, I had two counts, one to count the total number of visits, the other to count the total number of patients. For the two reports, you will find that one counts correctly while the other doesn't. I have been using this counting for many of my real databases. And the same problem, some counts correctly while others don't. Please Help!! Jie

Hi you all.... First my question, then the story behind it: How can i find modified records based upon timestamp? Find: > 6/15/2005 1:33:57 PM does not work. This is what i did (all to bypass the purchase of FM Server Advanced for a ODBC connection): I have a "mother" DB. I extract data from that into a "child" and distribute the child to 3 workstations(Macs) where they become a local ODBC source. This child source reveived a import timestamp. After that the child-odbc sources get update through ODBC from within Indesign. Next step is to bring the data back from the child to the mother. Therefore i need to indentify which records got modified: all after the…

Hello folks, I'm happy to have now largely set up my new (first) database in FM. Now that the data is in there I am trying to set up some reports. Often we need to return only results in the past month, quarter or other calculated date ranges. How do I set up a search like that without manually choosing the dates? For that matter, does anyone have an elegant solution to choose from a list of generic date blocks (ageing?)when loading a report? Thanks, Evan

Ok, our research lab had a database with a total of 217 records. Normally we can scroll through them all in sequence, and the ID# match up to the Record#. All is fine for 193 records. After record 193, the ID# jumps to 210 with the record # being 194. Now there are in fact records with ID# 194-209 - they just aren't showing up when we scroll through our database. We can however search for them specifically by typing in the ID#. What is even more unusual is that if I close the form and reopen it (not closing/opening the database, just the form) it will sometime "find" the missing records, and all is in order again. All 217 files are in order and accounted for. I …

Hi there... How can i search a time-field WITHOUT the seconds. Even when i format hhmm i end up with seconds when the filed is activated/clicked. Any tip is appreciated

I have an image of the US. When the user clicks on an area, I'd like a hidden search to be performed. Any ideas on how best to accomplish this?? Thanks You!

HELP! Solving a problem for a co-worker. Been using FM for 5 years, but am apparently still a newbie 'cause I don't have a clue! (Never written a script, but I at least know what one is.) Joining the forum has taught me how small a percentage of FM I know and use. I have a single table with lots of data on dorm residents. Each resident has one record. Request: One of the layouts is a letter to the students on which I need to have FM display the resident's list of roommates with contact info. Progress: I created a calculation (text) field called Roommate Info which lists the pertinent info (name, phone, etc.) from other fields in the table. Next: Now I need…

I'm new to Filemaker, and I am trying to print a list of records. When I perform a find, my results are shown in table view. This is how I want them to print, but I can never get more than one record to print. I must be missing a step here. Any help would be appreciated. Jon

Forgive me if this is a stupid question, but I'm trying to figure out how to make Filemaker alert the user when they attempt to create a record that already exists. It's a db for a casting agency and they'll need to enter 10,000+ names, detailed info and scans of headshots and resumes, I'd love to be able to warn them that they are about to waist the next 10 minutes of their life before getting too deep into that next new record. I'm a newbie, but I have enough sense to attribute unique serial ID numbers to every new record, so I guess the best way to warn the user is for FM to sense when a duplicate FullName (a calculated field, NameFirst & MiddleInitial & Nam…

Dear All, in my database I have different clients with different revenues. I want to create a statistic layout that shows me how much revenue each client makes. So I perform a find (runs through a script which is triggered when I click on the Statistic button) for all client A records and in a summary field on my statistic layout appears the exact revenue for client A. How can I now manage to perform the next find for client B without having the revenue from client A disappear?? Thanks in advance, Andy

Please feel free to tell me if I'm crazy to think that this can actually be done! My office uses a fax broadcasting system to distribute posters of missing children for law enforcement. At the end of every Fax Broadcast, we receive a report via email with all of the fax numbers that were either disconnected or a voice answer was detected. These fax numbers along with the entire corresponding record need to be deleted from the distribution database so that they are not attemped again. The problem is that these lists can get very large sometimes in the hundreds. I was wondering if there was a way to search throughout the database using the items on the list. I guess it…

Greetings, I have an ENORMOUS database (16 million records, only two related tables). "AcctNbr" ties the two together. The problem is that there are records for the same accountnumbers in the Accounts table, one was created for every year the account was open, "AcctNbr"=1, "BillYr"=1998, "AcctNbr"=1, "BillYr"=1999, "AcctNbr"=1, "BillYr"=2000, "AcctNbr"=1, "BillYr"=2001 What I need to do is this: 1) Show records with duplicate "AcctNbr" and then show only the "top 1" ("top 1" refers to the 'most recent year'. In the above example it would only show me the record for "AcctNbr"=1, "BillYr"=2001--everything else should be hidden/deleted. 2) [i can handle thi…

I am havong a bit of difficulty in figureing out how to make FM5 sort a field with long entries. below are tow of the vaues that are in the field. World War, 1939-1945--Campaigns--France World War, 1939-1945--Campaigns--Africa, North when I sort on these (in a sub-summary) the are both put into a group as "World War, 1939-1945--Campaigns" and the last part is dropped. This is really confusing me as some other entries sort just fine with longer text values than these. Any Help would be greatly appreciated. Roman

Is there any way to perform a find in script mode where the finder omits results with * in one field OR in another field? Any help is greatly appreciated, thanks.

Sorry if this is a repeat topic. I looked around and couldn't see it anywhere else. Here's my question: Quite often, I hear other developers saying how they've set up various relationships because they really wanted to "avoid performing a find". Why is that? Unless a relationship is already set up for structure purposes, it is so much easier to set up a find in a script, rather than add to an already overpopulated relationship graph. Is there something performance-related, or is it an attempt to create queries like you might find in other databases?

I have a bunch of records that I want to trim down by seeing if they are all using current products. Basically, in the record is a text/numerical field which indicates which product the customer (record) is using, in this form: XXX-####-XX, and I want to have each record matched to a list of current products, and if the product is current, I want to keep it, and if the product is not in the current list, I want to omit it. Is there any way to do this in FMP?

I have two tables containing one field each one. Now, I want to create another window (table) that contains a single field where I would write in the word I want to search and when I click the search button it will return, in two portals, the matched records. (each portal for each table). How can I do this?

I have two tables conference and invites. Related like this, conference.pk_confID----<invites.fk_confID I have a layout that displays all the conference data for each conference record. I have a button on it that I would like to set to switch to a layout that displays all the invite records for which ever conference record the previous layout was on. essentially what I am asking is how do you pass the current confID thru the button to the invites layout to constrain the found set to only show invites for that conference. This should be simple but I can not figure it out. thankya all

I'm kind of a rookie. I have a FM table with the following fields. Street - Address Range To - Address Range From - School. I want people to be able to enter the street name and number and locate the school that address should attend. I don't know how to construct the find to search between values in the 2 Address range fields. Thanks. Dack

hi im trying to make a report with info from 2 tables those tables have related fields, what im trying to do is to make a inner join, i mean have a report with info from those two tables in another hand i want to make a report asking for a values with in a list a then look in those tables to show the result, is that posible? i dont know how to add scripts, do i have to added to a button or how i define it? any one can help me, im new in this fm thanks

Does anyone know how to turn a button off in find mode? I want to be able to click on a portal field and go to a related record, but I'd like to also be able to search on the portal field. Thanks.

Hello, Problaby a newbie question, but I a would like to save requests for future use, so that the requests can be brought up and performed again. I would like to be able to store the request in a table with other request, so the user can search through that table, chose for a request and do a perform/find. How do I do that?

I'd like to offer my users a search page, lookin kinda like this: I want the search to look in all fields in a large block of tables that are in one relationship tree. "Any of" is AND'ed with "All of" in the search, so if the user ran this search: The script should find records with that name and either phrase, regardless of what fields are involved. Assuming I can find an easy way to parse the quotes (no escape characters need be allowed, so there's no worry about quoted text in phrases), I could do this by running a search on each field of each table per every permutation of the "All of" phrases, but that's killer-slow. I need suggestions: I'm not r…

I dont know why, i dont know how but none of my records are deleting, everytime i try delete a record it takes me back to the first. any suggestions?

I need to search a Filemaker database I have for 400 email addresses. I have the addresses in excel, but don't know any easy way to make 400 find requests in Filemaker. Any hep would be appreciated.

Is it possible to do a find only within found records? Details: I do a search and I have 20 results (20 records). I'd like to do another search ONLY within these 20. When I try to do this, the second search also includes records that match my request even if they are not in the 20 records found in the first search. Can someone help me?

I am trying to do a find/replace i need to find 1 quotation and replace it with a single quote (apostrophe). This is for exporting purposes. so find " and replace it with ' I have tried doing a find for " " " and even " " " without spaces. Nothing seems to work. Does anyone have any idea of how to do this.

how do you save the results of a query

Ok, I'm new to FMP so it may be simple, but I still need help. I'm trying to use a layout (in browse mode) to find records in related tables. I want to use two or three fields to make research in another table. If I use only one field, I can do a copy-paste, but it doesn't work (or I simply don't know how) with more than one field. Can someone help me? Thanks

Hi I want to import data from a text file (in this case it will be a telephone number). I then want to perform a find so that if there is a matching customer record containing the telephone number then the record will be displayed. Could you please help!

I'm building a solution that uses a somewhat fancy (for me) set of calculated container fields as a button-placing / altering system for basic navigation. I.e., at the top of each layout I have an identical set of calculated container fields that conditionally display button icons according to what layout is being viewed and by whom. The actual button definitions are of course attached "over" the container fields. Everything works like a charm, EXCEPT -- When I want a user to be able to go into Find mode, all of the calculated container fields (i.e. the entire set of navigation buttons) disappears, because FMP thinks the container fields are subject to being sea…

Hi, I have a portal in a form on my Customers table linked to an Order Items table, which shows all the products each customer has ordered. Each Order Item record contains the product name, units, sale price, currency. It's fine searching for customers who have bought a specific product, but I wish to search for customers who have ordered (both of) 2 specific products. Is there an operator I can use in the search term to do this? or is there a way of including repetitions of non-repeating fields within a portal in find mode? or another solution? Thanks in advance for any help

I am trying to use the currently logged on username to do a find. I have added the currently logged on username to a field, then created a script to look for matching name in another field, and display records. When I execute, the user name disappears from the field and I get the "no matching Records" message. Is there another way I can do this to make it work?

How do I show all the records where one field content is "x" or "y". Thanks!

Hi, I have a simple task for a script but cannot get it to work.. The script should loop through the found set of a table, perform a find on another table depending on the current record in the first found set. Basically the script logic is (after initial find) loop set global field to current value of a field in the found set perform a find on another table using that global field as criteria should the found set go to the next record in the first found set end loop Should this be as easy as I think? Thanks in advance.

Hey, It seems my get (FoundCount) isn't acting like it should. I find some of the records in my DB. I have on field selected as calculation: Get (FoundCount) but for some reason, regardless of the size of the found set, it always returns the total number of records in the DB, not the found amount. Any ideas? The picture has the field that is just the single Get (FoundCount) calculation highlighted (big red square) yet you can see that the found count is 12. What am I doing wrong?

I am working on a putting together a list of certain records. To add these records to the list, I have assigned the list a name using a Temporary Global field (Consignment Name) and then Set my Consignment Field to have this particular text (the Consignment Name) added to it. (It is possible that a record will have multiple Consignments, so I add each new Consignment Name to the Consigment Field as a calculation). Now, in my script, where the Temporary Global Field is still the same Consignment Name - I want to script a Find where the Consignment Field has this Temporary GLobal Field. Does anyone know how to do this? It is not a Find I will have particular cr…

I need to find 4 different text strings in a text field called comments. Then I need the four text strings to populate 4 different fields in the same record. I don

I am creating a search page layout where the user can enter the search criteria into one field, but it pulls up records that have that data in one of any four different fields. For example, records contain several fields - Name1, Name2, Name3, Name4. The user enters "Joe" I need the Find to pull up any records contain the name "Joe" in either Name1, Name2, Name3, or Name4. I have tried using a Perform Find() script step. The user enters the search criteria into a global field called "Search". Then I tried editing the Find Request to look for records whose Name1 value contains the value of "Search" I kept coming up with zero records found. Am I goi…

I've been unable to find a suitable workaround to the following issue, and was hoping someone here might be able to help: I need to be able to perform finds in my Invoice file for fields such as "Amount Paid" and "Balance Due." The problem I'm encountering is that these fields are based on related records which I access through a portal. Each related record contains order and payment data for one line item on my Invoice. FileMaker 7 does not seem to support Find requests that require accessing information from related records. The only solution I've seen for this issue is to create a separate set of fields that can contain copied data from the original fields. …

I have a small database I use to keep track of software serial numbers for my workstations. What I am trying to do is find a nice way to handle software licenses. I have 2 tables Users and Workstations. The software serial numbers are on the user table. Idealy, I want to be able to view a layout for users, see user name with their list of serial numbers and aside the serial number a count of total occurances. Joe Schmo photoshop xxxxxxxx-xxx 1 illustrator xxxxxx-xxx 4 quark xxxxxxxx 1 where the ps and quark serial numbers are unique, but the illustrator is used by 4 people total. I know this might be a bit much. I would be happy with just a …

I have create a small database in 6, the client is hesitant to upgrade. I am using a table to organize their records. They have a field called final date in which the due date of thier projects is due. I want to find out all pending projects due. So I create a calculation final date > today's date = pending (1 or 0). In FM7 i can sort or do a find with this calculation. But the choises are not available in 6. Anyone know how to do this?

Does FileMaker incluse a search function that allows for searching the contents of files on a hard drive or server. I have recruitment database that references files (CV's) into a container but gives me little info about that file which has been attached - is there a way of searching its contents - this would be very very helpful. Kind thanks The Butcher

Hi... could you help a newbie? I exported a medical database from Excel to Filemaker for easier control of the information. All the fields and their types transferred fine. I have successfully "found" records according to my requirements.. i.e. Main DB: All patients 1st search: All patients with ICP codes 900-910 1st subsearch: all patients with those codes wearing seatbelts 2nd search: all patients with ICP codes 890-900 2nd subsearch: all patients with those codes brushing teeth. and etc., etc. My plan is to find these subgroups and add fields to them later as I gather more data. How can I do this? Everytime I "find" entries.., it doe…

Hi, I have a simple problem that I hope has a simple solution. I have a Person table that includes separate fields for first and last name. It also includes a "full name" field that is calculated; it just concatenates the other two fields with an intervening space. I'd like to be able to enter Find mode and search in this calculated field, but FM always reports "No records match this set of find requests." I must be missing something important...

I am having a problem with my relational logic here. I'm trying to create a record set that has data from two different many to many relationships. Basically, I have a table full of lawsuit records, a table full of lawsuit party records, and a join table to show which parties are in a suit. I also have a dockets table, and a join table between dockets and suits to show which lawsuits show up on each docket. I'm trying to build a relationship from these that will result in a complete docket report, which will show a list of dockets for a given date, and within each docket it will show which suits are listed, and within each suit, the list of parties involved. …

Hello, I have been having problems with the find feature on the database. I hope my problem is simple (as well as a solution) To duplicate a set of Line Items, I have a summary field where the "Job ID# to be matched" is in (pasted in one record, then shows up in all). From that, a calculation field, "Correct Job", determines if that value in the "Job ID# to be matched" field is the same as the "Item Job ID#" for that record, if so, returns 1, otherwise returns 0. So, when I perform a find for "Correct job" field = 1, it returns the right records... sometimes. It seems, usually, when I first start up Filemaker it performs the find correctly once, then,…

Seems straight forward enoungh but I can't seem to get it to work. I have an empty field for a selection of record I cannot replace the data in that field since I guess there is none there. Is there a way to do this = sign does not work. Since this field is empty through out the data base is there a way to put a arbitrary value in it that I can than find and replace latter that is put value x in that field in every record.

If I have removed access to the Status Area (left side control panel) within a database, is there an easy way of giving users access to the Omit checkbox when performing finds? I know alt-o will check or uncheck the option even if the Status Area is toggled off and I could deal with asking users to use a keystroke to turn the Omit option on or off. But, I'd like to be able to add an global calc to display the status of that option on each find request. I've checked out all the GET options and there doesn't seem to be one for the Omit checkbox status. Anyone have any ideas? Thanks! David Wolfe

I'm trying to use the constrain feature. I have a situation where I can successfully find a set of data. However, within that dataset I cannot find the duplicates using "!". Essentially I perform a find then I perform a find again use "!" and then constrain the set. It just returns the full set. Has anyone come across this situation or is there something that I am missing?

Here's a fun one. I have a database of cases that are referred for action. One of the fields is text field with the names of the persons that are handling the case associted to a value list. There is another calculated text field that contians the values OPEN, CLOSED, DUE, LATE or the field is empty. The values are established by some mathematics based on dates and elapsed time. My customer wants to see reports for each individual that she can give to the individual. Basically its a listing each status code for each person. Hence the dropdown for the name and the status. This was easy to accomplish. But one that isn't so easy is to get a report for an individua…

Does anyone know of a plug-in for filemaker 6 that contains a "not equal" (<>) operation. For my application, it would save a lot of time/effort over OMIT > CONSTRAIN FOUND SET. If so, please email at [email protected]. Thanks, Harold

Hello, I have a donation database and I want to find donors whose total donations for a given period is >= $500. Donors do give more than once in any period thus their total donations may be more or less than $500. How do I find the subset of donations that have a total donation of $500 or more for a given period of time? So, in english: Show me all donations where the total donation is equal to or greater than $500 and the donation date is between 01/01/2003 and 01/01/2004. Any ideas? Thanks, Dan Gronwald [email protected]

I have not written a script before and am trying to figure out how I go about writing a script that will find all my outstanding invoices client by client and organise them into a layout that I can then print out. I would also like to detail on the statement layout the total amount of invoices which are Current, 30+days, 60+ days and have a final grand total outstanding. I have a status field on my invoice layout which details the invoice status i.e Pending, Invoiced, Paid etc... I would also need to include data from other invoice fields in the statement i.e PO number, Invoice number etc... Has anyone encountered a thread that deals with this or can a…

Can someone tell me how to Save a Found Set? I read the recent posting where someone replied to a similar question - but the link was to Save Found Searches - which seems to be a little different - it directed to a video on filemakermagazine. Also, once you save the found set, is there a way to label it - perhaps even put it into a list of found sets or something like that - i.e. give it a name? Any help would be much much much apprectiated - I really need to be able to do this! Thanks! Sarah

I was woundering if a simple perform find or a matching related record would be the faster way to "search" a table with 100,000 records or more. Is it a question of number of search criterias? Does it depend on the number of records? The search criterias would be exact matches or ranges, which is easily implemented into FM7 relations. /Johan

I have 2 tables, Contacts and then lineitems, with a number field in lineitems called 'Due'. In Contacts I have a portal showing the lineitems, with an unstored calculation field that is the sum (Due). I want to find all the contacts for whom money is due, ie Due >0 but this is slow over a large set of data. I was wondering if I could make a portal showing all people who owe money, but this does not work properly. I have tried duplicating the Sum (Due) field in Contacts as an auto-enter calc number field, but this does not update. What is the best method to do this or how do I solve this problem in FileMaker 7? thank you!

Hi, I have a list of users with there Name ,phone number and email. I have a "status" field wich have to be enter using a value list. The Values are "Freelancer" ,"Permanent", "Away", "Standby". When a users are looking for somebody email or phone number they make a search by "Name". Now, I want the result to display only the ones that are "Freelancer" or "permanent", when people make a search. How can i make this happen using a script or a calculation ? thx guy

trying to find new customers between two dates and then their sales activity week by week for the following 8 weeks. Can anyone help

Is it possible to lock a layout in Find mode, or to otherwise keep the user from switching that layout into browse mode without a button/script to release them? I think the answer is no, but I need certainty before I move on to other possibilities. Short of using global fields in Browse mode is there a way to present a foolproof "find layout" without depending on the status area? Thank you.

I'm trying to find all records with a text field value greater than ('>') some other value. With the Default Language for sorting and indexing set to 'English', the result is returning records '>='. The specific script steps that return the wrong set of values are enter find mode [] set field("resources::name";">"" & get(scriptparameter) & """ perform find [] where scriptparameter=Boat/Motor 15HP The result includes records where name=Boat/Motor 15HP, not just those that are '>'. When I change the Default Language for sorting and indexing to 'Unicode', it's still wrong. with language 'unicode', it excludes the value …

I need to create a script that makes the current record the only record that appears in the found set. I need this in order to be able to export a single record at a time, which will then be imported into another application. Seems like creating a test field that looks up the current index #, then conducting a search on that field would work, but I can't seem to quite make it happen. By the way, it must be a script since it will be executed in a runtime environment by other users. Please help. Thanks.

i have 2 questions: i am in the process of creating a databse of archival material in a museum. one of my fields is "category," which has a number of possible entries (e.g., tourism, current events, antiquities, etc.) 1) when a do a find search in category i would like to save the found set as a separate layout in the main file, or something similar, so that i don't have to keep doing the find command. is this possible? i also have a "period" field which i've set up as a date field. a lot of the material is from newpapers, so i have a full date (e.g., june 7, 1977), but for others the date is unknown, or i only have the month and year. 2) is there a …

This might be a dumb question but I am trying to perform a find using a file path like this: C:Documents and SettingsDavidDesktopPDF FolderNewegg_PowerSupply.pdf and am coming up with 0 records even though there are records with this value. I tried the Trim and Quote functions but still not working. Any ideas? Thanks!

I use a timestamp whenever we call a company and need to find records not yet called (no timestamp). I've tried various options and can't figure out how to do this. Any ideas? TIA

Hi, I've come across this problem a few times and hope someone might have been down this track before me! This is what I'm trying to do; I have 3 layouts - "Person", "Car" and "Events". One "Car" record can have many "Events" reocrds. When I look at one "Events record" I would like to have a script that finds ALL "Events records" for the related "Car record". These "Events" records would have the same 1st field/value (ID) but other fields would have unique values. So I've made a script that does this (keep in mind that I'm a newbie at FM7 :-) Go To Layout [Events] Go To Field[select/Perform, Events::ID] PerformFind[] SortRecords[] But how do I sp…

Hi all, I am sorry if this question has been asked before, but I went back like 10 pages and didn

I have a Music database that contains tables: CDs, Tracks, MP3s Tracks are related to CDs - MP3's are related to nothing. I need a way to Perform a Find for a Title or Artist accross both the MP3s and Tracks tables and then display the found count for both. I tried the global relational method, but it doesn't work like a Find - that method requires the text to be an exact match, sometimes the only thing know is a word a two (Finds show records where only a portion of the field matches). I thought about combining Tracks and MP3s but the only there would be alot of null values for unrelated records to CDs. Any ideas??

Hi, When I discovered the powerfully enlarged FM7-search-functionality, I was very happy to now be able to do a search in one table but also use criteria from related tables at the same time. Yet I discovered a major problem: I use an extra search-layout with variable-fields. When the user clicks on "Search", a script switches the table to search to search mode and copies all the values from the table with the variables. That works fine, but when the user enters "*" in a field that is part of a related table, but not the table that displays the results, it takes VERY long time (about 30 seconds) - although the query is in fact really simple and takes 1…

Hello all, I'm creating a database that keeps count of the amount of profit/loss a client has made by following our stock market advice since the date he/she joined. I have 2 databases, "Subscribers" and "Selection_Results". The "Subscriber" db contains the clients name, address, join date etc. The "Selection_Results" db contains all info about the stock selection, date the selection was given, profit made, etc. I have made a relationship between the 2 db's with called "profit_to_date", with the match file "subscriber::date_joined" with "Selection_Result::Selection_Date". My problem is... Instead of just matching the "date_joined" with t…

I'm trying to create a script which allows the user to perform a find... and based on the number of records found I would like to change the layout. If the found set is 1 ... I display the detail layout and if the found set is greater than 1 ... I display a list so they can select which detail record they want to look at. But it seems the "Get(FoundCount)" is not available until the script that is running has completed. Thanks for your help Glenn

I am working on developing a geneology type solution that would recognize a request made to one person, and would log the request in each of that person's ancestor's files. i.e. I would run a script that would register a request for that person's name, and add a counter to him as well as adding a counter (a different counter) to each of their direct line ancestors. I would want to track how many requests had been made for each person during each month, and create a report listing the results. Currently I have the name, name ID, the ancestor name (which is keyed to name) that I think are related to this solution. I have 10 instances of the table in my relationship…

Hi. Ok so basically I set up 4 category fields in my contact database, each pulls up a pull-down menu of items, for example; customer, vendor, need to call, etc. but when i do a find, if the menu item is in a different field, it wont find. i need to like link the four category fields so that no matter which field i do a find in, if (for ex) "customer" is in any of the four field, it will pull up the record. does anyone understand what i mean and can help me? ive never scripted anything in filemaker before thanks please email me at [email protected] if you have the answer

Hi all FM Developers I'm trying to find al related records to a person but can't make it work. THis is the setup; I have Persons-records, each Person-record can have 1 or more Car-Records. So when I in a script find a person and then execute the script step "Go To Related Records[from Car layout, using Car Layout] I'm expecting ALL that persons cars. Instead FM7 displays ALL cars in the DB and not only those that are related to the person I've just found - why?! Can anyone please tell me what I'm doing wrong!? Kind Regards Andrew

Hi all, I was wondering if there is something like a contain find? When I want to find a string of text that is contain in a field, let say I want to find a name that contain john it wont't be = "john" Thanks all

I am not sure if i can do this or not I have attached a file with what I am trying to do which is to perform finds as an OR statement on certain fields. The table contains part of airfare rules at a farelevel (all other rules, seasons routings etc are drawn from other related tables ) Within this table i wiant to perform finds on a number of fields at the same time . I use globals to set search values and then switch to find mode insert the globals and perform find.... that part works. But it is commont that in some fields users want to be able to use the equivalent of OR statments. For example they may need to update all fares from ATL or IAH that go…

is there an easy way to create a found set with just the current record you are veiwing? I have this db that uses form letters. the user scrolls through records, finds one they like, and click print form letter. The problem is that the report, when viewed in Preview Mode, shows every record. In my case hundreds. Worse then that, it shows the 1st record in the sort list, which isnt the record I was viewing to start with. This makes a printing 1 to 1 no work either. So I would like to initiate the script and create a found set with the current record. Then I can go to Preview mode with no worries. Am I missing something obvious? I keep thinking of this crazy …

Is there a way to change the values within a found set via a dialog box type entry? I would like to be able to perform a find, then change specific field values within just those found records without affecting the values in any other (omitted) records. I would like to be able to do this in a way that the new value can be generated on the fly by the user (via a custom dialog box). In some cases, the fields that would be affected (found) would be empty. In some cases the new data (from dialog box) would be replacing existing data. Is there a way to do this? Thanks, Jarvis

I have a database that we use to track ip addresses for computer systems we sell. I would like users of the database to be able to select the serial number of any system in the database from a pop-up list. This pop-up list would be a global input field that pulls the serial numbers from a serial number field in the database. Once a serial number is selected in the input field, the user would click a find button and the selected serial number and related related records would be found and displayed in another layout. If a serial number was enterd into the pop-up list field that wasnt in the database, the user would be asked if he/she would like to create that record.…

I have a Text field that will have "merge" fields. I want to replace them with actual field values, but I don't want to have to add a IF/END IF and Find/Replace script line for each "merge" field. For example: Dear <<First_Name>>: Thank your for your donation of $<<donation_amount>>. --------- These "merge" fields may change depending on the content of the letter. I would like to be able to replace all the "merge" fields with field names that are represented between the "<<" and ">>". I'm looking for a way to scan through the whole text and whereever it sees "<<" and ">>" to replace that value with t…

Hey guys/gals.....I was wondering (newbie) how I would perform a find request on a field that contained the text "pending cleanup". This might be really easy (i hope so). I need to find all the records that contain "pending cleanup" in a certain field. Any help is greatly appreciated as always. Thanks, J

I need help to calculate a year to date purchse field any help would be greatly appreciated Cole

Hello all first time poster. I teach FileMaker Pro 6.0 and a student asked a question that I'm having a little trouble answering. Is there a way to do a find for blank values in check boxes? thanks in advanced.

When I find a set of records, I receive a list, each of which has an order total(also the field name) in it. I want to sum the order totals for the entire found set. I have created a field called Grand Total, made it a calculated field, and used the formula "Unstored=Sum ( Order Total )". Well guess what... this doesn't work. This should be simple, but I don't have a clue. What am I doing wrong? Thanks, Phil

When I do a Find in an Unstored Calculated(text) field it says there are no records found when I know the record is there. The field I am trying to do a find in is called LastNameCalc and is defined as follows: If(IsEmpty(ID#);Last Name;IndivInfo::LastName) The calculation works fine. I can see the Last Name for records that do and those that do not have ID#'s. It is when I do a find that I have a problem. For records that do not have an ID#, the find works fine. When a record does have an ID# it says there are no records found when I know the record is there. Is it because of the relationship in the calculation? Why won't it find it when I can se…

Hi, this is probably a stuppid question, but I can get it to work. I've imported a record into a table whch has field called ID. With his ID i want to lookup a matching record with another_ID. So I thought that; If(ID=another_ID) blabla.. EndIf would do it. What am I doing wrong. I've looked in the online-help but the doc is not that clear. Greatful for any help Best Regards Andrew Carruthers

Hi, I'm trying to find a record that has the same field in both records. The records have different fields (one is a search record. In the script "Perform Find" I can't see how to I'm to specify the both fields. Can this only be done with a loop over all records and make the find with an IF statement? Very greateful for any info on this subjet!! Kind Regards Andrew

My database has a separate search layout. When people come to this screen, they select a preset date from a drop-down menu, then click a Begin Search button which puts the user in find mode. This button also puts the date selected from the drop-down menu into the Date field. They can enter other criteria before selecting the Continue button. Problem: when users first come to this search layout, the results of previous searches are still displayed. While the Begin Search button will clear the fields once clicked, is there a way of removing any previous found records so as not to confuse users. In effect, I am looking for a "clear found records" script that can be put …

I am trying to set up a database to show the user a summary of invoices that still a balance due > 0, sorted by customer. I have fields called

I have a database of clients. If client1 is billed for date1, date2, date 3 then I can bill for 3 days. However if the entries for client1 are date1, date1 date3 then I can only bill for a total of 2 days. I have a summary field that counts the number of dates and places the total per client in a report. Obviously sometimes that field overcounts due to duplicates (2 different transactions occuring on the same day) If I try to first find all duplicates then filemaker sees client1 date 1 as duplicate to client2 date1. In summary I would like to look for duplicate dates within each individual client and ultimately identify them by bolding them or if possible adjus…

I need some help with a find that I am trying to do. I have 3 tables: account, accountstatus, gift ( there are more tables but these 3 directly affect the search). I want to find all accounts that have given a gift in the last 12 months that do not have a status of AD, CGP or CLP. Here is what I have so far but am stuck now: enter find GiftDate >= CurrentDate - 365 days Perform find enter find status = "ad" new request status = "clp" new request status = "cgp" constrain found set I was then going to omit all the records that had these statuses and show what was omitted to give me everyone that donated in the last year but didn't have those st…

Dear All, how can I perform a find within a set of found records? What I'd like to do is find duplicate customer names within a set of already found records. Thanks, Andy

I'm looking for a method for putting up a search layout, allowing the user to enter the search criteria, hit <return> to run the search, and then be able to re-display the search layout with the most recent search criteria, if the search needs to be refined. I can do this by using Browse Mode and using Globals on the search layout, but I don't like the fact that, in Browse Mode, the user can't hit <return> to make the script resume. I'd rather use Find Mode, for that reason alone. This eliminates the possibility of using Globals on the search layout. Here's what I'm doing currently: Set global fields to initial (null) values Loop -- Go…

Hey all. I just tried something I never thought would be a problem, but I never needed to this before. I'm trying to create a find/replace script which looks for a text string of ". Obviously FileMaker wants text strings in double quotes (""), so it would need it to look like """. Unfortunately, FileMaker thinks there is an open text string. Anyone know a way around this?

Help!!! I have some folks back east using a solution I developed, but for some reason they get different answers than I do when running certain scripts. Specifically, the database includes data that has section numbers (Section 1, Section 1.1, Section 2.3.5, etc.). I have a script that will constrain the found set to just one section. The script parameter is set to the appropriate section number depending on the button that called it. Assuming I'm looking for section 4, the script does the following: goes to find mode pastes "4." into the section number field (this finds 4.1, 4.2, etc.) makes a new find request pastes "=4" into the section number field (this …

Is it possible to enter find criteria in global fields in find mode?

To simplify enttry of dates into a Date field on a search screen, I am toying with the idea of buttons on a layout which have "Today","Yesterday", "Last 7 Days", Last 14 days", etc which, when clicked, go to another layout (a search layout) and set the date in the Date field. I am using the SetField Command, so to show dates from the last 7 days I have: SetField[File:Date;">"&Get(CurrentDate)-7] Problem: Can the SetField command be made to show a date range e.g. 1.1.2005...3.1.2005? Frank

I have searched on the forums but cannot find an answer... I am having trouble with finding records that are in a previous found set. I have already set up one way of marking other records in a different found set. The way that I have set up this other refind is: The ID of records found in an initial find are stored, line by line, in a global field. To refind these records a script loops through the global field, parsing out each ID and setting it into the ID search field in the new requests.. The script sort of works, except for the last line of the global -- which means that sometimes the refound set misses the last record. An example file is …

hi there, I have written a task scheduler here for our real estate business, we have 40 agents and 20 admin staff and the boss wanted a task sceduler so if a property is sold it triggers a lot of tasks to be send to the appropriate agent and admin. I have all the tasks in one 'tasks' database and whoever is logged in at that time i just do a find when they want to view their tasks and only the agents related tasks show up in the list. (reminders for 1,2,34,5 years down the track for example) My problem is that I am wondering how many records a fmp6 file can hold?? as it will build up quite quickly its been running for a few weeks and already we have thousands of reco…