Finding & Searching

First day on someone's filemaker pro 4.1 database. Actually it's Ebase, if that means anything to you. There are a bunch of check boxes in a few different columns. Most of them can be checked and unchecked. 1 column however, a most important column, can not. When you click on them to change their boolean value, the "not modifiable" message box pops up. What are all the possible reasons for that? Only 1 column has a problem in this respect. If I compare the field format, with a right-click, of one non-working checkbox with another checkbox that works, they look the same. the person who works in this database daily thought she could change the value it …

How can I find all records with a numeral or number in it. ie - 1car or car1 or ca2r

hello not sure if this is the right place to ask this question. I am having problems with converting my database to a stand alone app. I use the filemaker developer tool to create the app (this seems to work fine). but when I open the app from the cdrom, it does not allow me to add records to the database. what am I doing wrong. Is there some setting I need. the app opens fine ( I belive) but when I go to add a customer and I click in the field I get this message "this field is not modifiable". help please

I would like to perform a find from one layout and it bring up the results of the find in a different layout. What is the best way to get this done. Thanks

Hi everyone, I would be happy if someone could help me with this tricky thing! I have two different databases: MAIN and COMMON. The DB COMMON contains between other a table containing different string in different language: Table DEFINITION, Fields are Name,French,English. I've made a file reference for COMMON in MAIN and added the table DEFINITION in relationship so I can select the fields. From each layout of MAIN, I want to set the tooltips "on the fly", depending on the language and the object. So I need a function in SetTooltip that will retrieve the data stored in French (or whatever) where the Name='something'... Does anybody have an idea?... Thanx!

I'd like to take the idea of highlighting find requests a step further. I've been looking at Ray Cologon's custom function, and Ryan Brandys' custom function, but can't work out how to use a return delimited list of values in conjuction with these. Basically I want to be able to highlight multiple search terms in a field when perfoming a find request, or multiple requests. Hope this makes sense. Any information gratefully received as I'm struggling over where to start! Thanks

Hello, I am relatively new to FM and am setting up a contact database. Contacts can either be individuals, families or corporations/organizations. My problem is with the families. Each family record is linked to individual related records. I can set that up, but my question has to do with when I need to set up a mailing list/find. Is there a way to eliminate the individuals that are part of a family in the mailing list or find, thereby eliminating duplicate mailings? Thanks, MT

You'd never know that I'd been doing this, on and off, for years. When you're just building dbs for your little organization, some things never come up. I want one record and only one record, for each instance of a serial number [this db is storing artwork for some, but not all, records in a related db]. So I want a script to come in, do a find for serial #X. If it finds more than one, it returns a custom "Hey, I found more than one" dialog box. If it finds one, it shows me that one. [both of these work fine.] If it finds none, I want it to create one - but I want to skip the dialog box that the software generates, that reads I have not found any records. Want…

Hi there. I have a contacts database with names of our consultants and clients. If I just perform a "!" find, it doesn't find the duplicates. I don't know if I need to create a self-joining relationship just to find duplicates with the same FirstName and LastName. Is there an easier way to do this? The "Identifying duplicate values using a self-join relationship" section in the help menu is confusing to this newbie. Thanks.

Hello All, First off I am new at doing any of this. I volunteer with a group called U-Search. What we do is set up, organize, and run search centers for missing kids in Utah. The goup is in need of a good database system to help operations. I have started looking at filemaker 8.5 and it seems it will do what I need. First let me describe the basics that we need in the database. 1. Volunteer Registration: Tracks all volunteer Information. Name, Address, Phone Numbers, Skills, Picture, Status, Duties. Volunteers come in 2 basic types, Staff and Searchers. 2. Search Planning: Database of search information. Search Maps, Address, Search types, Notes, Map ID. Some o…

Hello, In my database (probably like many!), I have a year field for each record. The field has a value list, that looks like this: 1998 1999 2000 2001 2002 (etc. to 2006) If I want to find a range of dates, for example all records from 1998-2002, how do I do this if I have a value list? In FIND mode, it looks like I can only choose one year at a time. Please could someone tell me how to find a range of dates? --Alisun

Hello, I've exported a text file from my calendar app and have imported the data into FM 6 so that I can weed out duplicates. There are 15,000 records, and each record has 9 fields (i.e. Date, start time, end time, event, notes, etc.), some of the fields are blank. I've culled the list down to display about 6,000 records, which are either duplicates or triplicates of an adjacent record. I need to get rid of the duplicates in the group that currently is displayed. I'd appreciate any help in steping through the process to clean up the duplicates! If you need more info, please ask. I am a FMP novice and may have left out something important. …

Hi, I am having a weird find issue. Basically I have a calculation field based on a relationship with the following calculation: If( IsValid(Import_Wk3::COM_FK) ; "Y"; "N") I am trying to determine if a record has a related record in another table. the field is displaying correctly however when I perform a find, all of the records are returned. Any ideas are appreciated. -James

I have two files that use text keys defined as auto-enter serial values. For example, one file uses keys that progress as follows: A01, A02 ... A99, A100, A101 ... A999, A1000, A1001. I need to locate the "largest" key (A1001 in this example), but a simple sort does a column-by-column evaluation that results in A999 being deemed the largest. Is there a way to cause the sort to determime that A1001 is greater that A999? Or is this just an accepted problem when using alphanumric keys? Thanks for any suggestions.

I have setup my databse so it does not show the Satus Area View to the left of the screen. I have setup my search function etc, but when it goes into Find Mode, I want to be able to press a button that says Search Now (or similar), instead of having to press the Find button that appears on the Status Area. So my question is this, is there a script that I can create that would force an Enter or Carriage Return command that I can then attactch to a button? I know I can just hit return on my keyboard, but it would be a lot easier for people to use a button. Hope someone can help. Mark

So I've just imported 60 records or so. There are some values I'd like entered into every field. I realise I can go back and reimport them, but is there some way I can edit a whole found set simultaneously?

I would like someone to point me to a link or post an attachment that explains how to setup a multi-field find script (a script to prompt a user to enter find criteria in more than one field on a layout) for my database. I'm sure this has been posted before but haven't a hard time browsing the many postings. thanks.

Ello everyone, slight trouble building this "simple" find feature. I have a Master file with a portal that shows records from the Contacts file. There's also several blank fields on the Master labeled after the contact-fields I'd like to search ('Last Name', 'First Name', etc). How can I enter data into these filter fields, and have the portal automatically show the correct records? Obviously through a relationship, but how? Now in other database programs (such as MS-Access, or anything with SQL), it'd be just "WHERE LastName = gblFilterLastName OR FirstName = gblFilterFirstName...". Very simple. Is there some FileMaker alternative or trick I should know ab…

I'm using the extend found set script step to do the following: go to layout a perform find go through each record set a variable based on each record in the set count the number of results go to layout b write some data go to layout a extend found set start from previous result count go through remaining records set a variable based on each record in the set count the number of results go to layout b write some more data ...etc however, extending the found set seems to sort the records somehow, even though they're "unsorted". the problem is, I can't page through the results in each iteration because i don't know which ones are "added"…

Hi, Could anyone help me on how I can do the following: I created a party planning database where I have active bookings and completed bookings. I have a field called "Job Status" and a field called "Date of Function" What I want is to compile a find / report of all the "Active" bookings in the job status field for any bookings that are within the next 60 days. I can perform a date range find, but I have to keep entering the dates. I want something a little more automatically, so I can press a script button and will it do it all for me. In Microsoft access, I was able to do it, but now on Filemaker I cannot. What I did in Mic…

Is there a way to find records where one field in the records equals another field in the record? The matching values will likely be different from one record to another.

Hi, I am having some trouble doing complex finds using the standard finding function in FM. I would like to find all records in my database where one field is not empty (no problem so far), and where another field does NOT contain a particular value (problem!). Can I use the find function, or do I have to write a script? As a way around my problem, I sorted some records of interest in excel, and have a pared-down list of records that i would like to find. Is there a way in FM to find all records matching a list of serial IDs in an excel sheet? Many thanks, Marcel

Hi all, Lurker here...thanks to everyone who posts and replies here at FM Forum; very helpful site. Hope I'm posting on the right forum. Anyway...have a corruption issue I'd like some direction/feedback on. I have figured out that the corruption appears to be in one field; a text field that gets set when a record is created (which happens via a script). This particular field is critical to a scripted find and to several relationships. The script/find keeps failing intermittently; I go in and re-index the field and all is well for a while -- maybe a day, maybe an hour. But ultimately, the index gets corrupted again. Interestingly, the relationships that rely on t…

I have a bug database with several Sort buttons that run scripts. During these scripts, the name of the active Sort is pasted into a field so the user knows if a Sort is active and the name of that Sort. Everyone loves this so much, they want it in other databases and for it to appear when Sorts are ran manually in place of from a script. Is there an automated way to display the current Sort in a field? -Thanks, FMP Fans!

I need to right a script that will find our records by a set date and timie. A day for us is considered 5am today untill 4:59am the next day. I've got two fileds that auto enter the date and one for time. How can I tell in my search to find the records that belong to that day. It's the time part that's getting me. I'm now thinking that I should have a time stamp field, would this help. Thanks Devin

I'm looking for duplicates in a number field, using "!" and constraining to the found set. What it seems to be doing is finding duplicates in all the records and display those that coincide with the found set! ie: in a set of 300 records (of 19,000)the "!" is finding, say 230 records when only about 10 are duplicates! I've tried it 7 and 8 and get the same result.

Hi, I'm a new filemaker user (coming from Access)and I have a simple question: when I perform a query of this kind: Find records where Field1=(value1 OR value2 OR value3) AND Field2=value4 in access is an easy query, in Filemaker 8.5 I only succeeded in doing this by writing a script that says: find recorde where field1= value1 AND Field2=value4 find recorde where field1= value2 AND Field2=value4 find recorde where field1= value3 AND Field2=value4 but it's very long (I have more than 30 values to put in OR inside field1). Isn't there (I'm sure there is but i couldn't find it) a simpler way to do that??? Thanks a lot Bye from Italy…

I'm trying to set up a layout that will enable the user to select reports and enter search criteria for these reports. My approach is that this layout has a number of global fields on it (e.g., report name, date of service, principal investigator). Each of these global fields has a drop down list showing values that are appropriate to each field. For example, g.reportname shows the names of all the layouts for each report I have created. Another example, the drop down list for principal investigator shows the names of all of the principal investigators (people). I want to be able to select a value for each of these fields, and then perform a search to fin…

Hi all, I have a set or data serial A1 to A9000 now, how do you find A1 and A100 I can do it easily in google like typing "+A1 +A400" or maybe "A1 and A100" I need to do the same with Filemaker?how? Plus how do to find "A1 to A100" and "A200 to A300" and "A8000 to A9000" How do you do it? Thanks for all the input.

My original May'06 Post#204069 states: My data base has the entire name in one field, the "Name" field (data is imported from a data source), and there are multiple record for individuals. Sometimes the individuals name will include their Middile Initial, therefore FM does not see them a duplicates when executing a standard search for duplicates. For example: Smith, John and Smith, John W. are not considered duplicates though they are the same person. How can I get FM to see them as duplicates? John Mark Osborne's response was: All you really want to do is remove the middle name if it exists. Or, you could transfer everything but the middle name to anoth…

Hi all, First post for a while (that's what CCNA studying does for you).Can anybody help? I've done a bit of searching across the forums but my problem seems to be unique-if anybody DOES know of a solution, then point me in the right direction and I will gladly follow -) Please see the attached file-it is a snapshot of a larger one-I have omitted some details as it is customer senstive but the main parts are in there Basically, there are 4 columns. Column A is a location identifier, column B is a card slot no., column C is a position within the card and column D is a configuration on that C position.So an example is acto 3/0 0 33.6 acto 3/0 1 36.8 a…

I am using Filemaker 5. Is there a way to omit records from a found set?

I am hoping to find a way to Perform a Find on a data field based on the following logic: Today's Date - (some number of days) Example: Today - 14 (for 2 weeks) I have found another thread in this forum that addresses this through a script using calculations but that is not what I'm looking for. Rather, I'm trying to use the search parameters to bring up all dbase entries that have dates of the current date minus some variable (variable = number of days) Thanks, Rick

Hey everyone, Confused on a date find request. 2 tables; Quote and QuoteItem. I have a date field in the quote table to reference the quote date. Then in my QuoteItem Table I have a date/calculation field - If( Quote::QuoteID = QuoteID ; Lookup (Quote::Date) ). This does put the date in the right place. But now I want to start making some reports, it won't let me "find" and of the dates from the QuoteItem Table? I have other lookups that let me do searches and find what I need? Any help or suggestions would be appreciated.

A quick question: When I sort a field with values like 1.1, 1.2, ..., 1.10, 1.11, FileMaker returnes 1.1, 1.10, 1.11, 1.2 etc, Is there a way to do the regular search which will return the values like 1.1, 1.2, 1.3,... 1.10, 1.11? Thanks for youe help!

I have a file that has been in use for almost a year now. Today I go in to do a find and it tells me that there are no records with that criteria. The field I am performing the search in is a drop down menu list of suppliers that my company uses. I use the same drop down list to fill in the field. I have tried copy and pasting from an already established record and it still tells me that there are no matching records. I have tested other fields and it seems that the supplier field is the only one not working. Everything else is fine. I really don't understand what could be wrong as I haven't changed anything in the file from yesterday, and yesterday it was…

I can't seem to make the find/replace script step appropriately. I want to remove both types of parenthesis and any dashes. I tried putting the three replaces into a loop, but either fails or it will only do the first script step. Any suggestions? I have 1.5 million records to clean up and would like remove those special characters in one shibang! Thanks.. Jess

When I receive any call on my phone I want to add this phone no automatically in my filemaker database.. Is it possible? only I need the no. if no fax no problem.. Please help me.. Thanks in Advance.. Regards, Tusif Ahmad

how can you do a search for anything on or before 210 days from current date

I have created a quotation dbase (F1) in which I have three fields, Item, Product & Price, with repeats. I have another file (F2) with the same fields which are related by "Item". The F1 has a dropdown list for Item, from F2 "Items". Product is "looked up" from F2, conditional on "Item" in F1. This works for the first line of the repeating fields but subsequent lines are controlled by "item" in line one. Is there a way to force a lookup based on Item in each line? Thanks, Bruce

I have a script that I am using to do a find where a search term is taken from a join table and put into the search field in the parent table. The search term is put into a $variable which is put into the search field in the Find Mode using Set Field. This is all part of a loop through a series of search variables. My question is how can I put in the term so that it is an exact search? For example, the desired search term is 'tablet' and tablet gets set into the appropriate field, but the find results include anything with tablet in it (eg tablet, chewable). I tried "$variable" , """& $variable & """ and that doesn't work at all. …

Hello. I am creating a database that contains peoples birthdays. In each of the reccords there is a field for their Date of Birth, and for the current date. I have created two more fields that will take the day and month out of the above fields. so, i am left with The field "Birthday" with "20/4" in it. The field "Current Day plus Month" with "30/8" in it. i am trying to perform a find that will list any reccords that has the same date in the "Birthday" and the "Current Day plus Month" fields. (This has to be done using a script) ------------------------------------------------ so, i currently have: Perform Find [Restore] (T…

Hi All - I have a question.... Does anyone know for sure if there is a performance benefit to performing a find on local fields and then using the Constrain request to find data in a related field? When it does the find on the related field in the Constrain request, does it only search through the found set of records from the first request or does it still need to search through all the records in the table?

This might have a simple solution... I have used calculated fields to "label" data fields on my layout. Various reasons to do this, mainly to have the flexibility to format with colour depending if the fields are required: this will change as one scrolls from one record to the next based on some values selected. It looks great in Browse mode, but the labels dissapear when we go to Find mode. I have created some regular labels (placed behind the calculated fields) and they do show during a Find (I don't care about colour during Find) It is not great because now the Browse mode show labels that are not as sharp as before. I am not attached to this soluti…

I have a database of 400+ patients. A researcher that I work with has a long list of patients names in an excel file, and he wants me to check to see whether or not we already have each of these patients in the Filemaker database. Does anyone know how I could do this type of comparison? -Alisun

I have a calculation field that has nothing in it but "get (foundcount)". I am trying to get the number of found records. I see right in the side bar, found = 5 but the field remains empty. What am i missing?

Hello everyone, I have some trouble searching for email addresses. If I search for [email protected] no resuts will be shown. Whereas if I just search for 'name' or 'domain.com' all the results will be shown. i am grateful for any suggestions/ideas.

Hi. I have a record called sale transacrion (talking about B2B business) I have there a field of the company that we sold TO and I want this field to be a drop down list taking the values from the existing table that stores companies data - I want the drop down list to take its values from that table's "Company name" field. how should I define that (field & layout) thanks alot.

I have a database I want to find duplicates on the field Item Number, I then want to delete the duplicate records leaving only one and take all the numbers in Quantity and add them together. Here is the link to the file. http://simprix.net/exportbom.fp7 exportbom.fp7.zip

Hello All This is a proverbial Newbie question. My database contains 500+ articles all of which have several criteria (simple value list dropdown menus of existing records). One of these is a Year field. I know users can use the "..." to search for a range of years but this is not obvious enough. My prefered solution would be two Year fields, one marked "DateFrom" and the other "DateTo" with dropdown value lists for each. All this in Search mode of course. If anyone could show me the right direction on this that would be great. As a refinement it would b great if the value list "DateTo" would only display values ≥ "DateFrom" valuelist choice and, even …

Hi there, How do I highlight the search criteria? I know this question has been asked many times before, and the answer has been to look up the databasepros website, but having not an ounce of scripting or programming knowledge in me, I can't figure it out. Can someone help me? All I want is to be able to have a button to highlight or bold the search criteria in a found report, and be able to clear this. My boss is coming back from overseas in a week, and I've been trying to figure it out in 2 days, beginning to get very stressed. Please help thanks.

Hello all. I'm a complete newbie to Filemaker so this question may be a stupid one. I could not find the answer in the Filemaker Help, so I'm asking here. I need to find all records that exceed a specific amount of characters. For instance, I would like to find all records that have more than 15 characters in the "name" field. Is this possible? If so, how do I go about doing this find? Thanks in advance for the help.

Newbie question ... I'm using a database with a creation date field, and a modification date field. I'd like to find records that have been created or modified within a specified number of days, and then create a script for this. Can anyone help?

Wanting to use a Database field to calculate its value from another Database field called "Keywords" by finding a keyword. If(Keywords = "Business"; Company; Last Name & ", " & Greeting) However, if more than one word is in the field "Keywords" the result is negative. How can I search the field "Keywords" and get my desired results?

So I am trying to do a really simple find in a calculation field. I want to find all the records where the qty field is greater than zero. The problem is no matter how I try to enter the criteria I keep getting records where that field is zero, But it is only finding some of the records where the qty field is zero. On one client it kept finding the same 28 records with a zero qty. On another on it was finding 32 records with a zero qty. I am scratching my head. I even went so far as creating a boolean field based on if the qty was >0. the field works and displays the correct information. But when i use that field for a search i get the same set of records incl…

I have a date field in my database that has dates corresponding to pretty much every tues, wed, thur, and fri of the last couple of years. What I want to do is export all the records where the date field equals a day that was a tuesday between june 2005 and june 2006. Is there an easy find I can do to just get these days? Any suggestions? This is a Filemaker 5.5 database.

I'd like to make my FM Data base available to clients so they can see the progress of their jobs, but I don't want them to see jobs other than their own. I've started by adding a script that filters the job list to show only their jobs, And by restricting viewing privileges to records for their company. SO, when they logon, they see a list of their jobs. IF they are clever enough to select show all records, or perform a find, they see their jobs and a lot of records. Is there a way to intercept user initiated finds, or show all clicks and insert a filter into the process that continues to hide other job info?

Hi, I've a database that has test sheets each with a serial no. The problem is that this is the second year of testing and there are test sheets with the same serial for 05 & 06. I want to do a comparison between the 2005 results and the 2006 results. Can someone put me on the right track, as I'm going round in circles! Many Thanks, Skip

What I am trying to do is to have a user enter what week they would like to filter on in a message box and have the script perform the found set bases on the input from the user. Can this be done?

My Filemaker Pro 5 script has a "Replace Found Set" option. I would like to use this same method in Filemaker Pro 7. What is the equivalent script from FM5 to FM7?

Sorry if this is an easy questions but I have tried to figure this one out. I have a real estate database. I am trying to search by a max value. I have set up a drop down list with different price levels ($25,000, $50,000 etc). I have tried the max value script but its not working. I am sure its operator error. Any help would be greatly appreciated.

Hi, I have the following problem: My clients can buy apparel and footwear, or only one of them. My question is: how do i find clients who bought apparel (X) and footwear (S) --> they are stored in the same field eg: Smith X 110 pieces 2000 euro Smith S 220 pieces 3000 euro Jones X 100 pieces 1800 euro Jack X 80 pieces 1600 euro I'd like to find only Smith, since he bought both category's. So it comes to: multiple criteria in the same field. Thanks for helping me out. Cheers, Snake

I am trying to write a script that would let me search for a particular phone number in 4 different fields (home phone, wk phone...). thanks

Is there a way I can use PHDBase in File Maker? I usually use a visualfox database that can perform search using phdbase. I dind´t know much about it so I googled for it and this is what I´ve got: "Phd Base gets its name from its fuzzySearch capability allowing the user to type in (say) 'Krysler' and get entries that include 'Chrysler' Furthermore you can use the fuzzysearch to return a list of words which sound like Krysler ordered by closeness. You can search for numbers, foreign language words, and use wildcards. For instance the above search could look for words that sound like Cry*. The search syntax is very flexible using either a command or Sql statement". …

I hope this is right area for this question. Anyway, I have a layout designed to be a printable report. I have set it up to group the data, and it works. When I use find mode, whether manual or in a script, I lose the grouping on all layouts for the table where I performed the find. I have tried using Show All Records to fix the problem. It shows all records, but the layouts still will not display the grouped data. If I make a new layout with grouped data based on the same table, all the layouts are "fixed". I am very confused about how the find mode should effect the layouts. Any help would be appreciated. Bill

I need to search a database of over 15,000 records to find email addresses that contain the @ symbol twice within the field. The second "@" is not immediately next to the first "@". I cannot figure out how to get this search in correctly. Any help is greatly appreciated. Thanks in advance.

Hello, I am very new to FileMaker and to databasing in general. I have started a new job in a school where we keep student discipline records in a FileMaker database. Each new school year we clone a new file. We currently have 7 years of files. When we get a request to check if a student has a discipline history we have to open each file, go into Find mode and search for the student's last name. I've just begin playing with FileMaker and have made a much more visually appealing layout for us to work with next year, and now my very impressed supervisor would like me to find a way to search those past years' files from within the current year's file. I …

I have just started to use the Anchor Buoy model for all of my reports, which I generally have really liked. Everything was going great, until I tried to do any type of report with a fair sized amount of data. My specific example is a backlog report for a manufacturing company. I am running a find on all Open Orders in my Order Items Table, then list them out with the Remaining Qty. Nothing fancy going on here, but with 100k records, it takes over 15 mins to run, then summarize the total. This is of course, unacceptable and could never be used by anyone in our production environment. What is a reasonable solution to this other then not using Anchor Buoy …

hi guys i posed this question a few weeks ago now if i do a find and this comes up with 10 results and i have a field called result which shows different number values ie, 1, 3, 4, 1, 12, 9, 3, 2, 15, 1, how can i get to count all the 1's in this case the answer should be 3, i had a couple of replies, but nothing that worked fully what i need to no is if this is possible or should i rethink my data base grateful for any advice thank you

i have a date field (dd-mm-yyyy) in find mode how do i search for specific a specific year only or month only, thx

I need a script to find all the dates within a current month? I have a end date to a subscription. I would like to pull all the dates that end up in that month. Example. End Date 8/2/06 I need all the dates that are in the same month. I need it to be dynamic. So if I am in the 10th month then it would need to find that. I guess it is base on Today function. Thanks for the help in advance.

I have a very simple find need but I can't seem to figure it out. We have a music data base and all that I want to do is find all songs that start with "a". Either "A Dark Night", "Another time" or "Abacrombie". When I do a find simply with a in the Title field I of course get every song that has an a anywhere in the title. If I do an =a find I get any title that has a single a within the title. Thanks for your help, Mitch

In Find Mode, the user can add multiple find requests, much like adding records in Browse Mode. But once that find is performed, those requests are gone as far as the user is concerned. (I understand the last-used find request criteria can be accessed by a script.) I want to provide a means by which the end users can choose to store their own sets of Find criteria. That is , if they set up a complicated Find with multiple Requests, I want them to be able to avoid having to set up that same set of criteria if they need it in the future. What would be the customary approach to providing the end users that kind of feature? Many Thanks, JET

I would be grateful for your help. I have a database of applicants. The tables I am concerned with are as follows: table Applicants table Specialisations table Stages table ApplicantStages Applicants are related to Specialisations by fkSpecialisationID. Table ApplicantStages is a join table between Applicants and Stages related by ApplicantID and StageID. Applicants go through an interviewing process consisting of several stages (Sift Progress, Sift Reject, Interview Progress, Interview Reject and so on). They pass through each stage or they don't. All this works well on the Data Entry layout with Applicant name and Specialisation. There is a…

maybe this is just simple but can't figure it out. i have a search script with Perform find as last action. when i click on the script, it runs but before i get the result of the search i must click on the continue button on the status area first. what i want is to show the result at once without clickin that continue... thanks.

I want to be able to have a field that will look for a specific record in a table. I would like for it to be a live search (meaning as I type it is filtering down to the specific record ID) in this field. When It has uniquely identified it, I would like to hit enter and then the record and its related records appear in the portal. If I was doing this in MS Access - I know a bad word but one with which I am familiar - I would create an unbound control that would lookup a record and select the record and its associated records in the related table. Can someone give me the structure to follow to replicate this. I do not like the idea of using find to do the same thing.

My apologies upfront if this question has already been asked... In FIND mode, I haven't been able to do find searches in fields that have value lists. I've had to disable the value list in order to do the search. Is this correct? Or is there another method for doing a find search in a field with a value list? Thank you, Alisun

is there a command or a special way to enter two different find requests into a single field....i want it to show all records with A and B but not C. how would i manually acomplish that?

I have a calculation field set to show results in text as well as am using GETASTEXT(text) to ensure that the result is text. Now my understanding is that Filemaker uses the first 100 characters in a duplicate find when matching criteria My two calculation results are 218200620592206sbccabelasvisatelephonehousing (for record 1) 218200634772134sbccabelasvisatelephoneother (for record 2) These are not 100 characters long, have no spaces or symbols but when I perform a duplicate find using the exclamation point ( ! ) as a symbol in this calculation field I get these two records as a result Am I missing something? I also did a word count to verify tha…

I have looked and cannot find anything on identifying duplicates in a given field. I have a field called Symbol. I'm trying to isolate those symbols that only appear once. Many appear twice and I want to print a list of symbols that only appear once. Can anyone help? Thanks!

Alright, I've been turning to here more lately than I'd like, but I've just been having brain melt-downs... must be the newborn-lack-of-sleep thing. Alright, it's a simple thing, really. I have a script that wants to find for a record that contains a ValueA in a FieldA and omit the records that contain ANYTHING in FieldB. The best way I can think to describe it is: If FieldA == VariableA AND IsEmpty(FieldB) Display records Seems simple. What everything seems to be doing is evaluating the first part (FieldA == VariableA), displaying results then somehow displaying every record again (including what was filtered out already) and evaluating the s…

I'm new to FileMaker, but have coded in other DBMS' systems quit a bit in the past. I am building a small database app for my partner for all her bills as a learning exercise in FM before I start to use it for work. The Bills table has a field "Date Paid", and I would like to show her (on a tabbed form), only those records where the "Date Paid" field is still empty. (I don't want her to have to enter any "Find" parameters.) Any assistance will be appreciated.

I want to perform a search for multiple data in one field. How do I do that? Any help?

I had thought I'd understood this, but it appears it won't do what I want this to do. Let's say I have two files - Players and Games, there's a join table called PlayerGames. I have a portal in Players that lists all the games that player has played; and a portal in Games that lists all the players that have played that game. I want to click a button in the portal - for example, in Players - that will take me to the ONE record in Games for that game -- instead, Go to Related Record only takes me into the join file. Is there a way to do what I'm trying to do? Thanks! Chris

Hi there, I'm trying to create a sort of 'reports' view for my database showing counts of certain records based on various modification dates. Right now I'm recording dates and times opened, canceled, and completed. Where I'm getting stumped is in figuring out how to count, say, the records containing open dates within the past 7 days, 30 days, and six months? If someone could help me figure out one, I'm sure I could do the rest. I've looked at the posts in this forum, but don't see one that seems to solve the same question. If that's not the case, though, please point me in the right direction. Thanks so much for any help!

Hello All I've been tryng to implement a search summary field that would return: "Results of your search for 'Red' and 'New' and '1999' has returned 299 items" I've tried with a SetField script with calculation which sets a "Search summary" field with contents of the Find window. This returns nothing when run as part of a Find script but runs OK in browse mode. All I need is the values entered by the user in Find mode. Any ideas? Thanks

Hi all, I have set up 2 tables for a property management tool. The first is tenant information, and the second table is billing. I have generated a number of invoices in the billing table for the tenant. The two tables are related through a "tenant id" field. What I'd like to do is perform a find of all billing records, and pull up only those relevant to the specific tenant. So if I am on the tenant profile page, I want to write a script that goes to the billing table and pulls up all the records that pertain to that tenant only. This is a find command, but I can't figure out how to perform a find where the criteria is an exact match to a field in the ten…

I am trying to sort my database in a list view by a date field. But not all the fields are populated and not all of them necessarily will be. Is there a way to sort the list by date (ascending order) and ignore the empty fields?

Noob question here. How do i create a button that'll take me to the last page I came from? I have a page that users might access from anywhere within the process and I need the button to take them back to where they came from. thanks in advance.

I need to calculate a percentage achieved for bands based on their target number of gigs per month and actual number of gigs. The Target Gigs is a number field eg 7 The Actual Gigs is a Count of Record ID (shows by artist in layout part) So I am trying to calculate % achieved by; (Actual Gigs / Target Gigs) * 100 But is is bringing back really strange numbers. If I replace actual gigs with a number in the calculation to check if it works it calcalates fine so I assume it is because I am using a count field to try and do the calculation?

:) Does somebody know what reason could be for FM Advanced to take me out of the application when I execute a script that contains the perform find option or I choose the "find" option manually? It didn't happen in FileMaker 7 never before. I cannot explain it myself, and I am wondering if it has happened to someonelse? The solution was originally created in FileMaker 7. Tks,

I posted this in the schema section, but maybe it belongs here instead... sorry for the duplication. *** I have sort of a difficult challenge I've taken on for my first project. Essentially I'm writing my own family tree database. The main table is the people table and all the people in the tree are in this one table. I've defined separate relationships for parents, siblings, and spouses. For spouses I have a separate bridge table for "marriages". For siblings I've decided to let common parentage (either with one or two parents) be the defining characteristic of a sibling. That's the background. For parents I have four fields in my main person table. On eac…

I'm having trouble finding only certain records. Attached is a sample one field file. How can I do a find on the first word using a <>? I've tried doing something like: " FM brings up lots of other words greater than >BZ. Is FM searching on ALL the words in the field? If so, how can I limit the search to just the initial word? Thanks Susan Siegel [email protected] program_list.zip

I have a report/layout that I run when a button is clicked on another layout and is dependent of some values that the person has selected on that layout. For example on the main layout the person selected a person's name from a drop down list and a to and from date and then clicks "Run Report". If they haven't selected anything for the person's name (which is stored in SEL Agent) or the to (SEL Start Date) and from (SEL End Date) then the report runs and returns all records, this bit works fine. I am not sure how to filter the records though if one or both of the above criteria (name and dates) are selected?

From within a script, I would like to find all the instances of a certain word (defined with a variable $curWord) within a field and change their font color to blue. I have tried "Perform Find/Replace", "Substitute", and a combination of "LeftWords" & "MiddleWords" & "RightWords". Each of these methods comes with its own downfalls. "LeftWords()" sometimes eats punctuation. "Substitute" replaces WITHIN other words instead of just whole words. "Find/Replace" won't seem to change the color of the found word. Any suggestions or pointers to where I have gone wrong? Thank you all for any help you can provide. Nancy

Hi I have a field called membership which contains unique numbers. I would like to perform a range of specific finds in one go based on that field. I would like to pick and choose a range of membership records at will based on this unique membership number. I can do a range 202...210 for example, but I want to find say membership number 202,205,511 etc etc. I hope this makes sense. TIA

if i have have a field with different number values in it ie 1, 2, 3, etc how do i get to count all the number 1,s not so easy for a newbie thank you

Hi, I was given a db with a field that has a couple of options. The problem is the options are similar so when I search it returns all the possibilities instead of the ones I want. I tried the exact search, but it doesn't work. Example of categories: Red Red-Blue Red-Green How do I search for the Red-Blue category without getting all the categories returned in my search? Vandy

I do wonder how I would go about to parse sertain info from a html page, now with 8.5 and Web Viewer it should be a lot easier but how to go about parsing a page like the attached example. But it is difficult to wrap my brain about the filtering and searching through certain text in large text files. Maybe someone can look at the file and try to fill in some fields through the html. Thanks Parse_Text.zip

I have a client with a FM 6.0 database of book titles in her used book store with over 47,700 records. Recently she's been losing groups of records. This may be user error with her somewhat archaic back up system, but I just wanted to make sure she's not exceeding the capacity for number of records in Filemaker 6.0. Anyone know the limit for that? Also, if she was exceeding the limit, would there be any alerts so she would know or would records just dissappear without warning? Thanks - Tim