Finding & Searching

Hi, thanks for letting me pick your brains... (be gentle, my first request) I have information about clients organized into a FM database, the date of communication is one of the fields. When I start a new record for a client I already have in FM,I would like to see a few fields from the last communication with them. So I think I would like to find the second most recent date (the most recent is the record I am currently viewing/endering) Is this the best way to get that information? Any ideas or tricks up your sleeves? Thanks so much! -Steve

I have two related databases. One (X) has a record for every lesson every teacher teaches in one week (several thousand records). The other (Y) to calculate the total number of specific lessons performed by each teacher (there are 70 teacher records) I am trying to use a summary field in (X) that counts the number of specific lessons (after performing a find for one teacher). I need the (Y) to perform a script in which it opens (X) performs a find on teacher A then transfers the summary field value across to A in (Y) and then returns to (X), performs a second find for teacher B, etc. etc. How do I write a script in (Y) that can continually change the Perform Find request …

I have a minimum field and a maximum field. All two are number fields. If I want to find records ranging from 1 to 10, it is easily to enter >=1 in the minimum field and <=10 in the maximum field. But I don't know how to make a script to do this find. Does anyone cn help me? Thanks in advance.

I wrote a find script for two number fields: Min Number and Max Number. I want to do a search to show records that have value ranging from the minmum to the maximum. Set Error Capture (On) Go to Layout ["Find"] Pause/Resume Script [] Enter Find Mode [] Set Field ["Min Number", "">=" & gMinNumber"] Set Field ["Max Number", ""<=" & gMaxNumber"] Perform Find [] When I enter numbers into the gMinNumber and gMaxNumber fields, it returns the results normally. But when one of the field is entered nothing, it shows all the records in the find results. Does anyone know how to I fix the problem?

I am trying to do a logical OR search on multiple fields using Add New Request. Is there a way that I can define the priority of the search criteria, that means which field's criteria running first in the search?

I have a database that has a number field with numbers from 1 through 35. If I want to select the records with numbers 1, 5, 32, is there an easy way to do it....instead of multiple requests? Please help! Thanks....

Hi All, I got 3 fields which are Name and Money and dates Name and Money and date Joo 22 $ 2004-01-01 Kii 0 $ 2004-01-20 I try to use find and in my find i use date range from 2004-01-01 to 2004-02-01 , it finds all names such as Joo and Kii . But the point is I want to find only people more than 0$ but same range date. The result I want is showing only Joo. Anybody has an idea? Thanks

Hello, I

hello, i would like to find people who have voted in the last 3 elections. i have 4 fields named with a date. in that field is either n (did not vote), p (voted at polls) or a (voted absentee). how would i find folks who vote either absentee or at polls in 3 of 4 of these dates? tnx for your help

I have 4 files that contain a yearly archive of stories. Each has title, author, date, and page number. these are very simple files. I was planning to share the files over the web and allow users to search the files for references in the stories. say for a particular company. the question is: can filemaker change the color of the words it finds? or highlight the words it finds in the text? for example: find the word string: "real estate" list every record the contains "real estate" and color or highlight "real estate". The text can have a word count up to 1000-2000 words which can make the result difficult to locate in the field. are there any examples that…

Hello, I'm new to this forum and refreshing myself on filemaker. I would like to search a table of records - easy enough. However, i would like the search view to have at the top the fields I want my user to be able to search on, then below that have a portal (most likely) containing the found records. I played around with the idea of a self-join on a table, but am missing the proper setting to have it display all the items matched, I only get the same item. My guess is this has something to do with the matches, does anyone know what the correct match setting is? thanks for your help in advance, J__

Does anyone know of a sripting manner in which to omit all but the current record (being created) on any table in a design? This has been one heck of a head scratcher for me as of late.

When I try to do a search on an un-stored calculation field in a shared file the search fails. I can cut the text directly from the field and paste it back into the field for search criteria but I don

Sorry if the header is vague. There is a sample called contacts with FM 7. When you select the find button, the results are displayed in a 'view as list' type layout. The user can then click the record they want and they are immediately returned back to the main Contact Management screen. I'd like to do something like this, but with a twist. I have a table called Jobs and I'd like to click 'find', see a list view of all the Reps I found (based on my find my criteria). Then click the Rep record and jump back to the Jobs table --- AND have the two fields (RepName and RepId_fk) in the Job table be populated with the Rep record I clicked on in the list view. than…

Hi I have a layout for my Invoices and I wish to create a box which provides a total for 1 month or that current year, it would be great if that was easily modifiable with a user entered date. I suppose the natural progression to this is a chart of the totals - as there are different sets of Invoices to total. Anyone any ideas if this is possible ? Hope so

Is there a script for automating a Find request on a text field to find all records that match a value in another global field, which is updated from another database? Can't seem to see how a field can be specified in a Find request. Thanks!

Hey All, We have a number of different tables that store prospects, each table has very different field definitions, layouts, etc. so putting them all in one table is not an option. However when we are contacted by a prospect we do not necessarily know which table their information is stored in. I need some way to search across these 6 tables. More Information: Each table has an address field which is unique to (nearly) every record, and that is how we identify a prospect when they call/write/email. This is the field I want to search. I had thought of putting together some kind of joinfile, populated with every address we have, do the search, and then go to t…

Is there any way to do a find for a line break in a field?

I was just setting up a contextual nested portals on link here: http://www.fmforums.com/threads/showflat.php?Cat=0&Number=122162&an=0&page=0#122162 As a solution to find people related to people etc (basically it just a file with contacts and a file with holds contact IDs and relationships between the 2). But how would you go about setting up a way of searching how 2 people are related i.e say I know MR B and I want to know MR E So I would need to know that MR B knows MR C who know MR E but this is only 1 level. and so I would do a simple search which compares the relationships of both. but say MR B know MR C who knows MR D who knows…

What is the best way to create a find script to avoid manually typing in the criteria? Ie., the client would like to simply choose from some kind of pop-up list defined by records in the same file which when a listing is chosen, the appropriate script is run for the selected find?

Hi, My colleagues and I are members of an academic lab that is working on establishing a new database for our research using FileMaker 7 (doing setup with Mac OSX, but accessible across platforms). As relative novices to FM, we have encountered a problem that has us stumped; any input, advice, or direction would be most appreciated. The problem as it stands is that, while the database seems to be functional offline, with full search capabilities, when using the online access, we are unable to perform a find/search based on parameters and values obtained from radio buttons and/or checkboxes. Although the selections for radio buttons and checkboxes are vali…

I have a script set up in my database to run on startup. It performs a find on the records entered in the last seven days from the current day and runs a calcuation on the results. If no records have been added in that time, a message stating "No records match this request" pops up. I have to hit continue. I would like to automate it so that it returns a value of zero on the calculation if no records exist in that set of dates. Any suggestions? Thanks.

Hello. I'd like to script the creation of a found set that spans a given date range to be used in the printing of a report. I know that manually I could just enter find mode, go to my dateEvent field, select the greater than or equals to symbol, enter the desired start date in my dateEvent field, perform the find and then sort by dateEvent. I just don't know how to script the "greater than or equal to" a date part of the routine. I've created a "specify start date" field that I'm calling z.StartDate to hold the user's desired start date for the report. Now what? Thanks, all.

Here is the problem: I have three locations that produce numerous contracts; and each contract must include down payment, monthly payment, & number of months to pay off. I would like to be able to track by month, year, and break down by one or more locations within a given month or year. What would be the easiest design to accomplish my goals? Thanks, Michael

Is it possible to script a find that changes a value in a field in the record? What I am thinking is that if I can find a set of records and change a value in one of the fields, say from 2 to 1 so that the set of records matching the find would have the value of 1 than a portal sorted on the field having the value of 1 would bring the found set to the top of the portal. Is this vaible?

Three tables: Attorney --< AttyClient >-- Client. AttyClient contains just the unique IDs from Attorney and the unique IDs from Client. It exists to handle the many-to-many relationship between Attorneys and Clients. How do I find only those Clients that have more than one Attorney assigned to them? In other words, only those Clients that have more than one related Attorney record. Thanks very much.

I'm trying to find all records in a given month and then find certain records in that set. I'm sure this is pretty basic but every time I search and get a month, anything I do subsequent to that, starts a find for all records in the database. The only way I know to do this is to use a save as, title the file August and then delete all records and start a secong file for September. The problem is, if I need to enter additional info on a past month, I need to remember what month the record was created. Any suggestions? Keep in mind I'm somewhat of a beginner.

In my version 6 database, I have all kinds of different text listings. When viewing the data on my website, all the text is filling up the spaces and moving up and directly behind the previous data. In layout mode, sliding left and up are not selected. I have tried hard returns but this does not help either.

Hello, I've searched this forum, but couldn't find an answer. Forgive me if it's redundant. Is it possible to use the Input Fields in the Custom Dialog for a find? I've tried using globals as the input fields and then a Set Field in the script, but I'm not getting anywhere. Has anyone successfully done this & willing to share the correct way to make it work? Thanks very much. Elizabeth

I'm trying to do a find that requires me to do a new request. The purpose is to locate records in category 1 or category 2 that has the same name. I'm doing the search with a pop up value list in both categories. I would like to write a script that would automatically choose the same name in category 2 as I have initially selected in category 1. This would allow the script to pause, let me select name in category 1, and then proceed to choose the same name for category 2, complete the search and bring up all records where an individual will be found if they are in either category.

I need two different search functions in the same table. One of them must find all the words that contain the letters which are typed. One of them must however find the complete word that is typed. I have the first one. Can anybody helps me with the second one? Thanks,

I have to deduplicate large databases on a regular basis and just switched from fp5 to fp7. The script I had written for my fp5 database involved building a calculation field from the name and address fields, setting a global field to the calculation field and comparing to the next record's calculation field. If they are the same it sets another field with an 'x'. I can then search for the x's in that field and find my duplicates. It works great, but I am looking for 1. how to use the global field in fp7 (it seems vastly different than 5) and 2. is there a better way to de-duplicate my lists? Thanks for your help, I can attach a file if it will help.

HI. I have a DBase with 90,000 records with another 2,000 imported every fortnight. I need to find the same set of records every fortnight the only difference being that they are for the current fortnight's date. I can record a multiple find, but that doesnt help me get the current fortnight only. I'd like to be able to click a button and have a field pop up that askes which date I am after.... is this possible?

I have an extensive database of about 4000 names and addresses of patients. I am trying to figure out a way to list all the duplicate addresses on the list- I sometimes see the entire family as patients and don't want to send out mailers to everyone in the same household. I also see a number of pediatric patients. Is there a fast and easy way to both identify these patients and be able to send a letter to the parents, using the parents name? Your assistance would be appreciated.

I have set up a nice add and load found sets solution utiliting the copy records function - which works a treat! However! What I would like to add to this list of found sets is a list of found searches. For example say from our database you do a search for all contacts with a phone number in the Canada that are male - what is the best way to save this as found set?::? I suppose a solution would be to setup a database file which contains all the corresponding field names and copy the search string to them before searching and add in a field for the name? Is this going to slow the search down? Whats the easiest way to add it to my current found set list…

In simplfied terms I have a db with one field per record, 8 records. The values in that field are: record value 1 10 2 2 3 45 4 10 5 2 6 5 7 23 8 10 I want to be able to select (find) records that, between then, have ONE occurance of each of the value in the field. ie I want the find to return record value 1 10 2 2 3 45 6 5 7 23 It doesnt matter which of the records containing a non unique value is returned, providing o…

Okay, one more question. I would like to search for a range of values. Say, all companies with revenue between $10-20 Million rather than doing a search for discreet values. I figure there must be a way to do this, but I just don't know how. Thanks for your help. Karen

I am trying to find records in a portal by specifying more than one field value. eg: in a database of "farms" I wish to find every farm which feeds carrots to rabbits. So I need to find all farms in a layout whose portal shows "rabbit" in portal field "animal" and ""carrots" in portal field "food" If I enter "find" mode and type the values as above, this does not produce the result. Any clues as to what I am doing wrong" Steve

Is there a way to "mark" a field so that the program can go to the record without a find command? I posted a lengthy question in the Scripts forum but perhaps all I need is a formula to go to a specific record (without using find). Thanks!

Hello, I'm very new to FileMaker and I want to know if there is a way that you can do a search, and then save the results that it returns. Also if there is a way you can save the conditions the search is based upon so you can quickly do the search again and get an updated list of results. Thanks for anyone who can help. Cheers, Paul

Hello, i was wondering if someone can help me out with this, i bet it is easy one. i am trying to find the latest record of person base on the date it was create it. it is appointment db, client has more than two record and i want to show up only the latest record base on the date the record was create. i am funning fm 6.0. i want to set up script basically and have button they can click to do the find. Thank you, victor

Hello everyone, I have a question about doing queries. I would like to be able to select several fields to do a search on and then have a different set of fields show for a certain record. For example, let's say I have a layout with Company, Revenue, Type of Company, Website, Location, Profit, and Supplier Services. I want to be able to do a find for Type of Company and then be able to select to only view Revenue and Profit for the companies that are found, rather than having to view every single field in the record. Is there a way to do this? Thanks. Karen

Hi, I am new to filemaker Pro, working hard on it though. I have to search for records in a date range. I know how to do find the records, if I do a find from the same table. In my case, I have 2 tables - Clients - fields are :Client Id and Course ID Courses- fileds are Course #, Title and Start date. I could go to table Courses and search for records with Start date in a given range. (The info for this if anyone is interested can be found at - http://www.filemaker.com/ti/109090.html). But I want to search for records in Courses in a range of dates from the table Clients. When I run a script to display the found records in a layout in the Clients table, I ge…

I want to compound two operators to perform a search, but im having a bit of difficulty! When I did the greater than or equal to compounded with a less than or equal to, it worked like a breeze. But now I want to do this on a less than or equal to, or = to null. (this is on a date field). it always tells me that I have an incorrectly entered type of data if I do <= date =. Can someone help me? I don't want to create two seperate find requests either because I am modifying a previously created request. Thanks, Jim

I want to do a search that says if fields 1-10 are blank and field 11 = 0 then do something How would you do a search for this? (I thought of setting up calc fields for each field if (isempty(field#), 1, 0) then do a search on these fields for 1?) edit----------> Sorry just realised all you need to do is add "=" in to the field and nothing else works a treat Thanks anyway!

Hi I'm new here, hope to be able to contribute and help others in time. But first of all I have had a query from a user that I can't answer and was hoping you could help. The solution that I have has many fp5 files and many records. A user wants to search for strings of text that could be in any field (excluding summary, etc that cannot be searched). The user may not know the field that holds the correct search result and will not know where to search. Ideally we could have one place to enter the query and this would search each database and every possible field in each. Is there a way to do this. I can imaging that if there is it is very slow. …

So this might be a bit hard to explain but let me give it a go. I have a search interface in which you type the text you're searching for in a global field called "g_SearchText" and there's another global field (formatted as a pull down menu) called "g_SearchCriteria" where the user chooses in which field they will be searching. Now, in scripting the search I am trying to use the SetField function to put together a find based on the user's request. The function looks like this: SetField["g_SearchCriteria" , "g_SearchText"] Here is the problem that arises: When I use the SetField function to put the text from g_SearchText into the appropriate field, the function …

Hello (First post on this forum ) I have made a Bookmark database, a few users asked me for a automatic import from their bookmarks from IE to FileMaker. When i export the bookmarkt from IE to a TXT file and import that one to FileMaker i get something like this in one field <DT><A HREF="http://forum.fok.nl/" ADD_DATE="1066591175" LAST_VISIT="1091311200" LAST_MODIFIED="1066591180">FOK!forum</A> I think there's nothing to do with this, because the url have to copie to the URL field en the description to the discription field. Or is the a way the decrypt this text? Does somebody know how to import the IE bookmarks to FileMak…

I'm trying to set up a report that will display all of the students whose GPAs dropped by .5 or more from last semester to this semester. When I try to run the report, the program stalls. I'm assuming that this is because the field I am searching in is defined based on many layers of calculations and the values in it aren't stored. My understanding, though, is that I should not store this value becuase if I do, it will not update next semester when new grades are entered into the database. Is this correct? If I shouldn't keep the values in this field stored, do you have any suggestions as to how to run the report without having it stall? If I should store …

I need to find records for which a particular field is empty. I've browsed help, but I can't find anything. Is it possible? _Thomas_

Instead of finding a static value in a field, I need to find a value that is stored in another field. For examle: FieldA has the value "2004" A line in my script is Find, restoring find request .....I want one of those find requests to include finding in FiledB the value stored in FieldA, not the value "2004" When next year comes along, the user will not have to edit the script to change the year, but would just have to change the value in FieldA Thanks for your help. -Jordan

Hi Guys: I would like to know how my DB can search in several tables at the same time based in a request. i.e. I have the following tables: Medications, Problem List, Insulin Control, and Patients Info. How can I make a search of all the patients that have had Tacrolimus (medications table) and Headache (problem list) and Insulin>30 (insulin control) and Age=50 (Patient Info)? The tables are related through Ids. I pasted the fields in the interface table, created a find but they only bring one record not all of the records from all tables. Let me know if you have a way to bring all the records related by a record from all the tables. The result s…

I have a field which shows results from football games - whether a team won (w), drew (d), or lost (l). How do I do a search for consecutive wins. Hope I'm making sense. Many thanks.

I'm still a newbie, but at least I know that to AND constraints for a find request I put values on one form and to OR constraints I put values on multiple forms. But after I do all that work, how can I save and load that request (and previous requests) at a later time? I've got several books on FileMaker but none of them seem to explain how to do that. Surely a user wouldn't have to go through all the steps of a find request to repeat it! I might want to set up scores of different selections for a particular file.

Maybe because I'm a newbie in FM I'm postting this thread. I've 2 Privileges Sets that are dependent of the location of the users. I have a script that if the user is from the city A I make a search on the field "location" equal to A. But if the user from the city B go to the menu Records-> Show All Records he can view all the records canceling the search I make in the script... I want to permanentely filter the records and not allow to cancel the Find.... Thank u!

Gang- This post talks a great deal about Value Lists, but I'm posting it here because my problem is really about searching. I'm trying to script successive searches for a series of items in a Value List. Creating the Value List isn't the problem. Using it as a basis for a scripted search is. Here goes: I have a table that contains timesheet entries for a number of different clients. (Client, temp employee name, date, hours worked, rate, etc.) I have the timesheet table set up with summaries and subsummares so that if I manually search for a given client, only the timesheet entries for that client appear, the summaries and subsummaries do their job, and the repor…

Hello, I'm hoping I can do this, maybe someone can tell me.. I want to sort a bunch of names in they way ABC would be, but have the alphabet mixed around.. I've created a Value list that has my random alphabet, R,E,Z,M etc etc etc...but when I try to sort by custom order, it still does it by ABC order. It looks like it's expecting an exact match when comparing my value list to my last names. is there anyway to do an ABC sort, but specify the ABC order? thanks

Hi. How do you do a find for the newest records? I don't want to do a date lookup, because I don't want to have to go into the database and try to figure out when the latest records were created. All I want to do is display the newest records for each client I have. Can this be done via a find? thanks.

This should be soooo easy and of course it is not. Must be something simple I am missing. I have a FIND form where users can enter partial names and all possible matches come up. Then they click on the one they want. BUT now I want to EXPORT just that record. However, the FIND still says there are X number of found records. So when I do an EXPORT it happily sends off ALL the records. How do I get the FIND or EXPORT to just take the 1 record I selected?

In my sales quotation layout there are 12 lines of data that contain Part Number, Manufacturer, Qty, price, price ext and delivery comments. So, each record can contain up to twelve part numbers. I need to be able to search from a list view for a part number that hits every current record and each Part Number field within the record to arrive at a found set. Can someone please steer me in the right and easiest direction on how to handle this? Thanks in advance

I imported data into a FileMaker Pro 7 database. I want to search a particular field and find all the records with more than 10 characters, including spaces, in it. How do I use the Length(field) function to search in that field?

Hi Everyone! I have two global fields of type 'date', that are used to input two dates from the user. I needed a script that will take these two dates and perform a find operation so that I get all the records within these date ranges inputted by the user. The problem I am running to is that I am not able to put "field1...field2" in the date field in find mode. Thanks

Hey guys, I have a text field where I want to search for records where that field contains "foo" or "bar". what's the file formatting that allows me to do this? thanks! Steve Griff

Hi, I'm sure this is a basic question, but I can't figure it out. I would like to do a find that compares the values in two fields (for instance, work address 1 and preferred address 1) and comes up with those records that have the same values in the two fields. I'm doing this over a network, so I don't have the option of creating any new fields. Thanks, Tiger

Here are my fields: "Date" is defined as a date field in File A "gDate" is a global (date) field in File B And this is what I'm trying to do: Enter Find Mode [] Set Field ["Date", "">="&File B::gDate"] Perform Find [Extend Found Set] But I noticed that it instead inserts weird numbers with "/". What is the proper way to insert a " >= " in a date field? Thanks, Chard

This will seem trivial to most of you pros, but here goes: how I can select all companies beginning with the letter A (or whatever). Suppose I have two companies in the file (ACME Co., Easy as PI). If I use A* in the Find Request, both records are found, not just ACME. Ditto with "A*". I've also experimented with @ and other symbols; nothing works right (either all of the records are found or none). How can I use * (or something else) to mean all the following letters and words in the field?

It seems i dont know how to make a simple perform find script. This is what I made and it doesn't work. Enter Find Mode [] Set Field ["Job Order #", "Job Form::globalJobOrder"] Perform Find [Restore, Replace Found Set] Can somebody tell me what I did wrong or what I missed? Thanx, Chard

Hi, In find mode, the "Enter" will activate the "Find" button. Do you know if there is a way to trigger a layout button (and/or a script) in place of the "Find" button? Thanks in advance, Pierre

Hi! I want to be able to find a specific number in a number field that can have a range of number. For example, if the value of that field for a record is "420...700", or "500...501", or "500" , I want to be able to find that record by performing a search with the value "500". I thought that by just entering the data with the dots (...) it would work, but it just returns the records with the specific value I search. Is there another way I should enter my data, or perform my find?

I'm trying to script a phone directory. I start with taking the user to a layout in find mode with the possible/relevant fields to specify the people to be included. The script then performs the find, but before displaying the results, I want to constrain the found set further by specifying that this is the phone number marked as preferred for directory use. Contact numbers are stored in a separate table from names and addresses and each individual might have anywhere from 1 to a half dozen or more phone numbers, email addresses, etc. On the main data entry screen I use a portal to create these phone/contact records and include there a checkbox to specify if the number is…

I have a drop down contain groups Group 1 Group 2 Group 3 What is the easiest way, without doing 2 searches, to find all the records relating to Group 1 and Group 2 (or any number of groups available in the list) Thanks

Hey, I'm tryin to write a script that will do a find on "Venue ID" ... however the field is a Serial Number (type field) with the option of NOT allowing users to modify. So, how can I go about preforming a search when I can't even enter the Venue ID field in Find mode? Yikes! Thanks for any help!

I need to do a find using an "And" "Or" condition. I have five fields. This criteria needs to be met for the record to be accepted into the Find results: Field1 > 0 "AND" Field2 > 0 "OR" Field3 > 0 "OR" Field4 > 0 "OR" Field5 > 0 How do I accomplish this please. Regards, Brooke

I have a contact database with multiple tables. Is it possible to search the entire database and find all of the contacts in the same city (for a mailing list)? I can't search more than one table at a time. Can I search multiple tables? Thanks

Problem....someone enters a new record no one else can look at it until they navigate away from it. Is there a plug-in or something I can add to make sure that someone comes out of the new file. Ideally something that refreshes it and takes someone out of the file they are locking? Thanks

I am doing a Find on a date range. That works just fine. BUT when I do a Sort, even manually, it does not sort. It does change the order of the Found but not in alphabetical order. The fields I have are LNameFName and Exam Date So manually I entered a date range and did the Find. Then I did a sort on the LNameFName but it just seems to stir it up, not sort. What simple thing am I overlooking?

Hello! I

If I have a found set or current record that I need to reference from a vbscript application, how would anyone suggest I am able to accomplish this?

Hello, Is there a way to control which layout a user is taken to after they hit the "return" key to trigger their find? I know I can take a user to a search screen and give them a "Find Now" button after they enter their search criteria, but if they hit the return key instead, how can I deal with that? Thanks Dave

I have records with the field "Call Back Dates" that has the date when I should call the person back. I would like to find all the records that need to be called back in the current week. Can you suggest how to construct a script that would take a date (Current date or entered date) and display all the records that should be called in the week containing that date? For exmaple, if I were to enter 6/22/04 or 6/23/04, it would display all records that need to be called from 6/21/04 to 6/27/04. Is there a way to display records for that week AND the dates before? (In case I missed calling someone last week)? Thank you!

I may be missing the obvious, but I have just spent an hour trying to get a "Find" that returns all records AFTER TODAY'S DATE (in a date field). What is the syntax I need here? Thanks!!! Head is sore from batting against wall!

I wish to export the 4000 records in my FM Pro 6 database to xml format. I use non-breaking spaces in a title field for identification purposes. When the exported file is opened the text "Merck & Co." appears as "Merck

Howdy all, I've reached a bit of a dead end with an idea I want to implement in my FM7 v2 database. Here's my situation and what I would like to do: My database consists of multi-page forms that the users fill out. Each form has its own table due to the large number of fields required per each form. One field (Job#) is present in all tables and I've used it to relate the tables together. I

OK, so maybe this is the lamest question ever, but how can I do a find for all records that were created on a certain date? Does Filemaker 5 keep track of this? What is the field name? Does it have to be included in the layout to be serachable? What is the best way to build this find? I tried looking through the forum but counldn't find the answer to this question... probably because it's a really eay solution and a no-brainer and no one else needs help with it. Still, I could use the boost... so please post an answer if you can... Thanks! --Charisma

Hi, I have a database holding information imported from a vehicle data collection system. Each record consists of information collected during one workshift. The data includes driver name, date, total distance,information on driving, loading etc. times, speeds (max, average, at different RPMs), fuel consumpition (total, MPG, liters/100km) etc., as well as summary and average fields for most of the data. Now I'm trying to figure out how to show data for comparing different drivers during user defined period (for example, during last month) on several factors, such as: - driver's average fuel consumption during the time period (across the varying number of…

Hi there, i have a global Year field where user enters Year to find matching records. How then do you find records that match that year, when the records Date fields are of the format 31/12/2004? When I go to do a find just using the Year, I get the error message about the date format being wrong. Wildcards don't seem to help. What am I not doing? Thanks

New Filemaker user (old Access user). I have a yes/no field, which when sorted for no yields some yes records, with mostly no records. What did I do?

I am new here and have tried to find a solution to this problem by searching, to no avail. I have a Records DB related to a Contacts DB. In the Records DB I have, say, a fax cover page. I type in a last name to locate and insert all pertinent contact info from the Contacts DB (first name, company, fax #, etc.), however there may be many people with a same last name in the Contacts DB. Typically the wrong contact pops up and fills the blanks, so I currently have a pop-up menu listing all people with matching last names and I can pick the correct contact from that list. It is not a very elegant solution. I'm about to release my DB's to the whole office to use, but I ne…

I have been looking at Filemaker 7. I have run in to a snag with the "Perform Find" script step. All I am trying to do is create a button that will find all the companies that start with a letter. So I create a script to find the letter "A". Script steps: Perform Find [Restore] I specified the find criteria in the script step by creating a find request. Setting that request to: Action: Find Records Find Records when: Customer::nameCompany Criteria: A* Now, when I run this script I always get no records found, even though the a record that matches this find exists. Can anyone help me this new method of setting up find in…

Hello, I was wondering if someone can help me figure out why the sorting of time schedule doesnt work for me. I have database to schedule appointment. Here is a list i have for the time: 9:00 AM 9:30 AM 10:00 AM 10:30 AM 11:00 AM 11:30 AM 12:00 PM 12:30 PM 1:00 PM 1:30 PM 2:00 PM 2:30 PM 3:00 PM 3:30 PM 4:00 PM 4:30 PM 5:00 PM 5:30 PM 6:00 PM 6:30 PM 7:00 PM 7:30 PM 8:00 PM 8:30 PM When i got set up as check box. I have summry report to print daily but when i go to sort out the appointment by time this is how it sort out it show all the 9:00 AM Than the 7:00 PM Than the 11:30 AM i am …

I have several fields which I want to be able to search with, but i don't want it so that the search must satisfy ALL of the criteria. In otherwords, i want it to search for field 1 and/or field 2 and/or field 3. So for example, if field 1 met the criteria, but field 2 did not meet its criteria, it would still bring up that record. How would I go about doing this? Thanks a lot! Jim

How can I tell, from within a script, if the 'Omit' option is selected on a find request? Something like Get(OmitState) would be great, but I can't find an option like that. Thanks, Dan

I am not a filemaker developer or very technically savvy with the system, but I need to perform an "AND" request in a repeating field.... but in find mode you are only given one empty field to enter your find text.... Is there any easy way to solve this issue? Is there an "AND" request function or something? Just as an example: I want to find in a repeating field records that are labeled "Education" AND "Science" , but given that there is only one field to enter information on in find mode I have to perform the find as "Education" then add new request "Science" and then scroll through to find those labled both. There must be an easier way.... please advise if y…

I need to perform a find that will find a record that meets two criteria. One of the criteria is static, for all cases of the find to be performed. The other criteria is for a certain ID number. I have a layout were the user types the desired ID number in a field (I have set it up as a global field). When they click a button, it runs a script that should do a few things among which it should perform a find for records with the ID number they request. How do you do this type of find? The only finds in scripts I know how to do are pre-defined find criteria. Also, is there a function I can call to see how many records are in the found set....to make sure the found…

What is the easiest way of saving a found set which can be called back at a later stage??? Thanks Simon

I'm pretty new to FMPro so this might be a dumb questions. Say I've got a recipe table with a related ingredients table. If I enter find mode and type "beef" in the recipe name I get all recipes that contain the word "beef" anywhere in the name, like "BBQ Beef" and "Beef Stew". But when I do an ingredient search for "beef" in the same layout I only get records returned where the ingredient name is exactly "beef". "Beef steak" and "ground beef" aren't found. I know that my relationship is set up correctly because if I search for an ingredient like this: "*beef*" I get the expected results. Am I doing something wrong? Is this just a quirk of FMPro? Is there a work…

On my lay-out, I want a field which represents the number of found records, so when people who are browsing know at which record they are (current record, that is possible, I know) and how many records there are left to do. It's the same as in the status-area, I know, but when other people are using my database, I wanna get rid of the status area.

I have a search layout, when the script goes into find mode and I enter the criteria I want it to then copy that search citeria into global fields, without having to make all the search fields globals themselves, that would be too much work. I have tried to do a 'modify last find', and then 'insert calculated result' from searchfield::firstname to globalfield::firstname. That only works if there is an actual match in the database. Forinstance, if I search for: Last name: Dreese First name: Dan [script runs] g_last name: g_first name: If there is no match in the database, it willnot copy the information to the global fields. Like I…

I have a list of serial numbers in a file. I would like to sort them so could make them randomized. Is this possible in any way? Thanks

I have 2 files contacts and company I want to do a consolidated search in the company file. which is fine for companies but not for contacts. When I do a search for a say "page" in the surname field it returns the first person in the company which contains a contact with the surname "page" Is there anyway of getting a full list of all the "pages" without having to use a separate search layout in the contacts file?? Thanks