Finding & Searching

I am using the Find Duplicates function, however when I put the ! in the address field, it finds duplicates of the street numbers only. 120 Main 120 Main 120 First 120 Circle What I want is all duplicate street number+name. 120 Main 120 Main 120 Elm 120 Elm How can I do this? Thanks

Simple question - I want to search for a particular year in two related tables and then display all the results where data from the tables corresponds to a particular year. Right now I have a script that prompts the user to select a year for one of the searches and then I force it to Constrain the found set to records where the related table has the data "2006". I'd like to make that a variable so the script will continue to be accurate for any year choice.

hello, this prolly is a n00b question but i really can't seem to get it worked. I already looked on this topic for answers http://www.fmforums.com/forum/showtopic.php?tid/173072/ but it really doesn't work for me. this is my script: Set Variable [$test; Value:Company::Company_ID] Enter Find Mode [] Set Field [Company_ID ; $test] Perform Find [] i see that in the search field not the company_ID is filled in but $test. So i thought my Varibale was wrong. But i tested my Variable with the save as pdf script and there it turns out oke, what im I missing? thx in advance

Is it possible to do a case sensitive find? I have a field that contains a lowercase "a" which stands for one thing, and a capital "A" which stands for something else (all this data is imported so I have no control over the data inputting; i.e it has to be big "A" and little "a"). At this point whenever I do a find for any "a", I get big and small. Are there any workarounds for finding based on case sensitivity short of going through each record one at a time and changes big "A"s to something else? Any calculations that recognize case sensitivity that I could use to easily change all big "A"s to "Q" or something..? Thanks! Sol

Hi. I am trying to create a button which will perform a find asking the user to input two dates which they want the records to be between, then to switch to the other layout with the found records. When i go to scriptmaker, i have perform find as the first action with the find request being "Date >= ?" and it won't accept it. how do i get it to ask the user for the dates they want?

I have a table that is set up to track relationships between records that have been duplicated from other records using an auto-enter field that creates a return delimited list of primary keys for related records. The database is acting funny in that it won't find records based on the related fields during a find operation (even though they show up in a portal). The search is just a "*" search not one of the new v8 search patterns This all worked a few months ago when I added it to the database and put it on the server. The server has never crashed in the meantime, but now the finds are returning incorrect results. The strange thing is that if I take a backup cop…

I have set up a time card database. Each Time Card can have up to 25 job names and 7 days worth of time for each job. I am looking to be able to have a summary that will print out per job. (ie. Week Ending 5/5 Job #1 Jim 13hour Paul 16 Hours Job #2 Sam 14 hours Jim 6 hours ) The summary need to be for the time cards in a given week ending date, and should give to total hours worked in that week by each employee on each job. Any Ideas?

hello all, where can i turn of the switching between records feature. If i hide the status panel i can still switch between records with my mouse scrolbar. How can i turn this off? plz help thx in advance

I am trying to omit all individual records (filtering on Name) from a found set of 4 produts, that have to be posted. So that I am left with all customers who have purchased more than 1 product, allowing me to post them together. I can get as far as a sorted list, but I have to wade through all the individual orders to find people who have purchased more than 1 product. I know you can use a ! to find unique records, but only on the entire database. Any suggestions for scripting this? Thanks Daniel

I'm seeing odd behavior when trying to delete a find request. It works fine if you are using a table that exists in the file, but not when you have a layout based on a TO from a different file. The request does not disappear immediately. It lingers until you go to another request. Can anyone else confirm this? Try the following: 1) Make a new file containing 1 table. Add a couple of fields and records. 2) Make a second file that contains no tables. Add an occurrence of your table from file 1. Make a layout based on that TO. 3) Enter Find mode. 4) In the first request, enter the criteria "one". 5) New Request. Enter criteria "two". 6) New Request. …

I have a serious problem with using Constrain Found Set script step in FM7. What I am trying to do is to get a found set of records based on some criteria. Then I want to find only those records from this current found set which match a particular criteria and have unique person names. (For finding unique records, I am using the relationship feature as described in FM) I am getting the first found set correctly. (about 4000 records out of about 70000 records) But the problem starts when I want to Constrain my found set for the second criteria. My script is something like this Enter Find Mode [Pause] Set Field [CheckUnique; "Unique"] Constrain Found Set…

Hi all, Every RECORD has a CONTRACT layout but not every record has a contract. So what I want to do is when I come to draw up a contract for a record I want to be able to use a button on the contract layout to find the last contract I did. I've been playing around with the sort records tool but it dosn't seem to like me! Can someone take me through step-by-step? Any ideas? Thanks!

I have records that have a field with values that look like this: 1-1 1-2 1-3 1 KG-1 PB-1 2-1 2-2 1-5 5-1 I'm looking for all the values that start with 1 like 1-1 1 1-3 1-5. If I enter a 1 int the find field, I get all those I'm looking for including KG-1 and PB-1, but NOT 5-1 - all three of which I don't want because they don't start with a 1. Oh yeah, it's a text field. Any help on what I'm doing wrong?

Hello, I'll let you know my problem first then what I need. Problem: I have several users with functional layouts (ie editor, artist, etc). I want the user to login and see only their layout (done), but I want it to only see the fields with their name (done). The problem is that even though they can only see their records, they can see the fields that say "no access". So what I want to do is have them login and when they login it does a search on that specific field with their login name and it finds only those records. It's kind of complicated. I did it this way because I have no clue how to make a database relational. ha ha. But it works! I just need to find out ho…

Does anyone know if it is possible to perform a find request "Find[Restore]" on a script variable "$my_num" that is declared and set in the same script? Thanks, J

I am trying to produce a list of tasks for assembling kitchen cabinets. The task lists vary depending on what type of cabinet it is that we are building. Whenever I select (perform a FIND) one type of cabinet, I get a list of all activities germane to that type of cabinet. I would like to be able to duplicate all of these tasks (RECORDS). The Records Menu provides me the option to DELETE FOUND RECORDS. [color:red]Is there some way to duplicate Found records? I would like to be able to grab a list like this, assign a unique cabinet ID number to each task, then give it to the guys. Any ideas? Thanks, Jarvis

I cannot figure out a way to accomplish what I think should be a fairly simple task. I have a portal with varying numbers of records (actually products) for each customer record. Above the portal I have a summary field (actually a Count of products) that I want to be able to use in Find Requests - e.g. find all customers with 10 or more products. It appears as though Find Requests are not valid on Summary Fields in FM8. I have tried using a Calculation field as well (Get(FoundCount)) but this also does not appear to work. I have also tried creating a field that looks up the value of the Count and attempted a Find Request on that field. No luck. Am doing something wrong or…

I'm trying to create a latetardy DB for my school. I would like to have 2 different searches which will narrow our school roster down to only a single teachers class list. I would like the parent to find the teachers name first and then have then have them search through that class only to find their student. I'm trying to bypass them looking through 600 records to find their childs name. Thanks for your help.

I am having trouble getting a find script to work correctly. I copied it from a pre-made database that came with filemaker pro 7, its called 'Student Record' and is in the 'Education' section of these examples. I have a attached a copy of my database*, could someone please have a quick look at it and point me in the right dirrection? I nead it to be able to search by every field in the student records layout, then for example all students who got grade 3 in year 7 in the transcript layout, all students who havent paid in the fees layout. I hope you can understand what I mean once you see the database. And also comment on it in general (feedback)? As I …

I have a need to find records that meet specific criteria, but I want to include those records where any one of those criteria could be blank. How do I arrange the find requests to include blanks in any of the specified fields, as well as those that meet all specified criteria? I have been told that I'm a beginner or novice user rather than intermediate as I thought. I just don't know how to change it in my profile. Thanks!!!

Greetings, I can't seem to find a good way to do this, lack of experience, I'm sure. I have a database of Applicants, I have some Reviewers in another table, I have a bridge table Applicant_intvscore_Reviewer so that I can assign 2 reviewers to each applicant. When the reviewers disagree on whether to accept or deny the applicant, I assign a third reviewer as a tie-breaker. What I need is to KNOW when there is a disagreement so that I can assign the applicant to another Reviewer for a tie-breaker. I tried making a dup_check (applicantNum & ReviewerOpinion), search for that and then show omitted, but I get where one Reviewer has made a decision and…

I'm wondering if there is a function in FM 7 that will finish a field once you start typing in it. Such as many webbased applications allow. So instead of using pop up menus i can just start typing an address and the program will look to my address tables and finish it off for me. Thanks

I am looking fora tip on what I think is simple. I have a script that finds items based on a job number. Some of our numbers have variations such as 12345 and 12345A. When the script runs, I look for 12345 but it finds both. How do I tell it only find the exact match or to omit the unexact match?

I have repated field and i want to get all records by foriegn key to delete,edit. Should I need to create another table for showing records.I'm novice in FM. How can I retreive related records? Thanks for advance.

Can somebody point me to the right direction? I am planning a small database with about 5 tables. (Property, Suite, Inspection, Maintenance, Staff). I have the layouts ready, now I plan to start working on the scripts. But, I have no idea how to start or how to plan my scripts. How is it usually done? What goes firs? I need to implement simple navigation, search and data entry. Thanks

I would like to be able to find a count of the unique values of a particular field in a found set, e.g. find how many different last names there are in a list of people. I've dabled with calculations triggered by scripts, summary fields based on the field in question, but the only way I've gotten it to (sort of) work is to create a value list from the field, then do ValueCount ( ValueListItems ( "DatabaseName" ; "FieldValueList" ) ) however this seems to work only for the entire database, not just the found set. This topic and this one cover this a bit, but its not clear if they've gotten it to work, I don't completely understand their solution, and they…

I'm new and thanks for any help in advance. I'm setting up a page where you can choose the name of a client from a drop down list and see their profile. Currently I have the drop down list bound to the search "name" field. When you choose the name, the correct record populates the various other fields. However, if you choose another name from the record, the client name of the current record is changed to a new name. i.e. John's Pizza: 555-1710 becomes Peg's Flower Shop: 555-1710 Obviously, this is a big problem. I know how to do this in .NET, but I'm stuck in FM. Is there a global variable field or something I can use as a place holder so that changin…

I don't know why- but I have 2 files set up the same but one has drop down available in find mode and the other does not- I don't see any differences. Any ideas? Thanks- Om

I have an issue with displaying my records. When I go through any of the modes It will only show Record: 1 Found: 1 Even though I have 35,011 records in this file. How do i fix or reset this so i can view or browse all records again. I am brand new to this, have run through the tutorials, but I did something when I was building or Modifying Layouts.

another newbie question: I would like to have a script run thru the database to find all the empty fields and replace them with ? or spaces or something. Any help would be greatly appreciated. TIA

We are trying to add information to a field, to multiple records. We want to tag information to all of our records from a particular find. However there is no common data in the records to "find" in order to add (replace) the information. Is there an easy way to do this. Thanks

Hi We have a problem to make a search in filemaker We have 3 field my problem are 2 fields are mileage (ex) 1st mille 10 and the other one are 15 on my script we need to find all record are between field 1 and field 2 with 1 field we have no problem but with 2 field im not able to perform my search with command ... Thank you

I'm trying to script a search that finds records updated by someone other than the record owner (salesperson in my case). I have a global variable called last logout that does a timestamp when the user logs out of filemaker. So the basic search I want to do is Find records where dateupdated > gLastLogout AND salesperson does not equal currentuser. But I can't figure out how to do a find using both an "is" and a "is not" if you know what I mean.

I have setup a database that lists records in a filtering method via internal relationships. I would like to be able to include the current found set as one of the filtered sets. However I can't find anyway of determining what is the found set as there is no way of "Getting" that information. I suppose i could have a mark records script included in every find but that would slow down the dbs quite a bit and I want this to be fairly seamless. Does anyone know of a way to determine what records are found and which records are omitted at any given point in time.

Hi, I'm creating a sales report of my DataBase and I would like FM to show (in the header) the total of my result? it's possible to break down the result? ie: 15 PROSPECTS, 10 CUSTOMERS, etc... any help will be very appreciated!

For Apptment times There are the following options for the week and different times for the weekend. For example Week: 10:00 AM, 13:00 PM, 15:30 PM, 18:00 PM, 20:00 PM Weekend: 10:00 AM, 12:00 PM, 14:00 PM and 16:00 PM Now, i have it so that it checks the times that are avab and it is showing the first one. However i would like to setup so that if the date is "Saturday" then it gets the times from table "AppttimesWeeked", else it gets the times from "AppttimesWeek". Is there a way to set up a script or something simular under "Field Format" - "Define Values" - "Use values from Field" ?

Anyone give me an idea of how I might go about scripting the equivalent of the manual 'Add New Request' when doing a Find operation. My solution has an Area Code field. I'd like to put togther a simple form or dialog box where my users could simply enter multiple entries for the search i.e 30, 45 , 50 in a single text box as required. I'm sure I'm missing something simple but I can't seem to see the wood for the trees !! All help gratefully appreciated.

I'm trying to design a Help Subsystem to have a file containing four records, where each record consists primarily of fields of "help" text. The contents of the individual fields describing a specific system feature differ from record to record in order to support users of different levels of capability: Beginner, Intermediate and Advanced -- with the first record being Developer, which contains my notes, formulas, etc. that the users should never view. At runtime, fields from one of the records are displayed on various layouts according to the user's own preference setting (Beg/Int/Adv, as defined in a User Preferences record). How can I allow a user to change…

I apologize if this has been covered somewhere. (still looking) I need to do a search on multiple fields but only 1 of those fields has to match. In other words I have a setup of 8 slots for a payment history and payment date and I need to be able to search for any payments made within a range or specific date in any one or more of those slots. I know you are wondering why are they not in a seperate table with each payment being a seperate record. There is a reason for this that is too complicated to explain. Other aspects of the database are in seperate tables but not this.

Boy this sure sounds really easy. On the same layout, I two completely different searches. Meaning..At the top of the page I want be able to search all contacts by county. Then..instead of using the search above they can do another search of volunteers by county. More or less two different types of searches on the same page. Any suggestions?

Hi:friends which script can find sometings at two fields? i want to find "date" and "total_money". thanks test.zip

I need help to do a search comparing 3 fields. I have 4 feilds set up: 1. Item 2. RRP1 3. RRP2 4. RRP3 I want to list all 'items' where 'RRP2' or 'RRP3' is NOT equal to 'RRP1' Is this easiest using CASE? or just a script...any suggestions/advice? Thanks

I have a database with the two following fields: WORKERS - HOURS. Typical values for each field might be as follows: WORKER HRS Betty 5 Billy 6 Skippy 2 Betty 1 Billy 2 Bob 5 Betty 5 Billy 6 Is there a way to find all occurrences of unique names and then total the values per unique name? I would like the end result to look like this: Betty 11 Billy 14 Skippy 2 Bob 5 I can figure out how to subtotal by field group, but it escapes me how to do this by in…

Hi all. Maybe I left my brain at the grocery store yesterday, but when I search in my customer email field (which is a text field, nothing unusual), and I enter an email address such as [email protected], it comes up with nothing, even though [email protected] is there. Is it because of the @ symbol? Is there a work around? Thanks much!! Terri - Storm Cellar

I tried searching for this info, but I think I may not be using the correct terminology. I have several scripts that perform "Finds" based on user input (a date range) and then produce a report of the records that fall in that range. The original designer of this DB stored the user input date range in a field, and then used the "replace" feature to propagate the info across all records in the range, so that he could then put the field in the report header to identify the date range of the report. The problem I'm having with this methodology is that I'm now storing the "last modified date" of each record, and who did the modifying. It's not terribly useful t…

This is probably a silly question, but please bear with me. I have created a flat-file database cataloguing the mutant fruit fly stocks in my lab. Each stock has a "BriefName" indicating the major mutation in the stock, but many stocks have many mutations in all 4 of their chromosomes. Therefore I have created 4 fields (Name1, Name2, Name3, Name4). Each stores the abbreviations for ALL mutations (even those not mentioned in the BriefName) on that particular chromosome. However, this presents a problem in searching for stocks - searching by "BriefName" is not enough to catch everything in its net. Say I want to find a stock with "GFP" on any of its 4 chromosomes.…

Thanks in advance for the help. Is there a way to save a set of data after a find so that exact list can be pulled up at any given time and cross referenced with another list? For example. I find a set of entities that are current members and I then mail them a postcard. Next month I want to send all current members another postcard, but I don't want to repeat the ones who recieved it the month prior, so in previous applications (Microsoft Access) I would take the saved table from my first set of data and run an "unmatched" query on the new data based on ID number so that I would then only have a list of those whom did not recieve the postcard, without fear of…

Hi firends! my english is poor, can you tell me how to wirte scrip for search no data records in FmPro. This field name is HJ, type is number. i want to search HJ's option is no data, some them is >1 , i only need to find them is 0, i have try to it yet . but i can not find it out with zero(0), how to wirte the scripts or which symols can use it at here . tell me master!! thanks!!

Why do my search results always come back sorted by record number instead of by last name (alpha)? I have a simple contact database that uses different layouts. One for browsing, one for searching etc...In the search layout, I script my "find" button to: 1. Perform Find [] 2. Sort Records [Restore; no dialog] 3. Goto Layout [browse "layoutname"] I specified sort to be by Name_last and then by Name_first. But when displaying the results in the layout in browse mode, it won't be sorted correctly. Thx.. Jess

I can't figure this out ... I have a field on a form that is defined to allow entry in Find mode. However when I try to do a Find on that field it just blink and the cursor remains on the first field in the Tab order. However, if I tab from that field to the problem field I can enter data into it. This field is the 3rd field in the tab order. The field before it is a Pop-up list if that is relevant.

Hello all, I want to know how can do a search without the curser jumping to the next field. example: I have 2 fields: name_contact and name_company i want to search the name_contact, so I go to layout:search. I enter the name (with autofill a couple names show up, i chose one and than press enter. Now i want that fm searches the names and don't jumps to the next field, in this case, name_company_field ps i already have untagged the tab, return and enter options on "go to next oject" in the field options how do i do this "autosearch" thx all for your help.

I have somewhat of a complex search page that is pretty limited on flexibility [clients request this format...]. The find page is setup so that the user may select a ''description type'' [checkbox format], ''employee size'', ''state'' and etc. However, they requested [color:red]3 pull down menus selecting''city'' [color:black][color:red][3 different cities] and the same for county, and zip code. Global variables didn't work because you couldn't search in find mode, which was problematic. I've been having weeks of trouble scripting this. My ultimate solution was to have a button labeled ''add more'' under the fields that needed more requests. This button h…

While building a FMP->MySQL PHP script, I've discovered that my FM database has some incorrectly formatted numbers. As I am inserting to a DECIMAL(30,2) field, MySQL is choking on double decimal point input, "2..25" or "0..15" I want to identify and correct all of the screwed up data, but can't figure out how to isolate them. I tried to do a find for the following values and the all turned up "no records found:" .. ".." ==.. =.. *..* .. What find criteria should I be using to find these screwed up records?

field 1 record 1 is empty, field 2 record 1 has data field 1 record 2 has data, field 2 record 2 has data How do I move the data from field 2 into field one only if field 1 is empty? Any help would be most welcome! (I am just learning) Thanks Mark..

I realize this falls within the same category as the prior ''parameter-related'' thread, [http://www.fmforums.com/forum/showtopic.php?tid/174238/] However, this is urgent. I'm working with a database that has search form on the first layout where a user may select multiple criteria from a checkbox, drop-down list, and etc. I would like these parameters [for example what they picked from the checkbox or value-list] to show up in a field on the next layout page which displays the find results. Do I use a global? If so, I'm completely new to the idea of globals and am not really sure if I understand how they work. If anyone out there knows a solution…

If field one begins with a capital letter and field two begins with a lowercase letter, (the sentence was split into two) how do I search to find all field two's that begin with lowercase and join them back up with field one and leave all field two's that begin in uppercase alone?.

I have a table with following fiels: accountname, product, quantities. I need to find only those clients who ordered water AND coca cola together. How do i proceed. I always get those who ordered only water, only coca or both. But I only need those who bought both.

Hello, I have a database of individual shots in a film. As the shots are worked on by artists, I log comments to the shots in a comment field under each shot. I'd like to do a Find which yields a list of the shots with only the latest comment for each shot. Searching by date range doesn't work as some shots receive multiple comments per day... Any ideas? (and/or any ideas where to look for info on this sort of thing in the future the FM help pages/manual don't seem comprehensive based on some of the other info I've seen posted here?) Thanks, -Greg

Is there a simple way to delete duplicates? Is there some sort of simple script to do this? I would have thought that this was such a basic function in Filemaker that they would have included a script in the programme. I can't tell you how frustrating this has been - pretty obvious stuff but apparently overlooked.

How do I find all UNIQUE records and delete the rest. Essentially, I am trying to compare two tables by appending them together, and only keeping the changes. So any record that gets carried forward to the next table will get deleted. This way, I only see changes.

For exemple: I

OK, so maybe I should change my profile to say beginner instead of intermediate... I want a script to COPY the ITEM NUMBER from one table, go to a different table, and FIND all records in that table that match that item number. My script works now, except that I have to go over to the tool panel on the left side of the screen and click on "FIND" half way thru the script (after it has pasted the item number into the field). Is there a way to make it automatically FIND those records without me having to click on Find again? Thanks!

I have a simple SQL Search that needs to be done but it looks like Filemaker can't do it. Any help would be greatly appreciated. I am search a table that contains homes in my area. In plain English the search would look like this: Select all fields where Region = region1 or region2 or region5 or region7 or region8 or region9 and condition = excellent or above average or average and view = ocean or mountain or beach and price > 100,000 and price < 200,000. Now this search is fairly easy to do using SQL, but in Filemaker it looks like I would need to create 54 search requests, which of course no user would ever do. I called Filemaker support twic…

Hello everyone, This might be simple to yas, but has me stomped. I need to find records related to an item number. However, this item number may have been entered in the database at several different dates, depending on when and how often my users have seen the item. No problem so far. I made a find report layout where users can do a search by item number, and date. However, I want the field to use a value list of dates related only to that item number. Right now when I use "date" as the value list, all dates for all records are displayed. For example, in "item number" field, the user enters 307, user tabs to "date" field which displays a value lis…

I have a questions regarding how this FM search works which I hope someone can help me clarify. The FM file have a text field on the top of a layout page. The thing is the search only return exact matches to its input. This field is not available in Find mode. The search is for a given title entry. Currently I have located it to this: There is a (=) relationship from the textfieldname to a table called NameRelate. NameRelate = 1 & "¶" & Left(Title;1) & "¶" & Left(Title;2) & "¶" & Left(Title;3) & "¶" & Left(Title;4) & "¶" & Left(Title;5) & "¶" & Left(Title;6) &amp…

I have 2 DBs and a relationship to link them by an ID number. DB1 contains only live jobs, for example 10 records in there. DB2 contains all jobs, for example 80 records in there. In DB2, how do I find those 10 records contained in DB1? Thanks

...but I can't get the Perform Find script step to return the results that I think it should. I've read the online help half a dozen times, but I'm still lost. Can someone explain to me what I'm doing wrong? I've created a relationship between two tables. Based on the contents of a field in one record, I'd like to go to the "related" record in the other table. I first do a Perform Find step, then a Go To Related Record step. Am I skipping some vital step here, or taking something for granted? Thanks for any help... mz

Hello all, I have a problem with my DB and relationships and finding the records. I have added the file with this post: accountname: admin there is no password. I have a 1 to many relationship. Groups, think of this as a mothergroup of all companies. Company, the company. In my layout I want that the user selects a group and than selects a Company related to the group chosen. Since it's a 1 to many relationship many companies can be shown in the dropdown menu after selecting a group. See: search (chose group first) This layout works. But it must also be possible to select (or type) a Company and that the group is automaticly shown. Sin…

Ok I give up.... I've searched the forums up and down and still can't can get it. My Script is: Enter Find Mode[] Set Field[Adress Book::ExportDate; "<=" & Address Book::CreationDate] [color:purple]{I've tried switching the field names around also} Perform Find [] All I'm trying to do is find all records created (i.e. field name-CreationDate) after the last date I exported the records(i.e. field name-ExportDate) But when I run it I get the prompt that no records meet the criteria message. When I run the scripted editor the field is empty I don't understand why? I've seen this type of format in many examples that are posted. Be…

How can I enter a Y or check a checkbox in a field of all found records?

Is there a better way than to perform a find against an unstored calculation field? The find takes forever as the unstored calculation field cannot be indexed. Here's my problem: I have a real estate database and I want the user to be able to search multiple criteria from one field (ala google toolbar style). The database fields I have are: City, State, Area, Zip Code, and Listing ID. The unstored calculation field (The field the users uses to search) concatenates all the fields, ie: City &" "& State &" ".... For example a user could perform a search by typing Chicago, IL into one field(in my case the unstored calc field) as opposed to entering "Chicago" into …

I am trying to do the following: SetVariable[ $a, field_name ] ... PerformFind[ Restore ] Under the find step, I specify find requests, and try to set the criteria to equal the variable, by entering "$a" as the criteria. This doesn't work. Why? Is there something else I can specify here? I worked around it by doing: [Enter Find Mode] [set Field] [Perform Find] But that is a little lame because I have to have the field on the layout that I am on. So, what's going on here? Is this not an option? A known issue? Thanks for the help.

I have a database that assigns tasks to workers. The list of available workers ony includes those who are logged into the computer. If they are at lunch, or out of the building they are not available to assign a task to. The task assignments are made via radio button value list. This value list is populated from the field AVAILABLE WORKERS. I would like to be able to FIND all the tasks that have been assigned to a particular worker and I would like to be able to generate the FIND criteria via a radio button. Is there a way to set a field value as the default criteria for a find? I would like to proactively populate a field (with the radio button), th…

I have two tables: One stores appointments (Appts), the other stores info on people (People). Every person has appointments that are due at regular intervals, so I have a number of calc field in People that calculate each due date based on a field initial_date. I then have a number of fields that calculate whether an appointment is within 5 days of being due and has not yet been scheduled (e.g. appt1Due, appt2Due, etc.). These calcs return 1 if criteria applies and "" if it doesn't. I might add that there are a number of relationships in play here for each type of visit, but all with the same general format. The two tables link by peopleID and apptType. The pro…

I have a field called Profession (text, indexed). I do a find on 'Buyer - Is My Client' and in addition to turning up records having this Profession type, I also turn up records having 'Buyer - Is Not My Client'. It looks like the field matching goes only as far as the word 'Is'. This shouldn't happen. Anyone have an explanation? Win XP FM v8 Advanced. Steve

i have created the following calculation -departure date = (Date ( departure month ; departure day ; departure year )) however, what i get in return is always '12' for the month; the correct day; but always 1 year less than the entered year. now, my months are entered as text, and so i know i need to do something radically different here, but do not know how to proceed (for other reasons, auto emails, etc, i need the month as text) -- i need help with this. and then the year problem, just baffles me. for instance i enter 2008 in the year field, whch returns 12/01/2009 in the departure date field. any help would be great!

I have a found set of just over 300 records. Each record has a value field and a summary field which shows the total value of all found records. I need to find a combination or subset of these found records whose total value is equalled to a specific amount - let´s say $96.72. Can I do this in Filemaker 7? Thanks, Alvise Migotto

I am new to FMPro. Problem: Need to Find information contained within 1 or more fields based on criteria that may not be at the beginning of field data. ALSO- want search to be case independant. All data regardless of Alpha Case. I ONLY want to see EACH "End customer" name with the search criteria containd within one or more circuits belonging to that "End Customer" AND ALL of the "Circuit ID"'s that contain somewhere within them, my search criteria. For this example, all fields are in the same table. Example: Database: GNSC Circuits RECORD NUMBER #ONE End Customer: Neon Nequadics Field1 name: Circuit ID1 Data: DDF-34343-…

I'd like to give this question one more try: Is there a simple way in FMP to pull the a values out of two records in a table by requesting them by absolute record numbers? (for example, records 4 and 7 in my sample file) The resulting contents of the displayed fields then need to be editable on the layout by the user. The real-world application of this is a system with 100 “devices” defined in a table with each device having a description, a current “reading”(stored in the table by instrumentation drivers), plus an operator-entered “setpoint” value. A partiicular layout will have a graphic showing the relationships of a group of devices, along with current re…

small problem... all my finds are scripted.... point is i need to be able to commit a find request using the enter or return key... and it doesnt work if a user selects a radio buttons and then hits the key... any suggestions? i.e. how do you trap for certain key hits..? cheers genx

gday gday, i know everyone loves me and my wonderful questions so ill just get down to the point lol :... basically... when a user clicks my find button... i.e. not native filemaker... a script is executed that has to first omit all records that have one of two different values in a specific field.. then it lets the person search as normal... through all the remaining records... im not that great with the constraining and extending options .. could someone please produce me a mini script or tell me how to get around omitting those records using some other function please? Thanks lots, as always in advance, genx

Hi, I have a field that gives the user a choice of finding their jobs based on what they select from the field... Today Tomorrow 2 Days 3 Days Then I made a button that starts a script to find and sort the records that ship "Today", (or whatever other choice they made). I tried to do an "if" in the scriping window to accomplish this, but it's not working as I'd hoped. Am I going in the right direction, or am I missing an easy solution??? Thanks! Mark

How do I find uppercase letters in a field? any uppercase character.

Hi, I have a problem I can not resolve and would appreciate it if someone could point me in the right direction. and or if possible explain in some details. My efforts at searching this forum to find the answers have failed despite several hours of reading posts. My problem is 2 fold. Part 1 I have a simple table with 10 fields the fields all contain part numbers. each record relates to a single item so one item can have up to 10 different part numbers. I need to be able to do a find (search) on all 10 fields for one of those part numbers which could be located in any one of 10 fields. (using a single field as the search parameters. Part 2 I ne…

I am using FMP 8v2 in conjunction with Server 8v2. I have a field whose value is a calculation using the Get ( FoundCount ) function. The problem I am having is that if the number of records is reduced, the value in the field using Get ( FoundCount ) is not updated. For example, if Get ( FoundCount ) finds 3 records, the number 3 appears in the field using that function. If I delete a record, I now have two (2) records, but the field using Get ( FoundCount ) will still display 3 for a value. Is Get ( FoundCount ) supposed to update dynamically with the found set? If it is, I think I found a bug. If it is not supposed to update dynamically, is there a wa…

I have 3 fields (Field A, Field B, Field C) and I want the user to be able to go into Find Mode, enter their search criteria - into a global field - then select from a choice of 3 checkboxes to determine which fields are searched (e.g. Look in Field A and in Field :. I then expect to create a script based on which checkboxes have been selected. Do I have to use 3 different fields (e.g Option 1, Option 2, Option 3)? How can I present these as "checkboxes"? Can anyone help?

I need a script that will either go to a related record, or create a new record if no related record exists. The application is a job that has 3 componets, I need 3 buttons 1 for each component that will be "goto / create" buttons. For the details held in each of the component tables. Can someone suggest a script to do this? Thanks Daniel

hi, we're a small charity with our own database incl. table of donors and table of donations. we need to work out how much a donor has given in the last year so that if it says zero, we can write to them. donors table:donations table is one:many. we therefore need to add the amount of each of the donation records in the past year for each donor. we need it to be done instantly, rather than in a button. thank you very much for your time in helping our charity Oliver www.himalayanlearning.org

Trying to track at least 10 changes to a record that various customer service reps. make. I would like to be able to track the date, time and field the changes are made to. If an option to change the color is available that too. Other production people look to the record for changes that have been made since the last time.

I have a text field whose content contains a project number in the form xxx.xxxx, xxx.xxx, xxx.xxx.xx or xxx.xxxx.xx. So for instance, 001.1200.45. I need to find all the records that match the pattern: 001.1xxx.99 where the x's can be any number. I think the current find request should match: 001.1@@@.99. Instead, that returns some records, but they do not all have the .99 on the end of them (ie: 001.1234 matches). Adding quotes or equals before and after the text results in no matching records. If I do 001.1*.99, it finds some records, but in addition to the 001.1xxx.99 records, it returns some records that match 001.1xx.99. Any assistance would…

In browse mode I have 3 fields (last, first, idnumber). Is there a way to perform a find on a last name field and have display the results depending on the letters entered. (enter 'r' and display will show all the last names starting with 'r') And keep the format of the table view. Similar to the typeahead feature but without opening an edit box? I need to view all the fields of adjacent records at the same time to compare/analyze the data. Then the selected record will become highlighted. Thank you in advance.

I am setting up a database for our editor. Container field will hold word or pdf docs with their content duplicted into another field so that they can be searched for keywords. Problem is I do not want the user to modify the text in this field - only search and read - but as they can contain large quantities of text the user needs to have access to the scroll bar to read all of the content. Any solutions out there?

Hi! could someone please tell me if it's possible to search for 2 different criteria in one field? for example for the search to just show the sales reps AC and LR. Is this possible. Thanks for any advice. CHRIS.

Thanks guys for the tips and suggestions. I just purchased the Donations 2.0 application for use in keeping track for a non profit organisation. i have added few modifications to make it easier, but got stuck at the adding a calculation to add all the donations made by each sponsor for the whole year. There is already a function for generating several reports, per month, etc but non to send a receipt or summary at the end of the year or YTD (YearToDate) where all the donations made by each individual will be summed up and printed as one letter or report and sent to the sponsor. I have seen alot of useful write -up on this, but any there anyone who have had the opprotu…

Hi, I have a field that has the following values in it: Molecular Pharmacology Molecular Pharmacology - Imaging Is there a way I can do a find that will find only the "Molecular Pharmacology" records and not the records that have the word "imaging" after them ?

If I have a table of 50,000 words every day, is there a function that can compare the new table to the old table and spit out the changes or differences?

Hi, any help would be appreciated on this. Simplifying my problem a great deal - file is actually several million multiple field records of which 95%+ I need to discard How would I get FM to find only the lowest number in field2 for each field1 entry and to discard the rest? I am struggling with this! field1 - field2 A - 1 A - 2 A - 3 B - 4 B - 5 B - 6 C - 7 C - 8 C - 9 i would need it to return only 3 records for this example A - 1 B - 4 C - 7

I have a calculated field which results in text. The field is a calculation that has the name of a container field in it, to display the contents of the container field in text. calculated text field cont_text = container <-- just the name of the cont. field in the calculation so, the cont_text field has the following text values white.png yellow.png red.png When I try to find on this field, I enter find mode, enter the text "red.png" in the field, then perform the find, the result is all the records.. including the records that have yellow.png and white.png in that …

Is there a script step which duplicates a find request using Control + F? In other words a find request clear of any criteria. Thanks

hi I can not think anymore (it seems) What I would like to do is to ask the user in de find mode to ask a category to search for. When done I would to extend the search with another category. So he asked for cat1 but he will get cat1 and cat2 back Can someone give me some direction how to handle this? thanks emma