Finding & Searching

I was wondering if there is a way to have users save their own founds sets without using scriptmaker? Each found set will then get saved to a separate record. I have seen examples where you can use "copy all records" to a serial number field but this is capturing records not the actual find criteria. I don't want static found sets. Under this example method, if a user saves all 12th graders, then any new 12th grader that gets added after the found set was created will not be included. Is there a way to capture the find criteria and save it to a record so that the found sets can be dynamic? (using Dev 7) Any help would be appreciated!

I have a statement that has about 675 lines that I have imported into FM7. I am trying to create a report that will should the number of records (lines) based on different dollar ranges. Example: Range Records Amount 0 - 100 539 $14,250.00 101 - 200 78 6,350.00 201 - 500 45 8,550.00 > 501 8 9,450.00 Total 38,600.00 I need some guidance/suggestion on how to make this work. Thank you. Elliot

Ok, someone tell me I am not losing my mind! I have a solution, developed in 4, migrated to 5 and now 7. One of my reports is now not working and I am trying to fix it. The report has a find critera that searchs for "Balance" > 0. "Balance" is a calculated field set to ( "Sell Price" - "Invoice Total" ). Both "Sell Price" and "Invoice Total" are related fields. In browse mode, when "Sell Price" and "Invoice Total" are the same, "Balance" shows as 0. This is good. The problem is when I do a search, either manual or from a script of "Balance" > 0. It returns tons of records where "Balance" shows as 0. To make it worse, when I search on "Balance" = 0, I get so…

After performing a find in Table X, I cannot get LookupField_1 in Table Y, which looks up a Summary Field in Table X, to reflect just the summary of the values in the found set. As an example, Table X lists weekly rental amounts. Table Y generates a report that lists total rental amounts per month. After performing a find in Table X for December, Summary_RentalField (in Table X) gives the total for that month. However, LookupField_1 in Table Y, which looks up Summary_RentalField, still gives the grand total of all weekly rental amounts - not just those in the found set in Table X. The match fields in the 2 tables have the same value for all records. This us…

Hi, I'm new to FM and FMM, any help you can give will be appreciated. I used to use Access and was probably a novice user with that. I am building an inventory db and am trying to write a script that will alert me when product levels are low and when I need to re-order. The on-hand field and the re-order field are in the same table. Using the SM I was able to make an alert script with pop-up dialog box. I am now trying to figure out how to capture the items (records) that need to be re-ordered, so I can make a proper report to print-out. Right now, all the script does is let me know when to re-order, it doesn't tell what needs re-ordering or how many to order…

I currently employ a method of selecting an individual for a task by clicking on the individual field which opens the search database, goes to the individual search / selector layout. This layout is a portal showing all the individuals for a particular company. When you click on the desired individual, it takes the individual_ID and inserts it into the tasks database. I have the same for selecting companies - click on the company ID field, it brings up the search "pop up" window, shows via a relationship all the companies for that area and you click on the one you want. What if I want to extend the access to the "pop up" search / selector across all my database …

Hello, In Find mode I often need to search on a date range, say, 10/1/2004 through 12/30/2004; or I may need to search for all records after or before a certain date, for example > 3/1/2004. But I get an error if I enter anything other than an actual date or "..." in a date field. How do I get Filemaker to do a Find based on a date range or a comparative date value? Thanks! rlbryant

I am very new to FM7 and trying to write a script that will find a set of records based on a criteria, then copy that set to another Table in the same database, and then delete the records in the original Table. Can anyone offer any guidance, I have hit a wall trying to figure out how to get this to work. Thanks Elliot

Hello All. Does anyone know an easy way to find a large number of records? I would like to copy and paste about 500 values from an Excel/Text file and search one field in my DB. To do this individually would take hours. I'm not so adept in Scriptmaker, and imagine this would be one way of doing it. If anyone has suggestions, it would be greatly appreciated. For clarification I'd like to search one field for something like A11, and C22, and F51, and...etc. Thanks, John

Hello, How do I do a Find that will get all the records where a particular field has no value. I tried just clicking in the field and hitting Find but get an error saying I have to enter a value in a particular range. In this particular case I want to find all records where a particular date field is empty. What do I type into the field to indicate "no date"? TIA! rlbryant

I am a newbie and have some problems. I want to check, after I added a new record, if in all already existing records two fields a) "Product" *and* : "Seller" contain the same values as in the newly generated record in "Product *and* "Seller". If that is so I want that the field "version" in the new record goes up one number compared to the higest existing number of "version" in a already existing record with the same values in "Product" *and* : "Seller". Product, Seller and Version are number fields. E.g. Existing records: Record 1: Product = 1, Seller = 3, Version 1; Record 2: Product = 1, Seller = 4, Version 1; Record 3: Product = 1, Seller = 3, Version 2. …

Can I apply a font/style/size to an entire found set???

Hi. Filemaker is actually used in my company on Mac's & PC's (Panther & XP). I am supposed to tell everyone how to use their computers, but I never use Filemaker, so I have no clue. Someone here just did a search for something and didn't know why the results weren't sorted by job #. So I showed her how to sort records... but is there a way to save sort preferences?

Using Version 7. I have a table with 3 types of clients (Inquiries, Transitions & Clients). Some of these are inactive. I need to make a script that will: 1) Find all the "Inactive" records (using the field: [status]) 2) Omit the records where Status is = to "Inactive" 3) Within this found set, I'd like to find all the records that are "Inquiries" 4) then let the user input any other find criteria using fields on the layout What they should end up with is records that are "Inquiries", not "Inactive" and have a few other perameters that they specify. Thanx in advance for your help.

Hi, I have a field that is basically a check box.... how do I search for that in find mode? Vandy

I need to be able to sort by two methods. I'll try to explain only my isolated problem. I have one type field set to be either A-E with multiple values possible. The other field is a title. I want to sort by type A,B,C,D, or E then by alphabetical title name. However, if the record type contains a C, I want it to sort by title only, not by type. The reason is because I have a series of information that needs to be shown in a sequential order. An example follows. Any suggestions? Senators of the Nation - Type A Typecasting - Type A Ah Quon McErath, A Hero's Story - Type A Unit 1 - Type C,D Unit 2 - Type C,F Unit 3 - Type C,E Unit 4 - Type C,D…

Hi all: I've just run across a strange thing in a solution a client has been using for a year or so now. There is a calculated field which produces a job number in accordance with the client's long-standing practice (in the format ("Q-yyyy-mm-serial number"), and there is an automated Find built into the system. It has just come to my attention that searches using wildcards do not function, meaning that "Q..." returns nothing. Searches for exact matches come up okay. Is this due to the calculation? If so, what's the quick workaround? Thanks in advance Stanley

Hello everybody, im a new filemaker user and i need som help putting my searching togheter. Its a system for a realestate company and they want to see at witch dates their apartments are rented or empty. I have one field called "fr

Im fairly new to filemaker have been using alpha5, im stuck! I need to perform a find against numerous fields, the type im getting stuck with is the date fields. Im looking to perform a scripted find on a sales related table. Include Text Field ="T" (ok) Include Date Field (date Invoiced)*(those with dates entered, works ok) Exclude Date Field2 (this is the bit im stuck with, help suggests just putting in an equals sign and thats it to say the field is blank, does not work though.) Also want to get a total of the sales value(numerical field) within this find, have tried using a summary field to calculate but again its spitting our ant unrelated …

Has anyone seen this? We have databases hosted with FMServer 5.5 on 2000 server. I have a simple script to find some records and summarize the data. Running with a Jaguar client on FM6 it takes about 5 minutes, running the same script in Panther client with FM6, takes 60 minutes or more! Confirmed that it was panther by running the same script from another Panther computer, same problem. Any ideas? This message is posted in the server forum also.

I have a postal address field, the content is stored in one long string, each part of the address field is seperated with a small outline square character. I want to convert this to carriage return so that the address feild appears on 3 lines rather than 1 long line.

I have a field named "Regions" in which there is one region named "South England" and another "SW England and South Wales". When I do a find on "South England", the find is returning both regions, presumably because the word "South" is in both. Is there a way of finding only exact matches? I had presumed that the find would only find the region which begins with "South". I have solved it temporarily by changing "SW England and South Wales" to "SW England and S Wales" but would prefer to go back to the original if possible. Any advice much appreciated.

I have about 20 layouts using 10 tables with an average of 20 fields per table. What I'm wanting is the ability to go to a single layout, (search layout) and be able to perform a search for information from one or two fields. I have about eight different name fields, I have caller's name, victim's name, defendant's name and so on. I'm thinking I can make a calculation field that auto enters all the eight field contents into one field which I can search. My second field would be a more generic field and contain comment fields, narrative fields, and just about anything else with the exception of dates and times. The second field would operate the same but deal with…

Hi All, I'm sure this has been discussed before, but I couldn't find it in the archives. I'm on a Mac, OSX, FMP6. The databases are being served with FMPServer 5.5 on a Mac G5 Desktop. I have two files, Defendants.fp5 and Checks.fp5. One to many relationship. While working in the Defendants file, I need to perform a Find which includes one related field from the Checks file. The find parameters can include defendant's zip code or address, warrant outstanding, warrant not served and that the check is "active". The Active field lies in the related Checks file. The longest I've let the Find run is 15 minutes before giving up. I've made sure all indexable fi…

Hi, I have a application which recieves invoices from people who we have to pay. These people are in companies. so i have an invoices table, an invoice Line items table, a Project table, a ProjCompany and Companies table. The companies table is used in the invoices to do a lookup for the company. A project can have one or more companies working on the project. so Ihave a 1-M for that. the line item then does a look up for the project given a project number. I then enter an amount. I then click 'Save' and I want to somehow update the ProjCompany table's field Status to be paid for all the records that match the CompanyID and projectID in the ProjCompany …

Hi My question is how can you produce a list of values, without any duplicates? I've tried using the ! exclamation mark find symbol with the 'omit' tickbox selected but that omits any occurrence of duplicates. Say if there were four company names the same you would not get any of them. I want to generate a list of company names from our database but with each one appearing only once. Is there an easy way to do this? I've never been able to work out the search syntax for that. I realise I could set them up as a value list based on the company name field but I'd like to know if it's possible this way. Also it means the company names are sorted…

This is what I'm trying to do: I want to perform a find. Perform another find. Go back to the records the first find found. I don't know if this is possible. If so could you please tell me how. Thanks in advance.

I want to be able to detect a changed value in one field and populate a second or third field. Example: Current Income, Previous Income, Net change. when the Current Income field is changed, I want the original current income moved to the "Previous Income" field and the net change calculated as the difference. I can do the net change. I need to be able to detect the change in the Current Income (without losing the value). If the values of the 3 fields are: CI = 10000 PI = 9000 NC = +1000 now if CI is is changed to 15,000, PI should automatically calculate to 10,000 and NC should calculate to 5,000 (15000-10000). If CI is not changed then PI and NC …

The title sounds kind of funny (at least to me). I have a master-detail relationship. In both of those tables I have a creator_name - the person who created the record. I select the name of the creator from another table called authors using a drop down list. Pretty standard i think. I'd like to have a layout with a menu list/popup containing the authors and a portal, which will contain Master records. When I pick an author from the list, then the master record which contain that name for an author appears in the portal - the really tricky part - or at least not obvious to me (sorry) - IF the master record has a detail record with that same author name, then s…

I have built a solution for my medical practice with a main table "Patients" and among others another related table "visits" (related via Pt_ID) with all the patient's visits. I want to produce a report with all the information for a particular patient (from the "Patients" table) on the header and then all the visits of this particular patient on the body. I tried using a portal, but that restricts the number of visits on the page. I thought I could perform a find among the visits, using this criterion Visits::Pt_ID=Patients::Pt_ID, or better still, copying the Pt_ID to a global field on the "Patients" table and using the gPt_ID for the search. The I could just so…

I need to write a database, Where when the database starts up will alert us to anyone who has a Birthday , Wedding Anniversary ONE Week BEFORE the event , Using BDATE ( for birthday field date) and WEDDATE ( For Wedding Date), I have searched this forum and can not find anything that answers this question, any help please! --------------------------------------- I have also wrote another database, and need to search it for :- When the OUTSTADNING field is YES and the INVOICE DATE field is 30 days and/or OLDER than current date, again any help please, i have tried various methods and no joy!! :-(

Hi, When I perform searches, I end up with a list with contact info of people that match my search criteria. I have created a button script, so I can e-mail them just by clicking the button next to their e-mailaddress (opening a new message to the recipient in Outlook Express). What I would very much like is to be able to mail all of the people on this list at once. I would like their addresses to be in the BCC-field, and my own e-mailaddress in the TO-field. Is this somehow possible? What kind of script should I use? Thanks! Cindy

A co-worker of mine entered some data into a field for several records then did a find on that data (single word). No records were found. It is a shared database so she had me try on my machine. I found them with no problem. I thought she might be entering something wrong, so I watched as she did a find, and sure enough, no records were found. I had her close FM and re-open and then the find worked. This shouldn't have to be the solution. Anyone have any ideas what would cause this? FYI- We have installed the latest 7v3 updates.

This seemed so simple... but then it always does for us rookies Here is what I want to to do. I have written a small invoice program. I may turn in 5 or 6 invoices to one client before any of them get paid. When they do get paid they are all paid with one big check. What I have done is create one file called "invoice: and one file called "check". The thought being that one I recieve a check I go to the "check" file, enter the date, check number, amount, blah blah, and also the invoice numbers that that check pays. Then I hit a submit button and it opens the "invoice" file and finds all of the invoice numbers from the "check" file, after that it would fill in informa…

Any suggestions please! I have created a db with a field 'DateStarted' in a 'Projects' table which directly = data from a 'DateStarted' field in an 'Hours' table (logging users' work sessions) in the same file. This is an indexed calculation field determining the min date value from a range of datestamp fields. Because the former only relates to the latter, it can't be indexed itself yet it forms a part of a calculation for a 'ProjectStatus' field that is integral to many fundamental find scripts. These take on average 75 seconds - waaaay too long. How can I speed these up? Thanks in advance!

I have eight fields named: REGO1, REGO2.....REGO8 All of these are on my Customer Information form. They are customers car registrations. I need a way of entering a car registration once and it searching all eight fields. Is there a better way to do this? How do I do this? As well as REGO1 - 8 there is also the colour and model for each car as a seperate field I.E. REGO1 REGOCOLOUR1 REGOMODEL1 fields for one car. How do I set up a script to search all of these fileds by entering the rego somewere just once to find it. Jason [email protected] [color:"blue"]

I have a script that runs on the first of every month. What I want the script to do is to find the records that are older than three months. Because not all months end on the 31st, I have no idea how to do the query. I think it should be roughly <= Status (Current date) - 3 months and 1 day. Any ideas on this one? Thanks!

In Find Mode, is there any way to display the status of the "Omit flag" (for each request)? I have the status bar hidden on all my screens, I know how to turn the OMIT flag it on or off via a script (Omit Record script step in Find mode), but can see no way to show the user the status of that flag in of his.her each Find requests. Thanks for any insight. Cheers, Justin

hi, this might be very simple, but I'm just learning (and I have been searching for an answer for a while!). How can I find based on whether two fields are identical or not? That is, I want to be able to 'find' all records wherein two particular fields are identical. Also, one of the fields is a portal. I've tried various things, but nothing seems to work, and it seems it should be really basic. Help? -dez

hello, I have a main layout, which contains a button that calls a script which does a find. in that script , among other things, I basically switch to a layout which contains the records fields in it and have a Enter Find Mode [Pause] and let my user enter some criteria, they then can hit the enter key and Perform Find[] is called. Based on that If I have > 1 record I switch to a list view layout and let them pick the one they want if the recordCount Found = 0, i ask if they want to find again and give them another go if the recordCount Found = 1 then i switch to the 1 record view layout and let them work with the layout there. My problem is that i hav…

How do you perform a logical NOT? I'm trying to detect if data is present, so was thinking about putting 'NOT "?"' in a date field. Any ideas?

Hi, I have a solution where I have to do finds on a description category. If I am in the field, then go into find mode and ctrl ' to set the field, I get no records found. Is there something about punctuation that makes it not work? When I modify the find and take out all punctuation, it works. It is very frustrating when you know there are records with that description.

Hey team! Here's my current "hmmmm...how can I do that?" scenario. I'd like to see if I have any decent idea how to do it before starting to create something that may or may not work. I want to my user to be able to have the last generated job record number appear in a pop-up window or list when they are creating a new job record so they can determine the next job number to assign without having to leave the record they are in. (And, no, the job record numbers cannot be a auto-generated serial numbers in case you're wonder. That would be too easy.) So my theory is to have the client code that the user just entered be copied into a search field and a find be gen…

I have a db set up with a relationship. I have no problem with the relationship but when I try to query the data using any of the related fields I get bogus info. Is there anyway around this?? I want to set up queries and then summarize this info. Thanks for any help. Shannon

I am sure that there is a very easy way to do this, but I cannot figure it out. Is there a way to omit the found set upon creation of a new record? for example: All data entry is done on a specific layout. There is a button to create a new record, done through a script, is it possible to omit the record you just left when you create the new one? Thanks in advance for any advice Len

This may be obvious but, is there a way to create a new record when a related record cannot be found? Thanks for your patience.

Is it possible to write a script to leave records out based on certain criteria? In this case, I have records of people, but some have the status INACTIVE. I already have a working script to search for certain records and have them displayed in a new layout (thanks to Quintech, Jerry) but now I want to add something to this script so that the inactive people are left out in the search results.

I'm working on a script to import Invoices and their related LineItems from a small, "staging" database to my main database. The staging database contains Invoices and LineItems tables, just as does the main database. [Note: I'm using relational terminology ("database", "table") but this IS a FM6 database] The script, running in Invoices_Main.fp5, imports from a previously-created found-set in Invoices_Staged.fp5. No problem there. But then I want to import into LineItems_Main all LineItems_Staged records that are related to records in the found-set of Invoices_Staged. - - - I guess my problem really isn't about Importing as much as it is this: given a fo…

I am new to FM7. I understand databases and have done most of my work in SQL Server, MySQL, or MS Access. I am trying to move one of our databases to FM7. It is very possible the layout I am attempting to use is foolish for an FM7 database, and I am more than happy to change that. Let me describe what I am trying to do. I have 3 tables right now. 1) List of all employees in the company. 2) A table that consists of EmployeeID, EffectiveDate, Salary. 3) A table of all valid paydates. I require 2 views of this data. 1) For any employee, look up their salary history. This is easily accomplished with portals, and works great. 2) The ability to look up any paydate, …

Hi, I'm new to Filemaker, so I might not use the Filemaker-language yet;-) I have two layouts, A en B. Both layouts have some of the same fields but also some different fields. I put some records in layout A and these automatically show in layout B since it are the same fields. But in layout A, I can check a box to see if someone has long hair (for instance). Now I want to make a new layout, which will be the first layout. In this layout I want to make a few buttons, the first button is for layout A and the second button is for layout B. BUT (and here's the problem) I want the records shown in layout B to be only those records of the people that have long hair (so th…

hey guys, this is a really driving me nuts! Im still battling away trying to find a way of performing AND searches in portals. The only way i can see of doing now is this.. perform OR finds on the related table (actually from that table layout). Then to filter the list i need to omit the records which don't match all the criteria. I.e only keep records where the number of duplicates is less than the number of OR requests in the search. Does that make sence. Obviously im still open to any suggestions as to an easier way of doing this. A screen grab of my database can be found at http://foxmurphy.destinet.co.uk/screengrab.pdf Here you will see the main tabl…

Hello All, I have two separate lists of data, List A and List B. I want a new field that tells me (yes or no) whether or not each member of B appears in A. Note: this is easy in excel: simply copy the following formula along side list B: =countif('$list$A','memberofB'). The lists are too big for excel. Any suggestion or comments on how to achieve this in filemaker would be very much appreciated. CHEERS

I want to do a sort ignoring empty fields; ie I want to see all records where foodtype is starts with "A" for "apples" appear near the top; I want to see all records where foodtype is "Z" for"zucchinis" appear near the bottom, ie I want to see all records where foodtype is empty appear at the very bottom. I have no control over what users place as field values. I have tried custom value lists mentioning "=" amd "*" sort values, but nothing works. Steve

How can I perform a find for the newest date of an item with many entries in a database file and then use only these dates found for the item in a summary report? Thanks in advance for any help.

Hi, i'd like to be able to click in a contact field (which maybe is a lookup) and start typing a name and then have it find matchess and display them in the drop down. then click on the one i want. is there an option in fm for doing this? thanks, j__

This problem is baffling me, what am i doing wrong? i want to find records of reservations for the next 7 days. Sometimes this works, sometimes it doesn't depending on the day, I don't know what's wrong... Is there a better way to do this? If today is sunday the 14th, i want to find reservations beginning Monday the 15th to sunday the 21st if I do this find on a Tuesday, i want to see records beginning on wednesday for 7 days etc. My script is as follows: Find Next 7 Day's Reservations --------------------------- Allow User Abort [Off] Set Error Capture [On] Enter Find Mode [] Set Field [Clients::DateRequested; Let([ D = Get(Current…

So much new learning and was hoping to be pointed in the right direction. How would one begin entering a company name (partial) and have it pull in a list of matches in the related portal? FileMaker Version: 7 Platform: Windows 2000

Thanks in advance for any help. This is what I am trying to emulate. On our old DB(topspeed) we can look up a customer by starting to type their name(in a box above a list view of customers). Now it does not complete the name for me, but a list below the enter box scrolls the customer with the closest match to the top of the list (does not change order). Then by pressing enter I would go to the data entry page for that customer. (kind of like typing a K and have the list scroll up to the first K customers) I would like to do this in browse mode but that may not be possible? I am going to look at clairvoyance but many of our customers has similar names and …

Is it possible, using datafilter, to get (in my example) all of the treatment dates per name per given period in a seperate file? In my file "Invoeren Datums", you can find all of the given treatments as seperate records. This file is linked to another file "Patienten". The meaning of my question is to create invoices for one with a summary of all their treatments within a given period. I 'll enclose hereby the files. Thanks for helping me out of this... InvoerenDatums.zip

I would like a way to calculate the date 60 days from the current date so I can do a date range search on a specific field. For instance, if we used today as an example, I'd want it to fill in a field in search mode: 11/15/2004..1/15/2005 (or whatever 60 days from now is) I've never done any sort of date math before, so I'm hoping it's an quick and easy solution. Thanks!

How can I merge the unique records and changed records in New file (new sales leads) into Old file (old sales leads). There are people at different location who enter new sales leads and change (update) information on existing customers. I need to update the Old file with the unique new records (no duplicates) from the New file. Then update records in the Old file with the information that has changed in the New file. In the past I have just imported the records form New file into the Old file then preformed several find duplicates, sorted and gone down the list deleting or updating each record as needed. This take a long time! We need to keep some r…

I have a school reports database with a one-to-many relationship - one entry in the students info table relates to many entries in the Reports table (i.e. one student receives reports from several subjects) I have two (well more, actually) layouts - Layout A displays records from the Students table and Layout B records from the Reports table. However, when performing a search in layout A, it actually searches related fields from the Reports table (thus showing students in a particular class or teaching group, based on the reports they receive). However, if I move from Layout A to layout B, I have to repeat the search - there doesn't seem to be a way for FileMake…

I am having problems with the simple find part of the script. for example, I have a simple contact db with 20 contacts in it. when I am viewing any of the records manualy, for example record 17, i then want to press a button and the record i was viewing (could be a day old, a week old) will go to preview mode (all other records are omitted). I then create a pdf, and attach it to an email. And also paste copy in the email. I've got the pdf part down. And got the merge field letter to be in the email via a calc field. I just can't seem to get a record that I was viewing to be the only record in the pdf. I can search for the last name and go from there et…

i've decided to give up on virtual pc and cut the access cord, but am having some problems with trying to consolodate my large lists (voterfiles, actually) to give me only one listing per household. (essentially, i want to omit multiple residents at the same address) in access i could just do a summary query at the same zip, twon, street, house and last name, but i don't know how to do in filemaker!!! i created a "dupcheck" field consisting of the address and first five characters but once i find the duplicates, i don't know how to omit the second, thrid fourth etc. occurrence of a duplicate address from my found list. any help would be appreciated.... thanks, …

2 files contacts and company which are related. From the contact listing I want to see the listing of the related companies. I have tried setting up a layout which has the contact ID in then I have used copy all records and pasted it in to the find layout of the company. But I can't get this to find anything (I have also tried this with Company Name and company ID). Can anyone help me and tell me why this isn't working? Thanks Simon

Dear all, Strange problem, I made a migration from FM 5.5 to 7 and in some field when the user made a find the system return: No records match this set of find requests but there is records!! when I do the same request with admin account everything is fine.... The user have all right on each fields Thanks in advance for your help, and a big thx for all informations find here! Regards

Silly. I hvae text field (CHANGE). This was old audit list from another program. I am trying to find all lines without anything on the right of the dash. Finding for "(space)-" But it finds everything. ==*- ... finds half of them, some with text to the right of dash and some without?? And sometimes there is a second dash (eevn with a space on each side) to the right of the 'dash' separator. I think I might need calc to somehow specify nothing on the right of FIRST dash. Everything I have tried fails. I am attaching this file with some records in hopes of getting help. I want to delete all records with fieldname and dash and nothing else in the fi…

I'll start off with what I'm trying to accomplish (I hope this comes out clearly, it's getting late...): I have a table of lakes, with about 100 fields. Typically, there will be about 3000 lakes in the table. We're going to make maps of some of the lakes, and the research crew will be qualifying each lake individually, and will put a '1' in the "Include" field (not quite that simple, but something like that) for each lake that we decide to map. Now, the cartographers absolutely shouldn't see or be able to modify the records for any lakes that don't have a 1 in the Include field. The cartographers will have their own layout to make changes to the map status fields…

Hi, Suppose that you have a layout, which you've created to Find a list of composers. It's just like customers, you get the idea. For convenience, on that form are 3 buttons - [back to Main View], [Cancel], [save] and [Print] from the 'Main View' you have a find button there, user clicks that and they are taken to the layout I'm describing above (find_composer). when the layout appears, they are in find mode. The user 'may' decided "you know what, I'm just going back, i don't even want to find". The user presses [back to Main View] - however, my find script is sitting there waiting for the user to enter criteria and press enter to find something!.... turns out you…

Hey guys I know its pretty difficult to explain stuff like this in a forum post and i'm not sure my topic title is the best use of words, however i will give it a shot... I have a table of job candidates with a portal record set of skills for each. i.e Joe Bloggs has a related records in the table 'skills' with the following entries 'sales' and 'audit'. Now searching is where im getting confused. When i switch to search mode i can obviously search within the portal, and i can create new requests in order to have or searches based on multiple skill options. I.e I can find someone who has 'sales' skills OR 'audit' skills. However, I can't work out how …

I am writing a find script, in which I would like to specify the find request that Finds Records where table1::field1 = table1::field2 field2 is a global variable which I am using only to specify the values of field1 that I want to find. When I enter field2 into the find criteria, it trys to find values of field1 that = "field2", rather than the global value that field2 is set to. Does that make sense? How can I work around this? Any help would be greatly appreciated! Thanks

Hello. I have a question regarding a script/find that I think is most likely an easy thing to do, but yet I have not been able to find the solution; I have two databases- one is a cookbook, the second a wine list. I have created a pull-down list in the cookbook for pairing suggestions, which pulls wine type from the "Type" field in my Wine Database. What I would like to be able to do is have a button in my cookbook which opens the Wine Database (I've gotten that far) and then uses the criteria from the "Pairing" field in the cookbook to do a search in the "Type" field in the Wine Database. So basically if I have the pairing as Pinot Grigio, and I click the [find]…

I'm having trouble scripting a combination AND OR search using FileMaker7. For example: A search for all records where Parameter_1 is A or B or C, AND where Parameter_2 is 1 or 2 or 3. Done correctly, this should find those records matching all nine permuations of the search criteria (A1, A2, A3, B1, B2, B3, C1, C2, C3). Hope this makes sense. Any advice? Thanks for your help, Michael

Hi Guys Im ragging by brain here trying to work out how to do 'OR' Searches in filemaker. I need to build a search where I can specify to return records if fieldname1 = "xxxx" or "yyyy". How is this possible? Cant find any further details anywhere Is there anyway of using an SQL query string to search the db? This would be fantastic as I could build a pretty complex search very easily. Cheers Ben UK

I have one file containing reports for students in the school, [color:"red"] reports.fp5 . This will use lookups to fill in details like reading ages etc. That information is in another file, [color:"blue"] student records.fp5 . Teachers need to be able to come to the DB and type in "John" somewhere, and if there are many Johns in the school, see a list of Johns. They then click on the surname they want or the form they are in. This will refer to a unique file in [color:"blue"] student records.fp5 , and then use the ID number to fill in the relevent lookups. The teacher can the fill in the rest of the report in [color:"red"] reports.fp5 . I could just use…

Hi, I'm trying to modify a database that uses a concatenated search field to search for criteria in about 6 different fields. When I look through my results, I"m not sure which field(s) contain the search criteria. Is there a way to highlight or bold the search terms in the displayed search results? i.e. if I search for 'parachutes' and I get 10 records back, I want the word 'parachutes' to be highlighted or bolded wherever it appears in the search results. Is this possible? If so, how? Thanks.

Using a database w/16,000 records of jobs we've done. Want to sort it to make a client list, not a job list. Therefore, don't want records with the same CLIENT NAME to be found unless the data in the ATTENTION field is different. (Only want to find most current record for, say, ABC Co., and only want to find multiple records for ABC Co. if the person's name in the ATTENTION field is different from others already found.) Would appreciate any help. Thank you.

This is eluding me. I'm hoping there's a simple answer. I have a layout showing two fields; "postal codes" and "locality", both in a single record. ie Postal code "0810" and locality "Alawa" appear in a record. I want to enter that postal code into a field in a related file and have FMP7 automatically lookup the locality corresponding to that postal code. Problem is... there can be different localities each with the same postal code appearing over multiple records. So, creating a lookup will only give me the first corresponding match (I think). I want to have FMP7 show a list of localities (records) which correspond to the postal code I have entered and then be able to se…

I have a simple report card database and when the teacher logs in, the choose their name from a drop down list in the current teacher field and find their students. How do I prevent them from possibly changing the current teacher in the found set and adding one of their students to another teacher in the drop down list. I am only a beginner and am worried about teachers inadvertently changing the teacher information. Is there a way to lock that field after the records are found? FM 6 (schools are using 6,5.5 and 5.0)

I need to sort of combine an AND and an OR find request. THE SITUATION: I have a couple thousand different products in a database that contains over 100,000 records. These products are compared in groups of about 10 or 20 at different locations. The set of products compared at each location are usually different i.e. the same group of products is rarely compared at two different locations. I need to compare 2 or 3 products at a time by looking at all of those locations in which they were tested together. It is no good for me to contrast the average performance of products A, B, and C in all locations in the database, for the comparison to be fair I need to comp…

I need to set a flag field in each record of a found set to 1; then set the same flag field to 0 in the omitted set. The number of records is around 10000 and growing, and the found set is 10-20 records. What is the quickest way to do this? BTW - most records in the omitted set will already contain flag=0. It needs to be fast. (The reason for doing this is that I'm going to tell MS Word to select all records having flag=1 and generate a form letter - Word's ability to select FM records is limited to matching on a constant.)

I have a "PartNO" field and an "AltPartNo" field. I want to search both at the same time by entering the part no in "PartNo" only and finding records that match either. TIA Ivan

I'm trying to restrict users to seeing only their own records, I figured I could use Get(AccountName) but for the life of me I can't see how I can grab that info and implement a search... Their GetAccountName must match the name field in the record. Maybe I'm doing this wrong as users could find all records, but I have it set up so they have only have access to their records via Accounts & Privileges... Lost at the moment

My company sells small ads in newspapers in the southeast US. We sell the ad, and then fax the copy to the newspaper. Ads run for a number of weeks, but the minimum is 5 weeks. One problem with this system is that the only way we know when the ad starts running is to see the newspaper tearsheet. Since these are delivered mostly by US Mail, it can take 2-3 weeks before the first tearsheet arrives. Worse, we often get the tearsheets out of order. (Example: October 14 will arrive before Oct. 7 or Sept. 30). I have a FM 6 database that we use to keep track of when the ads run. Each advertiser, for each newspaper, has a record for the number of ads run on each date. …

I want to be able to do a find and then have a field that shows what was entered as the find request. For example, I do a find for "widget". I want the results to appear and have a field that says something like "Your search for "widget" returns 34 records", like you see on many searchable websites. How do I do this?

I'm starting to build a script that performs a find on a group of records and produces only those records with dates within this week, or next week. I wonder if anyone might have a suggestion, before I re-invent the wheel - I'd be very glad of any guidance at all. Many thanks, CF

Does anyone know how to add text to a found set of records approx 1700 of them ? The field I want to add the new text to, already has text in it that I want to keep. I am sure this was possible in the last DB I used. Cheers

Hello All, OK here is a newbie question for you guys. I have a conditional pop-up menu which I am auto-entering via my last pop-up menu selection. My first pop-up menu has a list of Computer Applications and my second conditional pop-up menu has a list of versions per the Computer Application picked in the last menu. I want to have the versions pop-up menu auto-enter the highest version number rather than having to go into the menu everytime to pick the highest version number. It is currently getting the right version numbers but not the highest number. Any ideas or similar post? Thanks, Galen

Hey guys need some help doing this the correct way , theres the deal Creating a seach bottun to perform the following find Dateofexamstart -> Date (global) Dateofexamend -> Date (Global) In the brower mode the only fiel how is filled with data is dateofexamstart, and Dateofexamend , is not filled with data The ideia is to perform in a new layout with 2 field's Dateofexamstart & Dateofexamend plus a script button to perform a date range and show the result of the find in the same layout ( of course with the field's that whe want to show the result ) and the totalrecords found in the rightcorner of the layout whem whe perform the script…

I have a script that does the following: ------------------------------ Goto Layout [xxx1] Enter find mode [pause] if ("case_status") <> "") <---- case status is a radio button on the search form, either 'open' or 'closed' ...if ("case_status" = "Open") .....Goto layout [xxx2] .....Insert Calculated Result ["Closing date", ""=""] ...End if ...if ("case_status" = "Closed") .....Omit Record .....New Record/Request .....Insert Calculated Result ["Closing date", ""=""] ...End if End if Perform Find [replace found set] Goto layout[xxx3] ------------------------------- Right now I'm just concerned with the 'open' case. W…

Hello guys need some info on this I make a find with this criteria : PhoneNumber = 555 social security number = 1 TestResult = 50 The ideia is to make a layout how shows the result of records that this find did and place the result in a field and shows is a layout like this example : Person how had a superior result -~ 5 Records I make a find with this criteria : DoorNumber = 5 age = 50 TestResult = "Old Person" The ideia is to make a layout how shows the result of records that this find did and place the result in a field and shows is a layout like this example : Person how is very old -~ 15 Records All in …

Hi everyone, I am making a report to find all the cases within a date range and count those records and display it. Here is the problem. I have two global fields, Month and Year, each attached to a value list having months (January, February ...... December) and year (1995, 1996,..... 2007). I wrote a script using If Else statements. Here it is: GotoLayout["layout1"] Enter Find Mode[] If["Month = "January""] Insert calculated Result[select, "field1", "DateToText("1/1/" & "Year") & "..." & DateToText("1/31/" & "Year")] Else ... ... Perform Find[Replace Found Set] It says "No records modify this search" and When I click on Mo…

How is it possible to capture the search value from a search. i.e someone goes to find and types in search for surname "Smith" how can I capture this and add it to a search list file? Thanks

I have been following posts on finding within date ranges, but they don't seem to help my problem and I am finding it very taxing! I have a report with a list of invoices and a summary of their total. What I would like is: a button to run a script to produce a summary total of the invoices for a specified date range (this would be either a certain month or a full year between specified dates). I would prefer two user entry fields to be able to enter two dates for a date range). Hope you can help Cheers :confused

Hello, I am working on a kiosk solution for a bookstore. I want the entry page of the kiosk to be a search page. I need to make this as simple as possible for the general public to browse a database of books. On the entry page, I would like to place fields for "author", "title" etc. How can I set this page so that it is always in "find" mode? I would like to put a button on each record page to go back to the "entry" page, and each time it does this, I need the search fields to be empty. Any ideas of how to write a script to make the entry/search page always in find mode? Any help appreciated, Catherine

I have two fields: City and Affiliations. Affiliations is a value list field which have values, say A, B, C, D. I want to find records based in New York AND Stamford AND with either affiliations of A OR C. How do I script this find?

We have a website running across two servers with most of the site on one and FMPro 5.5 with search and results pages on another. Has anyone any idea if it is possible to pass a parameter from the main server to the FMPro server such that the parameter can become a token used by an existing search page. The search pages would use the token as a hidden value while other search parameters are provided by the user from drop down lists. We have tried lots of different approaches along the lines of <a href=theserver/FMpro?-DB=database.fp5&token=X&format=searchpage.html> to try and provide the necessary token for the search page as well as calling i…

I have 2 databases, 1 has 43 thousand records and the other has 16k. I need to take the records from the 43k and merge them with the 16k and keep the duplicates, and eliminate the others. How do I do this via sort instead of exporting as tab sep. and manually deleting? Please help Thanks

I have created a quote database which auto-serializes everytime a new quote is created and then I use this serial number across records and tables to link them all together into one multi-faceted quote. Anyway. I'd like to make a script step where either(or a recommendation on both would be nice) 1) All other records are omitted from the beginning of creating a new quote or 2) A find (all records with current serial# as it's stored in a global, then omit all other records. This way I can have it sort and print for them with one button press. Does this make any sense? It does to me but I never seem to make sense to anyone. At any rate thanks in advance for any help.

Bit of a problem has arisen with the searching on my database. I have a separate search layout. For example go there to search for surname "Stoyles" doesn'r exist however "Stoyle" does exist. What I would like to do is trim the surname everytime one is entered. right(SurName, length(SurName)-1) Would the best approach to write in another search criteria if the nothing is found? (although not sure how to write values from a search to another files field so I can trim off) Any ideas on this kicking about would be most helpful Thanks