Finding & Searching

I have a database that was created in Filemaker 2.1. I am now using Filemaker 4. The problem is, the layout menu doesn't work when I open this database. I can flip through all the layouts in layout mode, but in browse mode, the menu doesn't even open up. Any ideas of what I can do?

Hi, Gotta medium size FM database operatin over a Mac TCP/IP LAN ...am doing searches on fields and then PRINTING them to .pdf for a later merge. At first, the printing to a .pdf file on my desktop ZIPS along great.....then the more I do ...the more it sloooowwwwwwssssssss down. Funny---I shut down FM and start up again and it is fast ----then startsa to slllllooooowwwwwww down. I have: -Jacked the memory on FM and Acrobat way up - Indexing is turned on Questions: Why does it behave like this? What can I do?

Hello, I've two little problems. I've a DB "BOXES", where I've 100 fields. Each record corresponds to a boxe (with 100 compartments). First, I would like to perform a search in any field in any record. The only way I found, was to set up a script with a SEARCH field Then I copy/paste it in each field and I performa a "find" for each field. It works fine but I'm not sure this way was a very elegant and fast one. More complicated (for me !), I would like to make a list for all the fields. In fact I would like a table list with the first column with the field content and a second one with the ID of the corresponding record (corresponding to a boxe ID). The idea is to ha…

I've got a solution hosted off of a machine running a regular version of FMP5, and the network is a simpel eithernet nework with two other computer besides the one acting as the host. The files are pretty big as far as number of records go (17,000) in some files. The finds seem to take forever, especially across on a guest machine. What kinds of work arounds have you found for speeding up finds in such large databases?

Hi, I think this is gonna be a nasty one. Using filemaker 4.1, in a database I've two date fields, data_start and date_end. I use a website for our users to access this database to have a look in the planning of radiostation, I want them to be able to search on items running on a date they enter. I allready do it in FM itself, by running a simple script, but that's no solution to the web. Now I figured out I could create a textfield containing all dates from date_start 'till date_end. So, by searching on that textfield, FM comes up with all records 'running' on the requested date. The question is : how....... If anybody could help ?? Cheers, Andr

Hi all, I am a new user of FM Pro 5.0. I have an assignment to search the data, I know this could be easy using the SQL but I do not know how to do it with File Maker. I will be thankful if any of you can help in the following problem: We have a table (say table 1) where we keep on updating the product information as and when required. I have another table (table 2) where I need to update the field based of product specifications on the given date what I search from the table 1. If I use the SQl it could be something like, update table2 set specification.table2 = specification.table1 where product.table2 = product.table1 and date.table2 = date.table1 (or lie…

Hi Justine, forget inner /outer joins in the FMPro files: FileMaker does not support SQL statements in .fp5 files; for plug ins accomplishing (evenctually) this job take a look at www.profdata.nl or at the plug ins section on FileMaker official site. If you clarify your concern i may provide you some help. Bye & greetings from Holy Lands.

Could anyone tell me how to limit searches to 10 results per page, and have those nifty "next" and "previous" buttons to see the next 10 or previous 10 results? Thanks in advance for helping a nubie..

I need help with a date field/date range question... I am and event/tour coordinator and I have two related files, one we will call events, the other we will call personnel. I would like to be able to keep lists of people involved in a particular 'tour' or set of events in my personnel file - which has start date and end date fields - so I can easily navigate from my events file to the correct list based on the event date in question. My key field would either be the client name or the tour name (I haven't decided yet which would work best). Any suggestions as to how to do this? One problem is that a number of 'tours' could have open end dates until (a) personnel chang…

I am working on a title and copyright db and need a solution to a find problem I have encountered. The purpose of this db is to free the user from having to type out info to be used for paste-up in music publishing. The user needs to find a series of different song titles and then save them to a found set to be formatted and printed. A multiple find request does not work since there are different songs with the same title in the db. It would also be nice if the user did not have to type in the entire title when performing a find. Is there a way to perform a find using the first couple of words in a title, then selecting the correct title from the results of this find t…

How does "literal text" actually work? Because of a conversion error, some characters are showing up in my text fields as "

Is there a way to find a range of numbers in a certain position within a particular record? I wish to find records that have a number in the first 4 positions of the record, but not records which have numbers in other positions within the record. Thanks

I am new to filemaker. I'm trying to find all records in field "Finalized"that are blank or not ="f". I've created a report layout but have been unsucessful in excluding jobs with "f" in the Finalized field. Any help would be greatly appreciated.

I've greated a db which stores information in group under a group name, I then can find this group by using a pull down list and doing a search on the selected group name. My problem is that when I search for my original test group "test" I also get "yet another test". This happens when I search for both "test" and "= test", could anyone help me out with this one. thanks [ May 01, 2001: Message edited by: Tombstone ]

FileMaker made it easy, but you are making it too hard. Do the first find request, entering name AND date criteria. Don't use separate requests for name and date, as that results in a found set containing all records with the same name, and all records with the same date criteria. Such a search is a boolean OR search, which you don't want. The find step for the the incompletes is only missing one thing: click the OMIT box. As to your request for good reading material on this, permit me to use an old Air Force term: RTFM (Read the f*cking manual). It really spells out how to do finds in FileMaker very well. In my experience, finding and sorting are worth a full day cla…

Boy do I feel stupid -- I've worked with Filemaker a few months now, but cannot do this simple task. I've searched my FM bible and the Help Index to no avail. If I want to search for records by Date -- such as Date Last Modified -- and for example, just want to isolate the records for 2001 by performing a Find using "2001" -- I get a message, "Must be entered in x/y/zz format" and it cancels the Find. I've tried using a DateToText field to do a similar numerical search but it says "No Records Found." Does my date field need to be formatted in a special way for me to be able to search by Date?

I have FMPro 4.1 on my office PC that runs a simple single file/single screen DB. Due to some file merging I have some number of duplicate records. Each record has a "work order" number. I want to have a search that finds all the duplicates so I can kill the older version. How is that done ? JohnW

I have a database with a field that currently has a list of items separated by a semi-colon and a space. (item 1; item 2; item 3; item 4) I want to replace the semi-colon with another character. Is there a way to search for a specific character or word in a field, and replace with another character or word. Thanks, Brett flash_test.fp7.zip

I'm sure that this is something many of you have done many times, but for me it's a first so I'd appreciate some feedback/advice. I want to script a Find before allowing users to creat a new record (to be sure that it's not a duplicate). What I have in mind is: 1. Create a button that adds a new contact. 2. Have this button perform a Find that checks for matches of first name, last name, partner's first name, partner's last name, and street address. 3. Display all possible matches in a layout that lets the user either choose one of the existing records (if it's the same person) or create a new one. Does this seem like a good way to do what I need done? The previous…

I have a database where people can say yes or no or primary to whether they are in a certain group. I want to be able to sort/search these fields by yes&primary. Not all people answer no, if their not in the group all they do is leave it blank so I can't just omit the no's. Please help.

Can someone help me out with a simple way to finding new records. I was using the "update" feature of importing records but is it intolerably slow. I want to find new records in one database and import them into an identical database. Thanks for your help. Mike

I have a carrier checkbook that I want to print only the Carriers that made over $600.00. I have a Layout with Date, Payee, and Check amount and also A calculated field that has Total check amount. I did a find on the date and sorted by the payee, but only want to print the ones who were paid over $600.00. What am I missing here? Or can't I find only the ones that are in a calculated field? Please help I am going crazy trying different approaches. Thank you

hi, When I serach for "abc", the result doesn't only "abc" but also "abcd", "abcde"..etc. How can I avoid this and get the exact result? thanks for any help! -jimi

I'm working on a solution in which it is convenient to use buttons to perform a variety of finds where the index for a field serves as a menu (i.e., as a list to choose from, not as part of the menu bar). As it stands, the relevant bit of code in each script is "Enter find mode[]", "Paste from index[select, "(the approporiate field)"]", "Perform find[]". This works OK as long as the user doesn't click the Cancel button when the "View index" window opens up (this leaves him or her hanging in find mode in a layout that I don't intend users to see at all) or check/uncheck the "Show individual words" box. Is there any way to disable those features? Or better yet, to take …

When I perform a find by a related field, this find is performed very slow, How can I optmize this process? how can i have the results of my find more faster if its possible??? Thanks for all help

I'd like to know why how to otimize my find results when I use relationship fields in it... If someone could help me.....Thanks dynamicCalendricReport.fp7.zip

How would I preform a find based on a user selcing a price (from a popup list) for a low end and a price (from a popup list) for a high end - having the find come up with the range between. I can do it manually if I enter it all into one field and use the range modifier. There is only one field - price per item I want to find. Thanks for any help, Chris

I'm using global fields in browse mode to enter my find criteria, but how do I allow the user to select Omit criteria?

...I can do it manually, but how do I script it? I am trying to find multiple records in one database (A) based on the criteria from multiple records in a second database (. The common factor between the 2 databases is a number but the common factor between the multiple records in the second database (: is a field that does not exist in the first database (A). I can manually enter find mode in database A and copy and paste the common number from database B, "Add New Request", and then copy and paste the number from the second record, "Add New Request" again and so on... How do I script the "Add New Request"? By the way, love the new options!

Do you know of any way in FileMaker to have just the records in the found set, re-searched for a second criteria? If you modify the find and add a second search criteria it seems to search the whole database again and this is a big performance issue for us in regards to the Web. I know in some other databases I could command "just search the found set". thanks

I assume that you want to automate this. Otherwise you could just enter the date 3 days from now (ie March 21, 2000). You can use the following in a script: Enter Find Mode Set Field [YourDateField, Status(CurrentDate)+3)] Perform Find De-select the "restore find requests" in both the Enter Find Mode and Perform Find steps.

Can you create filters in FM5 or is there some other way FM5 limits what the user sees?

I need to find a way to find a set of records that are 'Unpaid'. I have managed to do this by finding 'Paid' and selecting the omit Checkmark. I then add a new request and enter different information to narrow the search further. This is fine, but how do I apply the same method to a script step?? Especially if the last find criteria is defined by the user. Any help would be greatly appreciated. Thanks Elsie

how to add an accessible field in find mode ?

Write a script to perform a find in Database A with error capture on. If Status[CurrentError] = 401 (no records found) after performing the find then run an external script in Database B and repeat the process if no records are found in B.

I have a database with Site names in it

I hope this is simpler than I think. I'm used to working with Paradox or Access and their query screens ( and some SQL statements ). The method for finding "does not contian" or "does not equal" in there programs is easy. generally you use <> or !=. How do you do it in FileMaker ? JohnW

This problem is hard to explain succinctly, so I'll explain it in detail. I have Tutee & TuteeProgramHistory (TPH) files that are related by a unique serial. TPH keeps track of the semester, year, and program the student is enrolled in. Tutee has a portal to show the many programs the student is in. My problem currently is when I try to find students enrolled in Fall 2001 tutorial (it should give me no results), I get most of my students because they are enrolled in Fall programs and 2001 (Spring) programs (the frustration of doing searches in portals, it looks for any combination). Someone told me the search needs to be done in the TPH file, but then I can't import t…

quote: Originally posted by longncsu: I have 2 tables, one table holds all the Exec. Managers and the people they manage (Managers). The second table holds all the Managers and the people they manage (Supervisors). Is there a way to put all 3 fields in one table or a way to copy the results from the first find and use it in the second find? The best way to do this is with two fields only. The first field says who you are, the second field says who your boss is. You can then create self-relationships to get the entire organization overview. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected]…

is there a way to do a find field contains? Example: I want to do find all records that the part number contains "573" and the found set will show: 12573 343573 88757355

I have put together a shipping report that creates a total of the single product ordered by a particular buyer. I want to take that information and tranfer it into a database that lists sales of the products in units and dollars. When I set the total as a look-up to the sub-summary in the other database, I got a running total of all items shipped rather than just the specific product. Any ideas on how I can make this work? Thank you, Maura

We print reports that contain shipping dates. While the database has all of our records, we only want to print ones from a certain date forward. I have gone to Find Mode and created the parameters <1/17/01 and get all of the files. I have also set a range of dates from 1/17/01...6/6/01 and still receive the whole enchilada. What am I doing wrong? Thank you, Maura

I need help finding duplicate name records in a contact database. I can find like first or last names, but I need to find all records that have the same first AND last names. I have tried many find combinations...does this require a script? Really what I would like to do is reconcile two databases and combine the records of the same name. I thought this used to be possible.

hi! how do you search for a date that affects multiple date fields? thanks ------------------

Hi! I need to query on a date on all my field dates. Is this possible? Thanks so much.

I'm using a script to save a found set which utilises the Copy All Records command. This works fine but the problem arises when I disable Export Records in the password (to prevent any employees downloading the contents of the database which holds valuable information) This also seems to disable the Copy All Records command and therefore prevents the script from working Any ideas? Cheers Nick ------------------

I am trying to create a report where the user can click a button and bring up a report of all newly created records within the past 7 days. The only thing I need to know is how to find the correct date range. The range should read: TodaysDate - 7 days to TodaysDate (or >TodaysDate - 7 days. In FM 3 how does this work? (//-7)..// doesn't do the trick. Can this be done? Thanks.

Just use the "=" sign for the search criteria.

I'm trying to create a script that automates finds by copying a specific field in one database, enters the find mode in the 2nd database, pastes into the field I indicate, and performs the find. I have tried setting the field instead of copy and paste, but I can't seem to do either when I'm in the find mode.

My database consists of one file that's organized into several different record types (Customers, Orders, Products, etc.) There's one layout (used for viewing and modifying records) for for EACH record type . Finds are performed as the user navigates between layouts to ensure that they see the appropriate TYPE of records only. Example: When user goes to the Customers layout, his found set becomes all of the Customer records in the file. Other finds can done from within each layout to find more specific subsets of each record type. However, these found sets are not retained as user navigates between layouts. Example: User goes to the Customers layout and finds only those…

I would like to create a layout that would show the criteria that were used to find the set of records. Is there any way to get them into a global text field that would be int he header of the layout?

Just getting into creating buttons and scripts to find and sort records in my solution and having a few minor problems that I can't quite figure out. First and foremost is the fact that even though I deselect restore on the enter find and perform find funtions, I can't seem to create a script that allows me to type in the find criteria myself. Is that more complex than I think it is? For both find and sort functions, the only options when you save a script seem to be to keep the last find or sort criteria or replace with the latest one. Obviously I can hit apple f myself but I am trying to automate this solution with buttons so I can control access. Am I missing something…

Create a self-join relationship in your projects file using the project number for the key field. Self-join is described in the manual. You will need either a serial number or DateCreated field to determine the latest record. Then create a calculated field called cLatest: cLatest = Calculation[Max (Projects::SerialNo) = SerialNo] where "Projects" is the name of the self-join relationship, and SerialNo is the unique serial number or date. The value of cLatest will be 1 for the latest record of each project, and 0 for all others.

Hello, I'd really like to write a script that begins with, say, Go to related records and have control over which layout of the related file I'm taken to. I'm looking the scripts over pretty carefully and don't see how. Is there a way? Thanks all, Bill

Is there anyway to get FileMaker Pro to search every field in every related database for a term/word? It is something I have been able to do with other database programs and need to be able to do with FileMaker. Has anyone done this kind of thing successfully?

Hello FM People i need to find ina database in FMP5Mac all records starting with the same initial letters (all the ones starting with a then b and so on) but only the initial of a text field in a db of 35000 records. I am not able to do! Thanks in advance for cooperation Mauro ------------------

How to copy multiple find criterias from on file to another? I succeeded to copy one find request from one file o another. Now I have the following problem: I perform a multiple find request in my dealer database. Then I want to switch to the order file and want to have there the same finds. How to do?