Finding & Searching

I swear I used to be able to find items in a related field in a portal. Now, I go into Find mode, put an asterisk in a field, and the result is very frustrating -- it says there are no matching records. Am I doing something different? I don't think so. Could it be that certain types of relationships work and others don't? P.S. This problem occurs in both v5 and v6.

I want a button that looks and behaves different in Find mode vs. Browse mode. The script was easy... if you click it in Find mode, it performs the find; if you click it in any other mode, it enters Find Mode. I want the label to be "FIND" in Find Mode, and "Found:" in other modes. So, I defined a field with the appropriate 'If' expression. I tried using a field object and I tried using a text object with <<>> notation. The problem is, when it goes into Find Mode, the text vanishes (like all fields). Argh! So, its working as I want, except in Find Mode it says nothing instead of "FIND". How do I tell it to display this field's value in…

I need to find a range in currency between a field named "low rent" and a field named "high rent". I want to search for properties within a low and high rent range. I also don't want to use the "find" view, I'd like to script it to a button to produce the found set in a portal. Any ideas? Thanks!

I have a database with 40 fields which hold scores 0,1,2,3, and 4. I need to find out how many "0", "1", "2", etc., I have in each of the fields and print it out in a report. I have records for over 9000 students. for example: I have a field "testin1" with possible scores of 0, 1, 2, 3, and 4 for 9000 students and this repeated in field "testin2" and "testin3", etc. for 40 fields. Please help

I have to perform a find on about a dozen different fields, each of which pulls from a relationship so they can't be stored or indexed. With 12.000 records to search through, the process currently takes about 5 minutes, as the "unindexed records to search" dialog box runs for each field. Anyone know a way to speed up the process?

I am using FM 4.0v3. I have two db which are linked by serial numbers. I want to preform a find in the second db using the main db record serial number to find the matching serial in the second db. I would like to perform this find using an external script for the main db. I ahce create a relationship between thw two using the serial numbers. When the button is push in the main db to activate the external script written in the second db I get this message. No criteria has been enter. Example of script in second db: Enter browse mode goto layout Enter find mode set field(field in main db,field in second db) also tried set field (field in second db, field in main…

I'm attempting to calculate the total in a line item file for under the following conditions (and unfortunately I need to have the solution in a field in a layer and not a report). Each record in the line item file contains a name, a dollar amount total (a calculation), and a pop-up list. (The name is a product supplier name and will appear multiple times). I need to find the total for each name (supplier) in the line item file by looking at each record, determining if the pop-up list has a specific selection, and then adding that record&#8217;s total to a grand total for that name. I'll try and have an example graphic of how the line item file looks here: …

The post office has corrected our address file. Using Excel, some acronyms in address lines came across in title case. Can I do a find and replace? Here's and example: PO Box 130 Sfa -- needs to be SFA. Thanks Maxwell Morlay

The post office has corrected all my zips and addresses (CASS Certification). I have these in a simple DB with name, address, city, state, zip. Now I need to get all these changes back into my original DB. Not every record has changes; only about 10% out of 8,000 names. How do I get those changes back into the correct records in my original DB? Those corrections will be made in the "address," "zip" and "zip+4" fields. Thanks so much. Maxwell Morlay

Greetings FM Gurus...I bow to your magnificence! Well as you can see I am a mere acolyte in the FileMaker universe, I come from an ancient race known as Clipper developers so I know about databases, but the paradigm of using Filemaker is kicking my priestly butt. So here is a question I pose to you. Scenario: 2 tables, a main and a related SYSTEM db --- related to ---> SECTOR db I have successfully created a form with fields from the main db (SYSTEMS) and a portal to a single related table (SECTORS). This form is used to enter data for the Systems db and also the Sector db via the portal, simple enough. As the data grew I decide…

Hello, I have a database that is used through browsers using fm 5.5, the question I would like to ask is when I go to search in web view in the TYPE option box is there any way of making it go straight to contains instead of being begins with? the second question is after the search is there a way of being able to just hit enter instead of clicking on the search button? 2 silly questions I know but my boss has asked me to find them out. Thanks for any help Chris

I am a newbie to the Forum and a newbie to FM so please excuse the simplicity of this request. I have a file with a field called Due Date. I need to create a Report via a script. I've created the report Layout..I just need the script structure that will allow me to Find all the records that are <= today's date, sort them by Due Date and display them ALL in the pre-defined Report layout that I've created. Thanks

Hi !! I just can't figure out how to make a boolean "AND" search upon the same field. Lets have a text-field called HOBBIES, now... how can I define the search condition in order to search for "reading" anywhere in the field and "windsurfing" anywhere in the field and "chess" anywhere in the field, all this at the same time, on this field?? Is this possible in FMP 5.5 ?? Thanks for any help on this

I am having problems with what appears to be a simple task but it's taking me forever to solve it. I am trying to find records on a relatively small database (~800 records) that fall within a date range. I have a conference date field and will like to find all those records that have a conference date occurring within a date range, for example 01/03/3002 to 31/03/2002. Manually, I just type 01/03/2002...31/03/2002 in the conference date field and there they are, but the user will like to search for any date range so I thought a script would be a good idea. So far I haven't been able to do this. Recently I set up two global fields (start date and end date) and used E…

I have a checkbox in a portal and would like to omit the checked items from a search. I have a script for the search, just can't figure out how to omit the checked items. Thank You.

in my main file there is a portal showing corresponding invoices in a related file. I would like to find the records that do not have (a) related invoice(s). I understand that it is impossible to perform a "zero records" find (result no records found). What should I do. Thank you for your help.

I'd like to have a trailing grand summary display in a different FileMaker file than the original layout. I've attempted to set up a relationship, but can't get it to work. Thank You

A while back I set up (what was meant to be...) a small protected area for our customers. Access to the site was by performing a simple "find" on the unique username and password contained in each customer record. The site has grown quite big (400 customers) and only now do I realise that the "find" will work on EITHER password or username (and worse still on any part of either). I tested it when I first set it up and I was sure it was secure (obviously I was very wrong!) I have added the html <INPUT TYPE="hidden" NAME="-op" VALUE="eq"> to the form, but the find continues to work as VALUE="cn". As you can imagine - I need to find a solution very f…

I'm creating a database to track customer orders for a retail business. In one FileMaker file each record represents a single item being ordered by a customer. I have fields for the unique item number as well as the unique manufacturer for that item in each record. Here's my problem, the same item can be repeated any number of times in the database (different customers ordering the same product). I need to display a summary of how many times each item appears in the database. I need to have these broken into reports by specific supplier. I located a thread about creating a summary field and then creating a report with grouped data, but I've been unable to get this to wo…

I know I have seen it somewhere in this forum -- maybe a scripting post -- I have looked all day -- Please Help! I have a child db with line items of a master record. From the child db I have created a query layout to set the perameters of a report (backlog report). The script I have created sets all 4 parameter globals to empty upon execution. The user then defines the report. All is good in tinsel-town -- how then do I take these parameters and script a find request. For instance: Customer = Ace's Towing (From Value list) - Find Report Aging = 90 Days (30 / 60/ 90/ Complete) - Find based on Calc If statement Report Type = Full (Full / Standard) -…

I have the db with 16,000 records on a fm server. I've set it the report up for users to enter the two dates (start and end) and then a paste from index to do a find on the date range and the index paste. I sat this up maybe perhaps a year or more ago and all has been fine but now there is the slow down in running the reports. What used to take 2-3 minutes now takes the 6-7 minutes every time and they have notified me of it. The only change has been the server people have updated to OS X and FM 5.5 but I think that was done before the slowdown has started. Specifically when the report button is clicked the Find dialog box appears with the "processing field Da…

Users on our database search an Address Field and a CV / Resume field and want to be able to create complicated searches, an example of which is given below: Address Field: Birmingham OR Coventry OR West Midlands OR Nottingham OR Leicester CV/Resume Field: Java AND J2EE AND (C++ OR C) NOT Embedded. Has anybody come up with a simple interface for performing these type of searches Thanks Nick

Is there a way to use an OR in a find? I'd like to search for "value X" or "Value Y" in a find, and not have to do 2 separate searches. Thanks. -j

My db contains a relation of cars. Actually I can list all of my records in one separated text field as "category", "manufacturer", "model", "year", "price", "client". But I need to categorize the list by ranges. Example: "category 1" "manufacturer 1" "model", "year", "price", "client" "model", "year", "price", "client" "model", "year", "price", "client" "manufacturer 2" "model", "year", "price", "client" "model", "year", "price", "client" "model", "year", "price", "client" "category 2" "manufacturer 1" "model", "year", "price", "client" "model", "year", "price", "client" "model", "year", "price", "client" etc. Is possible to do it w…

hello, i have this problem i can't figure out .i have created a db that pastes the find criteria (in the description field) to a global field in the header .the reason being that if you want to "refind' that description (if you have messed up on the omit's or whatever) you can just press the "refind" script button and you are back to where you were before.it also doubles as a "save found set" field (on a duplicate layout) etc etc the problem is: 1) if my find is unsuccesful (eg carp) i want FM to automatically search another field (which is a value in a value list) only then do i want Modify find to come up . When i then modify the criteria ( eg cod) hit return a…

i don't understand the logic to the following find result: i have 3 records which have the following data in a text field, respectively: record 1: 2002 part 1 record 2: 2002 part 2 record 3: 2002 part 3 when i do a find for '2002 part 1' or '2002 part 3', the matching record is found, but when i search for '2002 part 2', all three records are found. what's going on?

Is it possible to perform a search that finds records where, in a particular field, one search criteria is within a set number of words (user defined) from another search criteria. e.g. search criteria 1 = EJB search criteria 2 = Java no of words = 3 would find all records where in the particular field EJB is written within 3 words of Java. Much thanks Nick

Hi! I have a database for work that tracks hours worked for my employees. If an employee is absent, I have a field to track that data. What's the easiest way to find all employees for a given time period (such as a month) who have perfect attendance? These employees would not have any entries in the "absence" field. If someone was late or absent one one more times during the time period, I do not want their name in the final report, but I don't know how to generate this report. Should this be done with ScriptMaker? If so, I'll post there! Any help is most appreciated! Russ Conte FM 5.5 on Mac OS X.1.3

B):smirks:: you get past one problem you hit another. I'm setting up and inventory database were the user clicks an update button and it checks if the part is in stock and if it is adds one to the used field in the inventory database and adds the part information the warranty database I'm haveing no problems getting that up and running. Were I'm haveing the problem is when i have to update the work order i need to add the Part information which is in many fields to work order in one field and i have a field in the inventory database were the user tells which Tag(record) to update in the work orders any ideas?

I am new at using the scripting functions and calculations and am having problems trying to figure out how to create the calculations for a pop up window on the search page that will allow doing a search on all records created "today" and "the last week" and "the last month". I can create the pop up window, but do not know how to create the scripts for the above 3 time periods. If someone could reply with to this with the scripts, I would be very grateful. Thanks in advance for your help - Sam --

I work for a museum which has 5 separate FMP databases (relationally linked), one for each geographical area the musuem covers. Each db has identical fields and also stores a photo of the artifact in question (detailed in the record). The separate dbs can be searched 'universally' .... one keyword finds every record where that keyword occurs, no matter what field. The search routine (separate screens) that search across all 5 dbs are specific/exact only ... i.e an exact match in one selected field. I need to have the same 'universal' search capability we enjoy on each separate one across all the related databases. I'm sure this question has been asked many times, …

Let me first see if I can describe a hypothetical in order ask my question: One file, "foo.fp5", contains records which include, let's say, three text fields: "Name", "Organization", "Hobby" or something like that. In that file, let's define a calc field called "Match": Match = Substitute(Name, " ", "

I have to make the following database, in this example: there's a box with tickets. The box number is 1418. in the box are 1000 tickets, all numbered unique. The range of tickets in this box is AB2000 to AB3000 Now, one should be able to find in what boxnumber a certain ticket is. So, when looking for ticket ab2512 the database should show box 1418. So far, i cannot figure out who to to this, other than generate 1000 individual records, one for every ticket in the box. But i'm sure there's another way Thanx in advance !

I have two fields. In field one I have a choice between three options A, B, or C. In field two I have a choice between three options Z, Y, or X. I have over 100 records and I want to print a report where all the option A's are found from field one and I omit all the option Z's from field two. Can I do a combined find that finds certain records and omits others. When I do it separate I either get all of A, B, and C with Z omitted or Option A with all of Z, Y, X. There must be a simple way but I cannot get it. Thanks in advance for anyone's help. -Morning man

Hi! Does anyone know if it is possible to avoid users to hit the return-key during a find records script step? I've created a db of contacts, and when the user hits my find button the db switches to a new find-layout via a script. After entering the find criterias the user is supposed to hit my own "perfom find" button that trickers a new script, that shows the results in a list mode in another layout. My problem: Users are used to hitting the return-key (on the web search-engines and other places) after entering the find criterias - but the result is just a "normal" find procedure in the same layout. Can I force FM to ignore the return-key input? Than…

Hey all. What's happenin? Please forgive me and be patient with this long post. I had tried to make it brief, but had to go back and change it because there was important information missing. "Wrote a song bout it, wanna hear it, here goes.." In case you didn't already know, I have a database that prints a series of letters. In order to track which letters should print at what time, I have set up many scripts (with the invaluable help of this forum). They basically go like this: If ["Letter(X) = "Intro Ltr" and "Status(CurrentDate) >= LtrPrintDate + 4] Set Field ["Letter(X1)","FollowUp Ltr"] Insert Current Date ["LtrPrintDate1"] Go to Layout [Follo…

I have a small customer database, 6,000+ records. This is linked to a Invoicing DB. I need to find all customers that last ordered in 1999, 2000, 2001 and 2002, and so forth. I thought setting up Max(InvoiceDate) calculation field in Invoices would allow me to search from customers inserting a range in the field ie. 1.1.2000...12.31.2000. But I am getting unpredictible results,... then I tried this creating the calc in customers over a relationship. But it will not work either. I do not necessarily need to use Max() but I do need the search to work. I feel like it is staring me in the face but I cannot see it. Forum I need your wisdom. Thank You!

Hi there, I have a series of records that need a field updated once a week.

I am trying to find a way to find a string in a very long text field. In my database with notes, one of the fields contains the text of the notes. These are sometimes very long texts. If I search for a word in the this field, of course I get al the notes with this word in it. Only, how do I find that word within the field? Maybe there is a way to move the cursor to a specific location within a field?

I have been asked to create a "neighborhood school finder" system for my local school district. Users want to enter a street address and be told if that address falls within the school district boundaries, and if so, which schools (elementary, middle) that address relates to. They have given me a file of address ranges that I am scrubbing that has the following discrete data elements: (1) street number range - minimum (2) street number range - maximum (3) odd or even indicator (4) street direction (NE, SW, etc) (5) Street Name (6) elementary school code (7) middle school code. (There is only one high school) Th…

I am fed up with FileMaker's inability to allow searches for things like "lb" in a number field. The story goes like this: I inherited a database where some fields were text fields when they should have been number fields. Since then, I have corrected the field type and it is now a number field. Good, now people can't enter in silly things like "lb", "lb.", "LBS", etc. BUT, FileMaker leaves me stranded when I want to do a search for the non-numeric characters in the number field. The data is stil there, but because FileMaker forces the correct input type in Find Mode, I am left with either leaving the data as is, or unconveniently converting the field back to text m…

After I've performed a FIND using multiple requests I want to be able to list the results and then choose the records I want to save by e.g. ticking a checkbox on the list screen and then only saving the records that are ticked. If I was only using 1 search request I could use Modify Last Find and then use the checkbox as part of the search criteria but how can I do this when using multiple criteria?

I need to paste the number of records found in a query. To be more specific, when I do a find and it results in 5 records, I need to paste the number 5 in a field on another layout. Is this possible?

Does anybody know how I can search and find records in a main file from records in a related file?

Newbie here... I have an application where I give the user a layout with a single field that is formatted to use a drop down list. The user chooses a category from the list and clicks on a button that runs a find script. The matching records are then displayed on another layout in a list. The problem is that this will also return records that contain the string. I want to only display exact matches. I know that you could add "==" to the beginning of the category name to get an exact match, but then I couldn't utilize the drop down menu. Is there another way to force a find to only return exact matches? Can this be done in scripting? …

Hello, I have a database that is used for job descriptions. I have a form the following feilds. -job number -job description -date finished the problem Im having is that I have these fields 20 times, because there are 20 lines on the form. So I have job number1, job number2, job number3 and so on until I get to job number 20 and the same with the other feilds. This causes a problem when using the search in web view, because I need to do a search on all the job numbers and I cant have the users typing the job number in all the job number fields up you 20. I f anyone understands what I mean please help. Thanks Chris..

Howdy folks, So I'm wrangling with an issue that I suspect a relationshipcould solve, but I can't quite figure it out. It's with a database that tracks outreach instances and volunteers. For each Outreach, there are many Outreach Volunteers; both of these are viewed through a navigation database that has a one-to-one relationship with both of these, called Main_Outreach (which is a holding tank of all globals and no actual data). In any given month, I need to determine a total number of volunteers for the month. BUT! Because of our contract, I need to find only the unduplicated volunteers for the length of the contract year (so if the…

In my find Script I would prefer not to use copy and paste. I have an ID field which the user has entered the record number from another record in the DB. When the user wants to see the other record they run a script that copies the number and enters Find mode where it copies & pastes that number into the serial number field and does a find. There's got to be a more elegant way...

i have a set of databases (houses, rooms, artifacts). i need to search and display records for multiple criteria. for example, display all rooms of type 14 with skeletal and ceramic material or display all houses with room type ala that also have triclinia i know how to relate the house/room databases to display the appropriate room and i can find the artifact materials separartely but i don't know how to do both in filemaker. i know how to do it in sql and access but the databases are in filemaker and i have to use it to do this project. can anyone direct me on where to look? thanks much.

I have categories and sub categories and occasionally multiples of the same iwll appear. Is there a way to only have 1 show up? THanks -j

I run a find in a script, but want to run it w/out dialogue. For instace, when it doesn't find anything, i want it to skip that step and move on. I know you have to do something with error capture. Thanks -j

I am writing in FM4.0v1 a continuity welders log. Each welder may be qualify in five different processes. Each file will have five qualifying dates and five requalifying dates. I have a layout for enter the criteria day and a find script attached to a button. The criteria date field is a global field and I have use the the set field to enter this date in the other five requalifying fields. The problems is that I cannot figure out how to enter an operator into the criteria field in a script. Cannot enter it manual neither with the script running. Also I have made a list layout to view the records found. This view will show all of the dates. I want to see only the dates tha…

I am working on a help screen, and am trying to explain in very simple terms the difference between using the exact match (equal sign), and literal text (quotation marks) in find mode. I looked in a book, and it started talking about how Filemaker indexes fields, etc. I am looking for a way to explain this very simply to real novices.

Howdy Group: Hoping someone can assist me on this. Here is what I need to do: I have a database with about 700 fields and i am trying to archive using search from about 6 of the fields in question 1. Date Entered (year) 2. Status Field 3. Date of an event 4. Date of a 2nd Event 5. Date of a 3rd Event 6. Recv Category Here is the scenario of what I need to do: I need to find all recs that have a Recv of "0" that also have a status other than Hold, Pending or Challenge(from about 10 other status' entered) that also have null values in the three date field mentioned above. From that point th…

On a layout I want the user to be able to see the data in the field, search the fields, but not able to enter/edit the field in browse mode. I now have a layout setup where the user can view the information and search the fields, but they can edit the text. If I select the 'do not allow entry into field' option, the user cannot search that field anymore as they can no longer enter it. I cannot make these field strict as I need to be able to edit them in other layouts. Nor can I setup a 'search layout' in find mode, as I need them to be able to browse through the records before and after searches. I'm sorry if this is a beginner type question, but I'm new …

Howdy All: I have a quandry i would like help on: I have a database i am rebuilding ( About 245 layouts with more than 900 fields) - I know! I am trying to clean up the data by process of searching and eliminating certain records. I have criteria for about 6 fields to search, but the last three fields are looking for NULL data: IE: Doc Date (omit) Null Billing Date (omit) Null Results (omit) Null I have the add request thing down pretty good, but how do I specify to FileMaker that I want to search for this NULL data in these fields? If this is a very simple question, please feel free to e-mail me a Cluepoun wi…

Can anyone please tell if and how this can be done? I have three fields field1, field2, field3. If I want create a search layout that will look for the word " Loan" in every field, and do this by date, how would I go about this? Can this be done? Basically I have multiple fields that I need to collect this data in a report by one of the choices in Value list. Thanks, RET

I think there is probably a simple answer to this, but I can't seem to find it. Is there some easy way to enter the name of a field in a find request? I'd like to find all records where one date field contains the same value as another date field in the same record. I can't seem to find the answer to this anywhere in the documentation. Please help.

Hi- If I run a find and there are no matching entries, is there a way to change the message that says "No records match this request"? With the default message it gives the options of "Modify" "Continue" & "Cancel", but I want to change the options to only "Cancel" Is this possible? Thanks in advance

Hello, I have to develop a database in filemaker (5.5, Win NT) with a lot of relations sometime going through many files. I would like to offer the user a simple << google-like >> search utility across mutiple fields (ANDed keywords). For example in a db with four searchable fields with the query "red apple" would yeld each record which have a "red" in one field an "apple" in another and anything in the two others (and possibly "red apple" in one and anything in the others, etc, ...) I think I already know the techniques to do so in fm. That is either use a calculation field which concatenates info of searchable fields, and then search on this field…

I'm working with a file that contains these fields: 'User' (text), 'Week of'(date). In the 'Week of' field is the date of the Sunday of that week. Sam 3/3/2002 Sam 3/10/2002 Sam 3/24/2002 Sue 3/3/2002 Sue 3/24/2002 How can I show the weeks that Sam and Sue forgot to enter for the month of March? I think I could do this in a script looking at each record and marking where the date in the current record = 7 more days than the date in the previous record (although I'm not sure how that would work in Sue's case where she missed two weeks in a row). I was hoping a relationship could somehow be established so the user could see their missing dates in a po…

I print my found set of records to a PDF file and then create a web link to that file. Data that's in one of the fields disappears and/or does not fully display when you open the PDF file. I have tried replacing the field, quitting and opening FileMaker, making the field smaller/bigger, etc. I can't figure out what's going on. The field is certanly big enough to accept all the data. What's going on?

I have a database with about 12000 records on it. When I perform a search using "" eg searching for "C++" it locks the database up and takes ages to complete the search - any ideas on how to get round this problem Kind regards Nick

I'm new to the board, and just started using FMP 5.5. I have all my customers listed in Appleworks 6 and want to move them to FMP. What is the fastest and easiest way to do that? Also, is there anyway to track customers. Like if a customer wants me to call them back in 6 months, is there a way FMP can notify me? Thanks

I have a db that I use to track art and the supplier of the art. I preform a search for all the art that I used last month and wish to send a letter to each of the suppliers of that art. I have made the form letter, but here is the problem. Since I may have used 5 pieces of art from one supplier, there are 5 occurances of that supplier in my form letter layout. I hope that makes sense. How can i weed out the duplicates so it will only print one page for each supplier. sorry if that was confusing

I don't know if this is in the right forum but here goes. If one of our databases is left idle for a while it brings up a dialogue box saying "No records match this request" with the following options "Modify" "Continue" & "Cancel" If I click on Continue it shuts FM down. It has also happened when I have gone from a FM Database to IE. Has anyone come across this before?? [ April 11, 2002, 06:10 AM: Message edited by: Tom England ]

How do I go about finding records that exist more than one time? For some reason when I was importing a txt file it duplicated records instead of updating them.. Even tho I had the ID set on "Unique" and "Strict" it still allowed them to duplicate the ID numbers. There are alot of them so is there an easy way to pull up any records that exist more than once? Thanks in advance! Nic

Does anyone know how to prevent FM to show this message: "You are in find mode and appear to be entering new record data rather than find request criteria. Are you sure you want to create a new find request? (Yes/No)" This message appears after the 10th new request (we use the shortcut CTRL-N). Can that maximum value be increased? Can we get rid of it altogether?

Is it possible to do a find, for example for all dates that begin 1/4. This would find 1/4/1999, 1/4/2000 and 1/4/2001??

You're almost there. To finish this with the technique you're using you'll need to also make the user's name (or some other ID unique to each user) part of the relationship. In your main database, create a global text field. This field should be set to something like "1" & UserID where UserID is a unique identifier for each user that can long into a database. If each user has a unique user name entered, you can use Status( CurrentUserName ) instead of UserID. The only requirement is that it's unique for each user. Once you have the found set of records in your organization database, use replace or a loop to see a field over there to the same thing, "…

How do I require that 2 or more fields be filled in a search request. I am trying to secure customer records by requiring either invoice # and zip code or last name and zip code. I can not seem to find documentation of this kind of setting. Help?

Hi, Without boring you with the details I have set several fields in my database layout to Not Allow Entry. How do I now find records based on those fields? Since they do Not Allow Entry, I cannot enter a criteria for Finding! AAAAAARGGH! I really don't want people to be able to mess (even accidentally) with the set values! Can anyone offer some suggestions? Thanks in advance James [ March 17, 2002, 08:57 AM: Message edited by: JimDiGrip ]

I have a layout with the main record in the header and related records from a self-join relationship showing in a portal in the body. All OK, except it won't print the second page when necessary. Having seen the other posts about printing data in portals, I'm trying to take the alternative route and find the other (parent) records themselves and then print them out in list form. Every time I try and do a search in the related field, I get the following error message: "FileMaker Pro.e.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." And guess what, every time this happens the…

Imagine this scenario: You have a text field in a record containing cvs / resumes. You perform a find to locate people with filemaker skills. ie Input Filmaker into the text field. It produces a found set of records containing the necessary skills. Is it possible to highlight "filemaker" whenever it appears in the text field.

Hall

Hi all, I would just like some confirmation that the following can't (or maybe shouldn't) be done. I have a portal which I can filter dynamically by setting a variable. This portal is based on a dynamic relationship with the "left" key being an unstored calculation which depends on the primary key and the variable - and the "right" key is a stored calculation, a concatenation of that files' primary key and another field. Now, when I try to find records within the portal, I get no found records, no matter what search criteria I enter. However, if I use a relationsship with the left key being a *stored* calculation, the find works. Now, why is that? …

Hi all Is there a way to display the number of find requests and the number of the current find request while beeing in search mode? E.g. "You are in find request 3 of 5". I would like to leave the status bar hidden while users input their find requests. Gerd Variabledemo.java.zip

Gentlemen, How can I set up a field that contains dates (xx/xx/xxxx) so I can enter month, day or year,and get a match? ie...enter "1995" and see records containing 01/01/1995 - 12/31/1995. Thanks.

I created a database program consisting of two files, one is a Project file and one is a Unit file. The purpose of the program is to have the user create a shelving installation project for a particular customer and to populate that project with different sized shelving units from Unit File. The Unit file differentiates each shelving unit by size, color, options. I am trying to create a raw material parts list to give to my purchasing agent so that he can buy material to produce the shelves. Here's an example. I have a project that has two similar shenvling units in it. Unit 1 is 12"W x 36"L x 74"H with 4 shelves . Unit 2 is 12"W x 36"L x 85"H with 6 shelves. The …

I want to do a find to find records with a date in a particular field. It doesn't matter what the date is, as long as there is a date in the field. I undersatnd that by putting * in a field it will do a 'Is Not Blank' why doesn't this work with dates? How can you do a find on a date field 'that is not blank'???

I have a problem and was curious if anyone had a solution. I am creating a database for a manufacturing company. I have a order entry file and a related line items file which has things like part numbers, due dates, customer names, etc on it. I need to find a created a layout that will allow me to search the line items file using any or all of the above fields. The problem is that I dont want to have the user for example type in a part number and hit the (...) to get a range. Instead I like to use a start and stop field with a calculation field that basically combines the two fields and puts the range symbol between. The problem is that this needs to be done in browse …

My problem is this: I am creating a simple database that contains a grid with seven separate codes (in 7 separate fields) and the numbers (in adjacent fields) that correspond to them. All numbers are distinct and should be kept separate. Can I perform a search that will locate a specific code in one of the seven fields? If so, how? If not, is there a solution to this -- perhaps creating a composite field that will display the contents of all seven fields in one? thank you for your help

Capture the find criteria as globals. Then either run a find script in each DB or use the globals to create a relationship to the other DBs.

Try *really* hard to avoid a system that relies on exports and imports. What's wrong with having a field in the database that gets marked "posted" but leaves it in the same file? How is the rest of the system set up: using related records?

Of all the years, I have come across a FIND PROBLEM that is working my common sense into overtime. A landlord has requested a FIND for his Renters by addresses. SIMPLE enough.... Now, here are four addresses he has on file, in a pop-up menu so no spelling mistakes. 404 west market apt 1 404 west market apt 2 404 west market apt 3 404 west market apt 4 QUESTION / PROBLEM is this. When there are multiple entries for each apartment, a simple search should isolate them from the other. HOWEVER...when you do a search/find for 404 west market apt 4, it will bring up all the files, which in this case is apt 1, 2, 3, and 4. When a search/…

Hi, again I try to make a patient list of "x-day", e.g. today is February 11th, the list show me all the patients with appoiment in this date, in this DB (Appointments), I have 4 fields (date, time, time_app & time_in) I have a relantionship with my master DB (Patients), just I want to find the appointment's patients, but, If field time_in Is Valid don't show this patient. I hope you can read this, please I need help. Best Regards Jorgs Soriano Saludos from MEXICO

In a script, I am calling the EnterFind function. After the user executes the find, I want to continue and perform some other functions. Problem is that the Find is not stoping to allow me to enter the find button, instead it is simply going ahead and continuing with the script. The Puase doesn't work because once I hit the continue, it still goes through to the rest of the scrpit. I simply want it to stop to allow me to enter search criteria and then press the find button to execute it followed by the continuation of the script. A

I have two files/databases/tables what have a parent and child relation. I want to search for parents that have children containing some characteristic. The result set that I want back is only those parents that have these childern. For example: Find all parents that have girls. Although there may be several parents that have more than one girl, I only want to return that parents record once along with all other parents that have girls too. I have tried several approaches, the most recent being the use of "Go To Related Record" then execution of an external script in the Parent file which simply goes to a list type layout and goes into browse mode. …

Hi there, hope you can help. On my database, I have a group of about, 10 checkboxes, two of them are quite similar, ones 'film' and the other is 'film classical' When I do a to find all those with the checkbox film checked, I also get returned the records with the film classical checked. How can I get around this, I don't want to rename the film/film classical, I just want it to be more precise when searching using checkboxes,. Any help would be greatly appreciated Regards, Doobeh.

I saw this topic posted in the past, but I could not find it any more or anywhere else. Anyway, my question is how can I search for checkboxes. The checkbox is using a simple value list which is "Y". I can make a script to find checking or empty checkboxes such as: Find Mode Set checkbox = "Y" (or set checkbox = "=") Perform Find And assign this script to a button called Find checking Check box/Find Empty Checkbox But I want to have GENERIC Find button, but the problem is I can not type "=" in the checkbox to find the checkbox that has not been checked. Any advise? Thank you

YES -I'M NEW IN TOWN. Soory - ok - i'm trying to make a counter of recoreds (BY first- letter name) and then to make a list how many names i have in each First letter. i was using the omit command but it's look like skiping recored. i try some way's LIKE -go to prev.. after the omit but nada. CAN'T SLEEP WELL IF SOMEONE CAN SHOW ME THE "TRICKY-SCRIPT" ?? THANK'SSSSSSS

Is there a way to sort my student records so that they alternate male, female. [ February 06, 2002, 03:31 PM: Message edited by: jlazyr ]

I'm making an invoice report. I'm making find a range of date to show totals etc. I've made a new layout with global date fields for the user to enter the start and end date. The script to preform the find goes a little somthing like this: Enter Find Mode [] Insert Calculated Resault [ select, Date, "gDate1 & "..." & gDate2] Preform Find[] Go To Layout ["summary"] Sort [restore] Enter Brose Mode. when i run this with vaild dates FM said it couldn't find any records. thanks for any input

This is a simple question, so I hope someone can help me answer this quickly. When I do a find, how can I get the cursor to go to a certain field and make it as the default field for everytime you switch to a find mode in columnar list/report layout? I am sure this in the manual somewhere, but I can't seem to find it. I would greatly aprreciate it. Never mind, I figured it out. Sorry for the inconvenience. [ January 30, 2002: Message edited by: Q ]

To create a sales tax report for the previous month sales, I have a script that finds records that were paid say "3/1...3/31" which finds them for March of the current year. It works great until I get to January. I don't want the user to have to enter 12/1/01...12/31/01. I want to be able to click a button for December and find all the previous December's records, no matter what year it is. This will always be done before the 20th of the following month. I hope this makes sense, this is my first post.

I have 2 fields, LastName and FirstName. I want to check if someone entered the same thing into each field. I figured I could ask Find Mode to perform a find where LastName=FirstName by entering =FirstName in the LastName field. This does not work; FM does not seem able to evaluate data from another field in the same record. There must be some simple way to do this, but I can't figure it out. Perhaps there is some symbol that does not appear on the symbols list popup that tells FM to insert the contents of the named field into the "search" parameter.

Hi I am using the find query string in FMP5.5 to search for records in a particular field. the fields contain values such as 11AABB, 23FFCC, etc. Doing a search for "11AABC", returns the record for "11AABB" the test query string is (VBscript): http://127.0.0.1:591/FMPRO?-db=dbname.fp5&-format=-fmp_xml&Fieldname="& var & "&-find" Why is the search so sloppy? It should return NO records. Thanks Neil.

It depends where you locate the summary field on your layout. If you create a subsummary part sorted by Food, and put a copy of the SUM_ALL field there, and then add a grand summary part and put another copy of the SUM_ALL field there, then you can display all records, sort by Food, and the subtotal will appear in the subsummary part for each food, and a grand total will appear in the grand summary part. Check out the manual regarding layout parts (chapter 6). [ January 10, 2002: Message edited by: BobWeaver ]

In a data base, with several Text Fields, I can easily make a research in ALL fields with just ONE "Search Field". I simply create a calculated field with a formula like " Chain(TextField1) & Chain(TextField2) & ....", and place it in a request layout. In Find Mode, you can fill this only field and know that FmP will search in EACH field includes in the formula to extract the concerned records. Here is my problem : When I do the same with Date Fields (and of course modify the calculated field formula), FmP never find any record even if all fields contain the date I'm looking for Many thanks if you can help. Patrick

I'm somewhat new to FM Pro, using 3.0. My background is AppleWorks, and I know the database in AW can save sorts and searches to use later. As much as I look, I can not find anything like this in FM Pro. Practical example, I have a FM database of employees, sometimes I want to sort it by employee name, sometimes by dates, and so forth. Is there a way to save the sort (or a search) so I don't have to recreate it every time? What I want to save are the sort or search criteria (sort by employee name then address, or search for all companies in Chicago, etc.), not the results. This is also how it works in Appleworks, if that gives any direction I'm going. Scripting is fine w…