Finding & Searching

I have a drop down that lists employee's from an employee table. Then we have a field in that table named ActiveEmployee which is set to Yes Or No. I would like the drop down to not list all employees in the database, but only the employees that are set to ActiveEmployee = "Yes" Can Someone help me with that?

Hi, This one should be easy but when you are new its not easy. This is the crime scene: let’s say I have 2 tables, tab1 and tab2. Tab1 ID_Tab1 FK_Tab2 Name Date Tel … Tab2 ID_Tab2 Day Hour … I need to get some info from the tab 2 based on the local variable: $ID. This variable is equal to FK_Tab2 so $ID = FK_Tab2 = ID_Tab2. From the script, I need to find the record with the key $ID=FK_Tab2=ID_Tab2 and get the rest of the info. How do I find the record based on the value of $ID ?? thank you ...

I have a layout/report that is showing the all of the people and their income in a part that is sub summary sorted by the person's name so it calculates a total of there income and gst and a few other things. I want to be able to set the from and to dates to only show the calculations for these people's income between these two dates. Being very new to filemaker I am not sure how to do this. The report comes up then you click on a button that runs a script to show it in preview mode.

I have a table called Projects with a field named Project::ProjectName in it. In our database we have several projects. For a Main Menu sort of situation, I would like to have a drop down that lists current Projects and when you select one, it finds all records in that project and swtiches to a new layout. I am brand new to this sort of find script and cant figure out how to do this. Because in this "Main Menu" layout, I do not want to store any records. it is simple a GUI for users to navigate to their project and to filter the records displayed to them to only that project. Essentially it could be a button. Anyone have any ideas or thoughts? …

Hi, Does anyone know of a way to program a button to behave the same way as the hitting the Return or Enter Key. I have a Find function in a layout and I have the status box closed so users can't see it. Once they enter the criteria into the field for the search I want them to click a button to initiate the search. (Most of the users in this place won't know to just hit the Enter key on their own.) I want this button to be the equivalent of hitting the Enter Key. Any help is greatly appreciated. Thanks, Kevin

I have a table of event records. Each event is scheduled for exactly one day of the week. I want to find the set of event records for Mondays or Wednesdays or Fridays (or, in general, any combination of any number of days). Can this be accomplished with a single Find request; say, using a multi-key search criterion for eventDay? (When I tried it, it didn't work, but that doesn't prove anything : .) Or does this require a series of Extend Found Set requests, like other 'OR-ed' criteria? Thanks.... Chap

I have a script that does the following: 1. Enter find mode 2. In a loop, create a series of find requests, each in the form: "==" & (some data). The total number of requests can be in the thousands. 3. Perform find In filemaker 6, the find took a negligible amount of time, but in 8 it takes several minutes (even when the number of requests is just 100 or so). I've discovered that changing the requests to use "=" instead of "==" results in a quick find. That may be OK in my case. Still, it is somewhat mysterious why fmp8 is so incredibly slow compared to fmp6.

I'm having a problem with a simple find problem. I have a user who when they do a search they get results that make no sense and when I do the same search I get the correct results. The user logs in with access with limited access to the table but the records she is searching are all with those parameters and she can view normally. The Database is 50 MB and filled with confidential info so I can't upload. But the summation of the problem is there is table1 with a bunch of fields but if I search of table1.agent="smith", table1.status="active", and table1.daysleft="0...15" I get 21 records and if she does the search she gets 2 of which one has 20 days left. Please if t…

I imported an ascii file into Filemaker 7. One field is a long text field that has carriage returns. After the import into Filemaker the carriage returns were replaced with the text /n/n. I want to bring the carriage returns back. I tried the find/replace function but I can't seem to put a carriage return symbol into the replace box in the dialog window. Can this be done? Thanks, Tom

Hi all! I have been struggling for DAYS with writing a find script to do what I believe should be fairly simple. I’m building a property management database. I have two tables, Tenant and Lease. These two are related via the Tenant ID field, present in both tables. When in the Tenant layout, I can press “create lease” which creates a new record in the Lease table and copies over base tenant information including the Tenant ID. What I want to do is from the Tenant layout – create a button that says ‘view lease” such that it references the tenant ID number in the tenant table, goes to the Lease Layout page and finds the record that has the tenant ID tha…

I'd like it so that after a find...if there are no results...the user doesn't get the dialog box giving them the modify, cancel, and continue buttons...instead just an okay button. Just wondering where I'm going wrong. It's probably something stupid. Thanks.

Does anyone know why a find would great when the db is running as a local copy, yet when running from the server would fail?

When a user enters my "search" layout, they are entered in Find mode with several fields to perform queries on. There is a button with a script that returns the search results in a portal on the same layout. The only problem is that the layout will then show the values for the last record in the search fields Is there a way to set have these fields retain the search terms that the user entered, instead of the values of the last record?

I can find digits (#), and characters (@), but how do you find letters? ie [a-z][A-Z]

Hello. Beginner Here! I'm hoping someone here can help me with creating a simple script to perform a date range search. I'm using FMPro8 on Windows XP. The script I'm trying to learn how to do would start by clicking a button, moving to a new layout that has a date field formatted with the calendar popup, which would be the beginning search date, then move to another calendar to provide the end date. Then execute the search range. Thanks in advance for the help.

I am new to file maker, so please take it easy on me. I really need to create a sort of time card database. We have a database of office tasks that need to be assigned to employees. Then we would like the employee to "punch in" when they start the task, and punch out when they are done. There are certain tasks that we need to track how long the task took. Can anyone recomend a starting point for me to research or have any examples of how i could do that? Thanks Rikk

I have this database set up so that it has software and non-software assets. There is a radio button that indicates which one is which. When it's in browse, my next/previous buttons change the layout accordingly. Right now I'm working on a button that will search the records, find the software/non-software records, and send only the matching records to the print layout. Say print software records...and only those get sent to the print layout. If anyone can help...I'm finding the sequence a little confusing. Thanks.

I've been trying to use "Find/Replace" to find records in which one field is entirely empty and put "No" in that field in those records satisfying the criterion. What is the parameter I want to "find" ? Please keep in mind this is the functionality accessed by "Edit > Find/Replace > Find/Replace" not a simple Find. This might fall under "Stupid Newbie Questions" but I can't seem to do it, and although I'm occasionally accused of stupidity I'm not a newbie to FMP8. The FMP8 Advanced help menu isn't really helpful. Jess

I'm trying to do a Find script where one of the first steps is to Go to Related Record. If there is a related record, then the script runs fine, but if there is not a related record, then Filemaker seems to ignore the script step entirely and the rest of my script gets hosed. I'm try to get Filemaker to report that there are no related records so that I can take the script down a different path (ie. Show Custom Dialog Box stating "no records found). I've tried using Get ( FoundCount ) and Get ( RequestCount ), but these don't seem to do it. Can anyone suggest a way to have Filemaker report no related records exist? I sure would appreciate any advice anyone might offer. Th…

Hello, I have the following problem. I am trying to find duplicate records in my database. However, diferent from all the posts I have read where usually you want to find duplicates by a specific field like SSN or phone#, I have the following scenario. I have an online survey where the respondent does not identify himself. All the fields I have are the Timestamp when the submission happened and each question a,b,c,d,e....y,z. What I want is to find records that a person submitted twice, usually I identify that when all the answers are the same and the timestamp is really close together (a couple seconds apart). So I need a script that finds duplicates …

Hi. I have a db which lists people, classes and attendance in 3 separate tables. Currently I have about 20,000 people 300 classes and 12000 attendance records. The people table has a calculated field which counts the number of attendance entries which are marked as 'attended'. I need to be able to search for people with a certain number of attendance records but it has become very slow to do this search! Any ideas on optimizations?

Hello all I have a database (FM 7, PC) with art objects and I would like to adjust my search function so that it sorts the data (using a unique code) after finding it. Right now, it shows all the found data in no apparent order and I have to use a sort script afterwards. As others will use the database as well (who might even know less about FM than I do), it would be much more convenient if the sorting was integrated in the search script. I've tried to add the sort function to my search script but it didn't work so far. Can anyone help me with this? P.S. I'm not posting the search script as it is in German, but if anyone needs it in order to help me, I …

I have a table of organizations, each with an OrgID and also a ParentID. If an Org has a Parent, the ParenID field is filled in with the OrgID of it's Parent. Thus, I can model an ownership hierarchy. What I need to be able to do is perform a query that, given an OrgID, will return all of the lowest-level children of that Org. i.e., it needs to follow every possible branch down the tree until it hits the bottom. It then needs to list all of the Org records that it finds from that lowest-level. Not every branch will be the same lenght. i.e., the number of records down to the bottom child will vary on each path. I assume this will require some scripting, right? …

I work with mentally challenged people. I have training criteria set up where I can record the number of prompts required to perform a step in a task. This is recorded daily on paper and entered in a cumulative format at the end of each week. State reviewers think this data tells them if the consumer is making progress on his training objective. I want to show what the cumulative scores are for the last week of the month on the record for the first week of the next month so I have a reference as to whether the scores in the first week of the new month indicate progress, maintaining or regression as compared to the last week of the previous month. How do I do this?

I am using a self relationship to identify unique records based on several field entries. A simple calculation field sets text to equal "unique" or "duplicate" in each record based on the ID of the records found. This part works OK. I then use a global field in another table - with the text "unique" entered and relate it to the calculation field above but the portal displayed gives unpredictable results. Sometimes it shows nothing, sometimes it shows both unique and duplicate entries. The attached simplied file illustrates the problem. Can anyone identify where I am going wrong. Jim unique_lookup.zip

Greetings, I need to have statistical calc field which can count up the number of records that have a certain value in a specific field. Example: field= Student::ethnic possible values= asian, caucasian, black, hispanic I need another calc field which will total each of the different choices in the found set (Student::Cstat_ethnic). Can you help with the If/Case statement to make this work? I have several other fields to do the same with, but if I get one working then they should all work to create dynamic stats on the found set. Thanks in advance.

I'm trying to do a find which will display only numbers which are greater than or less than a comparison field. For example, I have API scores for schools from 2004 and 2005. I want to do a find which will show ONLY schools which made a gain in their API from 2004 to 2005 or, a find which shows only schools which decreased in their API scores from one year to the next. I'm sure this has to be an easy solution but I can't seem to find a way to get this to work. Any help would be appreciated.

Hi! I wonder if there is a way to show just some data from a table in FM? I have a table with all our sales and I want to show just the 10 best selling items. How do i do this? Regards Joakim Sjöberg Johnér Images

Hi, all. After a couple of wasted hours, I've finally figured out that this sequence works: Enter Find Mode [] Set Field (the field I want to sort on and the value I want to use) Perform Find [] Can someone explain to me (s-l-o-w-l-y) what on Earth the "Specify Find Requests" and "Edit Find Requests" dialogs are used for??? Many thanks!

I have the need to pull only the first 5 instances of a database based on a keycode. For instance, the database is approx 75,000 records, there are 12 different keycodes. I'd like to pull the first 5 occurances of each keycode and export to a separate file. (a Sample data file for lack of a better term).. Before I go struggling with this, I thought I'd ask. Thanks for any help that can be offered..

I am getting inconsistant results when searching in an invoice items description field where " is used to denote inches. If I remove the " in the search phrase I find all my records. The user creates the invoice line item by choosing from a drop down value list that is from the product description. Creating the line items works fine. When in find mode the same layout and the same drop down value list is used so the search text is the same. In some searches the result is no records are found. If I remove the " from the search criteria the records are found. This problem started after migrating from v6 to v8. It would be nice for the users to be able to continue to us…

Hi, How can I force FM to automatically select a certain field when doing a find request? I have set the tab order so that the field I want is listed as #1, but if I have been in another field prior to initiating the find request, it does not take me to field #1. I then have to tab thru all the fields or take my hands off the keyboard and click on the correct field. Not a big deal, but i have to do it often. thank you !

This winter, I completed a resturcturing of our company's big flat-file database, separating the various companies and contacts into proper entity-specific tables. We are a book business, so 3 example entities would be: Publisher, Vendor, Printer. Say a user knows a company name, but is not sure if they are classified as a Publisher, Vendor, or Printer. Using relationships and portals, I am able to find any/all exact text matches that occur in any of the 3 entity tables... What my team is looking for, however, is something more like a Google search or individual FMP find request, where they can enter a fragment of a word and get all matches across all 3 entity tab…

Hi to everybody and excuse my for my not-so-good english : I've a database (without portal) that must import records from an excel file every month.. (but this isn't the problem..it's just for explaining : ) I've just one table, and I must obtain that after a search in a drop-down menu (with 9000+ text records), in the second one I have just the records linked to the first ones... If I can and if somebody's interested I can also attach the file, so maybe you can help me in the best way you can... Meanwhile, I wait for your answers... really thanks to everybody!! :thankyou:

OK, I'm sure I'm being really stupid here but... How do I find, for example... "Silverstone" in a field but not "Silverstone Two"? When I enter "Silverstone" as my search criteria it comes up with both records where I only want the one that is just "Silverstone" Please help, it's driving me insane! Thanks. Elsie.

I am sure fm can do this, but i am yet to solve it. I have been able to set up a relationship value from 1 file to another. But what i want to do now is, depending upon the value in the above field, i want it to display only values from that record. Lost ya?? EG. file 1: [unique ID] [numbers]Repeating (30) file 2: [file 1:Unique ID number] [file 1:numbers] This is the value list i want to display ONLY values from the record that is selected in the [unique ID] in file 2. I can get the file 2[numbers] field value list to display ALL records [numbers] but not ONLY those that are on the same [unique ID] record. Any help appreciated …

Hi, I've created a field in my invoice layout titled "PAID" with a checkbox value list of just a single value also just titled "paid." What I'm trying to do is put a search/of find for all my invoices which are not paid (and thus the PAID box/field unchecked), but I can't put out a search function with an unchecked value field. Any ideas? I only want to have to x out the box if the record/invoice has been paid, rather than having to deselect a secondary "unpaid" box from the value field for when an invoice does get paid. *I noticed that with any new record I go to after I check the box that it becomes highlighted with a thick black border that goes away a…

Hello, A "DataEntry" form is used for entry data. Fields on these form are: Name, DOB, Phone Number, etc. Using the same form for finding one Name- no problem. But in case when the exact Name is not known, typing C (for Cooper, Conner, etc) will display only the first find on the "DataEntry"form. Yes, Table View will show all the names starting with C. Is it possible to auto-change from "DataEntry" form into TableView Form when there are more than one record found? Thanks,

Hi Folks, I hope somebody can offer some assistance here. I have 2 tables, related by product code. I start with exactly the same records in each table, then some get deleted in the second table. I need to find out which records were deleted. The main table is static historical data, whereas the second table is a working table. All I need to do is by using the data in the main table, and a find or relationship, determine which records are in the main table and not in the second table. Probably sounds easy, but I just can't figure out how to do it. Any suggestions would be greatly appreciated. Thanks Paul

I have three tables: Person: PersonID PersonName Phone: PhoneID PhoneNo PersonPhone: PersonID PhoneID And I've established the obvious relationship links. How can I write a query so that given a person's name, I get back the phone number(s)? All the DB I learned was standard stuff, e.g., from the O'Neils' book, all theory and SQL. I'm confused about how this translates to FM. I even understand stuff like B-trees, etc., but knowing it's not helping. I hope and assume that this question and the answer are trivial, but I have been unable to translate all the FM documentation into the concepts and terminology I'm familiar with. …

My last problem never found a solution, so I thought I had a back-up. No dice! Here's my problem: I want to list items from a table and also list details about them from related tables. Those related details are not showing. It's a many-to-one relationship, so each item can only have one customer, so that's not the problem. Each Customer has orders and each order has itemized purchases. I want to show customer information without creating redundant "customer" fields in the item table, but I can't even get it to show "order#" from the order table (that's where the foreign key is linked in the item table) let alone other related fields in the order tab…

(This is my first post, so please feel free to give me general advice on how to improve my postings) Table Occurance vs Find for Portals I am having trouble figuring out the best way to filter data. I would like to list the records that meet multiple requirements. > START DATE < END DATE = CATEGORY1 or = CATEGORY2 or = CATEGORY3 ACTIVE = TRUE (or 1 or whatever) ... and so on. I would like to enter the requirements on the fly, so if I want to change the start date to last monthI will get a list and then be able to change it and get 2 months earlier. Right now I am using a portal, but setting up the table occurances (TO) is killing me.…

Any ideas on to how to automatically convert a text field into a phonetic word. Example: Filemaker = Foxtrot India Lima Echo Mike Alpha Kilo Echo Romeo I've tried using the Substitute function on this one with no joy whatsoever. Your help would be very much appreciated !!!

I'm attaching a graph of my table relationships. It's a simple model. Each salesrep has multiple customers. Each customer has multiple orders. Each order has multiple line items. Each line item has geographical (zone) designations. I need to make a report of all the businesses ordering production in each zone for a given month and their order specifications. For instance, Jan 07 will have zone A six businesses, zone B two businesses etc. I have made a list view layout linked to the zones table. Under each zone is a portal linked to the related inserts (line items) table. With this set up it does display all orders for all zones, but it wont filter based on …

I need to find how many people voted in atleast 3 of the last 4 elections, but Im not sure about how to go about doing the Find in FM8. I have seperate fields for every election, and the data looks like this: VoterID---Gen05---Gen04---Gen03---Gen02 001134---G5------------G3--------G2 002459------G4---------G3-------- The field is empty (null) if they did not vote in that particular election. Any suggestions? I've reading the Help section a few times and can't seem to grasp how to find if they voted 3 times in any one of the 4 elections. Thank you...

Hi all.. I have seen a coiple of dat searchs here but not sure why i could get them to work What I have is a date field, LastContacted and would like to make FMP to search for any dates that are over say 30 days or older from the current date and have them list on start up as a reminder... once contact is made or an email is sent the date is updated and shouldn't come up againt for another 30 odd days... so my question is what is the formula for a date search to find all dates in that range.. i tried date ranges but it don't seem to work, and got myself confuddle i know can be done and must be pretty simple.. im just not that simple : Enter…

I am a beginner, I just started using filemaker yesterday. I am making a test run right now using the photo catologe template. I have all sorts of keywords that I want for each picture, and I keep adding them using the *new* button on the keyword menu. The problem is it only displays/allows me to see the top 12 or so and I can't click on the other ones. My question is how do I scroll down and see them all? Any help would be much appreciated thanks. (also forgive me if this is in the wrong Topic)

Sorry guys, but I am new to this forum. My question is : I have a time, say 7:20 AM and want to see if it is within a rage of {7:00 am..10:00 am} . Am I missing something or there is a easy way of doing this in a script step. Thank you Xoomaster

With FM7, the next question. If I have 2 tables: BOOKS with field AuthCode and global field gAuthCode AUTHORS with field AuthCode joined one-to-many on AuthCode from AUTHORS to BOOKS. I have a form with gAuthCode on it. This shows a dropdown menu of the AuthCodes from AUTHORS. User choses one of the authors form this list. I now want to make a script finding all the BOOKS from that author. I can do script step PERFORM FIND, but there I cannot give a fieldname gAuthCode as a value, because only plain text is allowed. How can I make a script step to filter only the BOOKS from the author in gAuthCode, after which I eg can print a list of thes books?

How do I search for dates in this format I have a database with various dates and I need to search fields that contain a date, however I need to let it search for dates that are 1 year ago. For example you sign up to my company as a member and the membership lasts 1 year, so i need to find out which ones are about to expire how do i do this. Thanks Tim

Can Filemaker use filters for searching ? Example A search box and a list of checkmark buttons linked to databases that are called up into the search results when the check box is checked. Example 2 I search a portion of text in the search box, and then press the filter buttons to restrict the databases to look in, Free, Commercial, press. ... And it returns these databases in the layout. They have the same layout and database fields. I have tried this kinda thing in the past to no avail.

I have a field called "MD", which has a long list of doctors. Some are listed by initials, some by last name, and other variations. I plan on making this consistent. But first, I'd like to print out this list, to see exactly what I'm dealing with. Is there a way to print the Index ? Thanks, Alisun

I have a large database with over 50,000 records. I have a Word file with my notes organized in (mostly) free form text in paragraphs. When I display a record from the database, I would like to (run a script to) check in the Word file and have the relevant paragraph(s) containing that search term displayed in a field. The word file is less than 100KB, so one option may be to import it as a field into every single record in the database. But that still leaves the problem of identifying the relevant paragraphs without an additional search. Is this possible?. Thanks so much. SD

I have a layout (viewed in list mode) that shows a date field and a customer name and details. I would like to have a quick way to quickly find a group of customers based on the date field. For example at the moment the layout shows every record and I have set up a button to show all the records that date falls in the current month . I would like to set up a button that advances the month shown and another button that advances the year by one (I would also need a couple of buttons that decrease the month and date by one). I Have also setup a couple of drop down menus to select a month and year but I don'y know how to to link these with a find command so when I select th…

I have patient database with "name" text field and "report" text field. I need a script or whatever, that notifies me that the new patient "name" was there before and to generate previous reports that i can browse easily in the preview mode. Thanks

I am trying to figure out why the second name in a hyphenated last name does not show up in a find. For example, Tofte-Dorr does not show up in a find for Dorr. Is there a way that I could modify the find to include the hyphenated ones? Any assistance would be greatly appreciated.

There is probably an easier way...but... I have a schedule system that worked well until they needed to have jobs extend over multiple days and asssign hours for each day for the same job... I changed the workdate field to a repeating field and a maximum of 3 repetitions (as no job is supposed to be more than three days). I theen created a custom dialog that would allow the user to add up to two more day and include the hours for those days. When I go to my_schedule view and submit find requests, it will find this record on all the appropriate days..except it shows the first repetittion. How can I show the same record on the schedule for each day of the…

here is my problem. I have 2 portals 1 which has a YES criteria which shows positive things and a NO portal which shows negative things. I do not want to do a specific search on positive values but I want to search only on negative values and return the omiited...so for example if one record said this: PORTAL YES UK USA AUSTRALIA PORTAL NO FRANCE CANADA If I wanted to find values for CANADA the above wouldn't be shown since it is defined in the NO. However if I did a search for Germany the above would be returned in the search since it has not be specifically defined in the NO and so is a possible record. This is a easy search to do sinc…

I'm a Driver Ed teacher using FMP 4.1 (Don't ask. That's what they gave me?) I use FM to manage my Driver Program. I have a need for a formula that will subtract a constant date (3/15/04) from today's system date and will yield a number. In other words, the number of days that have past between 3/15/04 and today. Thanks,

I would like to find records where the last letters of a name are the search criteria. For example: by searching on "th" the returned set would contain both Smith and Forsyth but not Thomas searching on "ez" would return perez and martinez but not ezra Any ideas?

I have a dedicated search layout set up with a multi-line text field for searching addresses. I unchecked, under field behavior, the options to go to the next field using return or the enter key. In find mode, whenever the user hits enter in this field, instead of going to the next line, it submits the search and tries to "find." I don't want that to happen because I have a button on the layout that should perform that function. What do I have to do to make the enter key start a new line and not submit the search form?

This is a real newbie question, but I don't find it in the Help or searching the forum. I have records that contain from 1 to 5 people adult1 firstname lastname email dayphone evephone adult2 firstname lastname email dayphone evephone adult3 firstname lastname email dayphone evephone junior1 junior2 junior3 junior4 How would I search to find a record that contains anyone with the lastname JONES or phone number 123-4567, keep in mind a record might contain, for instance, ONLY a junior1, or adult2 and junior1, etc., tia, jim

I have a database with multiple fields. I need a script that finds records containing the entries similar to entires of the current record. [color:red]Ex: Two fields are: First_name and Last_name. I create a new record and enter for example JOHN (first_name)and Doe (Last_name). I need a script that finds the previous records containing John doe in either fields Thanx

Hello All. I am a FileMaker newcomer, so please excuse my ignorance. I am trying to do something in FM that I am sure could be automated, but I don't know how to do so. To put my problem in the briefest possible terms, I need to replace the contents of Field A in File 1 with the contents of Field B in File 2 IF the value of Field C in File 1 equals the value of Field D in File 2. In other words, I need to compare a value from File 1 to a value in File 2 and then, if they do match, take the value of a field in File 2 and place it in a field in File 1. I have tried writing a script for this that compares the values of the two fields that need to match, then r…

I have data that were entered like "abc/xyz" or "abc,xyz" in a field. When I do find for "xyz", it doesn't find all those records with a / or , in front of the string. Is there a good way to find those records? Thanks SM

Im working on a contact management system, where once a person is entered, one of the options is to select one of four values from a value list. (First, second, third, and fourth). The field name is simply "quarter". The problem Im having is how to search for these records. For example Jane Doe is going to ref in the first period. Im want to send out a reminder letter to Jane to show we have her down for that time. The letter isnt the problem, its getting only her letter to print out. Currently if there are 5 different referee's in the database 5 letters will print out for each one of them. Im just trying to single this down to one person. Any help would be appreciat…

Ok i have just started to use the find function of filemaker to make it easier to find certain records. My problem is that once i have found the record i was looking for i cannot get back to the entire database with all of the records. It shows a total that is greater than 1 or 0 but i cannot navigate back to them. I have even tried deleting the record that find finds but i still cannot get back. Any help here would be appreciated!

A friend of mine has filemaker (not sure of the version at the time) but now has v8. Anyway to make a long story short, he didnt have any backups on his home contact database, so im trying to figure out a way to help him build a new one. Basically my request is pretty simple, im having problems using an "if", but maybe is should be a "lookup" instead. Im completely new to filemaker and honestly I had never even heard of this database program. Basically (using the contact management sample) as an example, I added 4 radio buttons. (first, second, third, fourth) basically each one of these would stand for a period of time. Under the contact management once a perso…

Strange scenario in my solution...I have a db that was written in FMP7 and we are now on FMP8 (server advanced). Table: Reports Field course_name = calculation of courses::course_name_long (text) Table: courses Field: course_name_long = text field I have a layout based on the Reports table with several fields. When I do a find on the calculated field "course_name", I always get the entire database as my found set. It acts as if I've searched for "*". The field displays correctly on the layout with the proper related value, I just can't search on it. This seems to happen with any field that is a calculation from a different table. If I m…

Anybody seen this before? We're running a fm server 8 v3 on win2000 server with about 100 clients (FM8 on WinXP Prof). Every now and then (say once every two weeks) every search from every client on every unindexable calculated field returns zero records while we know it should return something. When we restart de server, everything seems to work again. It's a mistery... Any help would be very much welcome.

Hi guys. I searched the forums on this, but either this hasn't been dealt with or I typed the wrong keywords. I'd appreciate your help... When working with a large list of domain names, it is sometimes useful to order from shortest domain names to longest. I have a FMP database with thousands of domains. Is there an easy way to sort the domains by record length? Thanks, Tim

Hey All! I am new to the site and have been working with filemaker just a few months and love it. Wanted to know if someone could help me with what is probably a simple question. I have a data file and I need to find about 100 different zip codes within that are inthe file (there are about 3000). Is there a better way to do it than just manually entering each one, adding a new request, entering again, etc? Your help is much appreciated! :

I have a data file and I need to find about 100 different zip codes within a DB(there are about 3000 total zips). Is there a better way to do it than just manually entering each one, adding a new find request, entering again, etc? FYI _ I am copying them from Excel. Your help is much appreciated!

I have voter registration file with individual records for each voter. My problem is that I want to combine records with the same address into a single household. But before I can do that I will need to analyze the voters in the same houshold and categorize them. For example" Jane Smith 123 Rocky Road Democrat Mike Smith 123 Rocky Road Unaffiliated another category would be: Bob Jones 111 Fire Road Republican Tom Jones 111 Fire Road Unknown And so on...I have about 5 different scenarios that I want to categorize. The eventual output needs to be one record for every address with a category code that defines the voter combination in the house…

Hello I am new in this Forum. I have a group of records and I would like to count them. I already count the total but I cannot count by a field. EX. how many records has "xxxx" in supplier field? In excel I used count if function but I cannot find any similar here. Thanks in advance carles

I had a customer call me and I need help from Filemaker Gods (all of you). When she imports a certian single record it imports the wrong record. When she does the exact same thing on a different machine it worked fine. She tried it like 5 or 6 times and everytime it pulls the wrong record. What do you think?

Hello, Is there a way to make a conditional count using a single script ? For example: Count ((Invoices::Balance) > 0 ) The above line is not accepted. The intension is to count all records whose balance is non zero. Of course this could be done by setting a seperate calculation field as a flag and then counting the flags .... but can it be done more elegantly by script without introdusing new fields?

I have a medical record database that includes a patient demographic table linked via a medical record number (one-to-many) to an encounter note table. I am attempting to create a list of all patients not seen within the past 90 days. I have filtered my notes by date to include only those notes from the past 90 days. Then, I filtered the resulting found set by visit type to include only those notes for patients seen for a face to face evaluation. From here, I have not been able to create a list of all medical record numbers not included in the current found set. I certainly look forward to and appreciate any help that you may be able to offer. JLKoch

hi, I am looking for a sollution to find "contract" in the field subscription. This field is filled by using a value list. not a search like = "contract" but a search like field contains "contract" hope that I am clear thanks for your help emma

I've been trying to use a Global Variable to specify one of my search criteria in scripts, as demonstrated by the following examples. THIS WORKS (returns only Basin records) Enter Find Mode [] Set Field [Table::PlantID; "Basin"] Perform Find [] AND THIS DOESN'T (no error, but returns all records) Enter Find Mode [] Set Variable [$$ID; Value:"Basin"] Set Field [Table::PlantID; $$ID] Perform Find [] Can someone tell me why it doesn't work -- or suggest an alternative? What I'm trying to do is load $$ID with the contents of a Logon::PlantID field (located in an unrelated table) in a central script and then use it throughout my report s…

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?

How can i find a date range from todays date plus 30 days using a calculation in a script.

A problem which has started in the last week or two. I can no longer find invoices by number. My Invoice numbers are serial numbers, (of number type) starting at 1. When I input a particular number, which I know exists I get back no records. If I put in the find "> 0" which should find all the invoices it only finds the ones in the last two weeks roughly. My first thought was that somehow the numbers had been changed to text so I put in an extra field defined as a calculation GetAsNumber(InvoiceNumber) and then when it had calculated converted it back to a number field. Fnding using this field works as normal. The next step was to replace all the InvoiceNumbers by…

Hi. I have a Contact database which lists everyone in their own record. I need to extract a mailing list which will omit students ( I have created a student checkbox field which will allow me to do this) but to also somehow combine the two parents' names as the mailing contact even though they are in their own separate records. I do have a portal which allows me to see who it is that have the same home address. I figured that the home address would be indicative of 2 parents. So, how do I create a script that would allow me to (after I omit the students) grab the two parents names and put them in the proper format. Eg. John and Jane Smith OR, what if t…

This is my very first post here. This is what I got so far: Copy [select; Main::Procedure Number] Go to Layout ["Procedure Report" (Procedure)] Enter Find Mode [] Paste [select; Main::Procedure Number] Enter Preview Mode [] Print [] Go to Layout ["Assembly" (Main)] Enter Browse Mode [] I know that I am probably going about this all wrong. The current problem with this script is the user has to press enter or click on the button "Find", where it would be nice to have the script just click find for me. My main layout "Assembly", has a Portal with related records. The layout "Procedure Report" is a list. Why I didn't post this in the …

I'm sure this is so simple, but I've never done it before! I want to find if a number field has more than 9 characters entered. Is it a find or do I have to set up a calc field? TIA, Kate : P.S. This question is for FM 6, I work in a school district where we are in the process of switching to 8!

Periodically we must reconcile the accounts we have with the accounts our client says we have. Generally we get a file from the client in Excel that lists, among many things, an account number. In the past I have imported the client data into FMP and just compared what they have to what we have by looking for duplicate account numbers and then reporting on the difference. This ends up causing our caseworkers a lot of work because they will then manually look up each account that is different and report on them. I would like to just be able to report what the "status" on each account the client believes we are working using our internal status codes and some notes that are…

I have 3 tables: Intake, Echo Tracking, and Echo Results. I would like to create a calculation that will add a certain amount of years to the [color:red]echo next field based on a [color:red]patient most [color:red]recent Echo Date and Risk level. Case#_Grid# is the primary key which is unique for all patients. The database should only look at the most recent echo date for each case#grid# and add the number of years based on the risk level onto the echo next field. This value should also appear in the portal. If patient has risk 0 then the next echo field should be echo date + 5 years. If patient has risk 1 then the next echo field should be echo dat…

I modified a Filemaker layout to insert the domain names i have and the Expiration date, to know when i have to renew them. The problem is that when i go to "List" view, and i click in Sort By.. it does not sort them by time.. i seached for the Bottom options and it says sort By "Price"... and if i put there Date.. it does not sort nothing. Another question.. the file is 3.05MB.. Why is so big if it only has 4 fields of text? Thanks!

I am trying to get to work two situations 1) How to find in interactive and scripting mode numbers in a field different from CERO, do I have to make two request one > and one < ? I am needing exactly to find 6 fields whose contains are different from CERO in each record. 2) Based on a month request (01, 02, 03 ..12) I need to search a field with the name KONxx where xx is the month number (KON03 for march) every record with values different from CERO in that record.

hello all, i don't quite understand the search criteria, is it true that it can't contain variables or am i doing something wrong? i want to do a search, and than after that search is done, do another search where all the found are deletes from the search example: i have 65 people working in companies 20 are working at company x 35 are working at company y 10 are working at company z first i want to search all the people that are working for a company, in this case company x After that search i want to exclude the people that are working at a specific department, in this case sales deparment. so all the people are shown that work i…

Hello everyone, i'm wondering if i can delete records automaticly after a period of time (let's say 48 hours) anyone knows a function for this? thx in advance

Yep, the title says all. I have a list of 500 names. How can if find quickly which records that contains ONE OR ANOTHER of these names ? If it was a list of 20 I would make a script, entering them one by one. But 500… is there a way to perform a search with a value list ? I'm stuck… Heeeelp!

ACtually my fmp works with mm/dd/yyyy i wanted to change it to work as dd/mm/yyyy Thanks a lot!!!

I am trying to set up scripts that will omit records where the date field (RTKDateDone) is less than one year from the current date. It would be ideal if the find could look at today's date and subtract a year (or 365 days) and find anything less than that. Is there a way to do that without making the user type in the date? In the find requests all I can seem to do is choose the date field and put a static date in the find request in the script. I created a field which gave me the current date minus 1 year (learned that from a previous post), but you can't use fields in the find criteria. I have many date fields that I need to create similar scripts for a…

I need help to see if a calulation would work but I don't know if creating a script is my only way to accomplish this. Here's my dilemma. Each record in my database has 26 individual text fields that contain a number. Then there's another text field called the "target number" that has a number in it. The question is, how do I create a new calulation field that will select a number out of the 26 individual text fields thats closest to the target number field. Thank You for Taking the Time In Reading My Question.

Hello all, I'm just a simple user of filemaker for a single database that I'm building for myself - Magazine database with names of editors and contact info etc. What I'm trying to do is specifically locate the names to certain editors to certain magazines so that I can print them out on my Label layout. My problem is that I can't seem to get them all on to a single convenient sheet(s) and if you read how I've got mine organized perhaps you'll understand and maybe find a way for me to do this efficiently. For my "Magazine" database I keep one record for each magazine with multiple fields for each "Editor" contact. For instance: Rolling Stone magazine…

There're 2 tables: - 'Years' contains 2 years (for example) - 'Sum for Year' contains a fild with Numbers. And a summary fild -- Total of all these Numbers. And of course there's relation between these tables. The task is: to get Total (in 'Sum for Year') for the Found Set 'Year'=2005 (f.ex.) in 'Years' I'm a novice & cannot find any information how to organize this operation. Thanks. test.zip

Hi! How to show omit state if record is omitted in find mode with status area locked? And also how to show number of find reqests (like "find request 1 of 3 total" )? Thanks Dejan

Boy, do I need some help. I receive in a text field an email header such as: Name: N.Smith TAG ID: EEN-0558 Email: [email protected] Subject: General Question For an email reply, I want to be able to automatically pull the email address out of the text field and set it to another field (the send address field for an email reply.) Can anyone please show me how to parse out just the email address so I can populate it in another field. THANK YOU SO MUCH IN ADVANCE FOR YOUR HELP. I'm under a terrible deadline, so thank you. Bob