Finding & Searching

I hope I'm in the right section... I have a list of 50-100 thousand words. I want to strip out all words found in the dictionary. Is it possible to somehow load a dictionary into FM and compare field data to the dictionary words? Then somehow pull out all records containing a word from the dictionary?

This is my first post so be nice. How can I sort by word length. Example: at hat a here television alarm sorted --> a at hat here alarm television I haven't used FM since 1990 so I am rusty!

Hi all, I am looking to sort based on 3 fields for a movie application. My fields are scene, take, camera roll. my sorts based on all 3, yield the following sample data: 2,2,a2 2,2,b2 2,3,a2 2,3,b3 The result I want is: 2,2,a2 2,3,a2 2,2,b2 2,3,b2 I also have tried a calculation --scene& take&camera roll. the results are the same. Any ideas? Ian

Function Get(FoundCount) returns total of all records. Why I cannot get current (actual) count of Found set with this function? (FileMaker 7)

Hi First of all, I'm new and I'm sorry for my english... its not my nativ language. So I hope I can make myself clear here : Since I was searching this forum for several days and tried out different things, I thought I'll ask here since I still didnt't get to work it. The idea is of a basic Budget Template for myself (this way I thought I can get into FileMaker and can design my own Layout Question: I have 3 fields (dropdown boxes): - Income ("Einkommen") - Expenses ("Ausgaben") - Year Now I want to make a search to for expl show all records with the date "2006". (I got that so far) But how do I now resarch (narrow) this Find Resu…

I am working on a solution for a client that is using FM5.5. There are about 700 records and 500 fields. Is there an easy way to get a list of the fields that contain no data in any record? Any help ASAP would be appreciated.

Hi! Let's say I have a number value that is from 1 to 10. (1-2-3-4-5-6-7-8-9-10) I would like to be able to find it when I search for 4 I know you can find number from 1 to 5 using find 1...5, but is there a way to do the inverse.... like, I would like to the field 1...10 when I search for 4.... I hope I'm making myself clear, thanks y'all!

When I do a find for particular records, I seem to lose the sorted state of my records. Is there a way, where I can retain the sorted order Date (desc) when I click on the find button in the status area? Thanks

Hi, I have been playing around with filemaker Pro 7 for a while, but would appreciate some help. I have spent hours and hours reading post here but found nothing that directly relates to what I wish to do. I have watched the video tutorial on this Rapid file searching (Zippscript) topic, several times however not understanding programming I am at a bit of a loss as to how to alter it to search more fields in the table. (i.e. ‘Supplier2’, ‘Supplier3’ and so on. It currently only looks at ‘Supplier1’ field. The tutorial video did mention it was possible to do adding more global fields and narrowing a search (with the users adding more data narrowing th…

The title is a little misleading. I want to do a search for some records, and then the records I find, I want to do a search using the ID from each record found and then do something to that record that is found. I want to keep doing this until I have gone through each record found in my first search.... so. Search 1 (finds 5 id numbers) loop Search 2 (find all records containing first id number of first search, based on two fields, so it will only find one record) Do something to that record go to next id in first search, place that id in search 2 and keep going until all the records found in first search are done. end loop This is a very si…

Apologies if this question is in the wrong place... I'm new to the site and this seemed the most appropriate forum. I have created a database with a table of 'pupils' and a table of 'payments' that pupils have made. I have defined a relationship between the tables. I have created a field called 'ID' in both tables. I want to have a field in my 'pupils' table that shows the total amount paid. I think the structure should be something like this: 1. Go to to 'payments' table 2. Find all records with 'ID' field value matching that of the 'ID' field value of the current record in the 'pupils' table 3. Take the value of the 'amount' field in each of those re…

I want to do a general search of several fields based on the value contained in a global field. E.g. I want to end up with a list of all records that have the word "cow" in the "topic" or the "description" fields. The word "cow" is in a global field in the header. Or is in a button in the header.

I've got a DB where perhaps 10% are duplicates of other records. There's got to be an easy way to filter out the doubled or sometimes tripled records. I think I've pulled out 1/2 my eyebrows trying to come up with a solution... argh! thanks -ryan

How do I display only unique values for a particular field? For example, I have a name field that appears several times in a found set. How can I display only one record for each individual name and create a list of those individuals who met the search criteria? Thanks.

Hello again, Question of the day. Is it possible to search over numerous dbs and fields, a general piece of info that is not field specific. Example, I am looking for all Davids in 3 dbs in any of the fields in the any of the DBs. I also have value list check boxes that define certain qualities for David that correspond to each db i.e. thin, blond. I wish that the result be displayed in a new window and the results have either all or any of the above criteria. I presume this can be done, but for the moment, I can only get a result via one db and through specific fields that corespond, not via a single, global field. Thanks in advance

I am in a layout list in browse mode which shows 12 records from a find. I would like to place cursor over one of the 12 records making this the active record and then go to a new layout which would show only this record. I can get to the new layout and see this record but the record is one of 12 still in the found set. I would like to have this current record be the only found one. Can you somehow find on the active record?

I would like to create a script to attach to a lyout that would find all records that have a date of todays date - 6 days. I am stuck. please help. thanks

I have a database with 7 fields. 6 are text, and 1 is a number. This number field has the job cost as a decimal. If I search this database I get about 70 results back on average... how can I have filemaker sum all cost fields for the search result?

Hello FM people, I have another luddite problem that I am sure is in the manual somewhere but I can't seem to find the solution (Fm is devilishly complicated). I have 2 databases that have similar info. I wish to search both the databases with via a 3rd DB using portals. I wish that the result of the search be opened in new windows via the original DBs. In short the 3rd DB is just a "collective serach window" on the 2 originals. I have managed to create portal links from both original DBs in the third using the "relationships" window. I know that the relationships work. To complicate things, I have 2 "checkbox" value lists, one from each of the old DBs. I have cre…

I have used Filemaker 5 but am new to Filemaker 8 and am apparently having a brain freeze. I have created a db from an excel spreadsheet and have discovered that there are quite a few blank records. I have been unable to find a way to 'find' those records so I can delete them. Is there a trick to doing it or am I missing something. Thanks Elliot

Hello, I currently have two tables, one for students and one for classes. I would like to create a dropdown box on my students layout. When an option (class from a student) is clicked, then the layout from classes should appear with the correct portal. Can somebody help me? I included a sample file for your convenience. Thanks in advance, regards, D2C classroom.zip

Happy new year to all I am having a problem performing a find on a sales order number the number is made up of two alphas and some numberics ie R0612345H01 all our numbers begin with an alpha R and the letter where the H appears can differ. My search criteria Is *h however it will only find the result im looking for if the R is removed from the sales order number. is the * only looking at the first letter occurance? im at a loss as to how to go about this. any help would be great thanks

Hi ! I have a problem when finding records between two timestamps. I'm sure this question has been here before, but currently I am behind VERY slow internet connection here in Kabul and it takes time to browse previous postings. In my database there is always a timestamp in each record. There is also fields gStartDate, gStartTime, gEndDate and gEndTime. In a script you can set these values. But for some reason I just cannot Set Field "Range" in Find mode... Arttu

Hi We know F1 key is for 'help'. But anyway can i set certain ket for certain functions?? like close the file..? Thanks a lot.. Cheers, Kelvin

Hello All, I have a checkbox field(global) with about 12 options in it. I want a user to be able to have some number of of the boxes checked and then be able to print all the records that are in the categories selected. I have setup a find to do this: The find is setup like this: Enter find mode Set Category = gCategory (the field where user has made their selection) Perform Find What is happening is that filemaker is trying to find records whose category is ALL the categories selected - of which there are none since each record only belongs to one category. In other words, the search is being treated as find CAT1 and CAT2 and…

I've got a database to keep track of IP addresses and I need to sort them by IP. The problem thai I'm having is that I've got more IPs than I can fit into a value list.

I have a data file. My primary field is the job number field. I want to find all duplicates that have the same job number. Is this the correct way? Find Mode in the job number field I put "!" press enter This should find all duplicates in that field. Yes or No or is there another way? Thanks

Using this script I can't seem to have the report under Layout Y refresh with the new found set. I have tried modify find - use first records - refresh window. It's still holding onto an earlier found set Go to Layout X Show all records Enter Find Mode(user then determines found set) Pause Go to Layout Y Enter browse (pause) Go to Layout A Thank you

In MS Access you can right-mouse click on on a field's entry in datasheet mode and include or exclude all other records therefore quickly filtering records. How do you do this in FileMaker?

Hi guys, Ok so i have a calculation field called imagedetails that looks at image using the getasText function and this is what is coming up for it. size:184,245 image:6028.jpg imagemac:/6028.jpg So what i want to do is do a search for images that have a bigger height than their width and visa versa. I cant get my head about getting the substring to work as the image height or width may have more that 3 digits.

hi everyone I'm new to this FileMaker caper [ms access background] and am having trouble getting my head round a few things... I've got a table that stores information about surgical operations [type of procedure, surgeon] I'm wanting to generate a table of summarised data - see below _____________surgeon1__surgeon2__surgeon3 procedure X______4________2________12____ procedure Y______12_______3________6_____ procedure Z______5________2________9_____ any ideas? any help would be appreciated! cheers Tim

Ok, now that I have found thousand of different duplicates, is there a way get rid all but the latest record for each duplicate. For example: Found Records 7855 7855 7855 6854 6854 3397 3397 3397 etc.... In this example I would like to delete all EXCEPT for the last 7855, the last 6854, and the last 3397. Is there an easy way to do this? Thanks

[Attached is a working FileMaker 7 file, in a very early stage!] I want the user to be able to search the database by specifying 3 different cities, states, and/or codes. Right now, once the user selects a 'NAISC code', for example, all of the fields are entered. I'm not sure how to fix this. Can anyone help? Thanks. ipv.zip

I have a database that was updated from, ahem, FileMaker 4 to FileMaker 8. The upgrade seemed to go fine. However, one of my users has just encountered an odd behaviour in Find mode. There is a field that is set to display as a drop-down menu containing values from a Value List. She is trying to find all records that have a specific value in this particular field. When she does the Find, she gets the results that no records match the request. However, I *know* there are records that have the particular value in that field. In fact, 727 records out of 4350 have that value. If I select "Find Matching Records..." on a record that has this value in this field, I find all of t…

I would like to find records that match one field to another field. I have three fields. ID1 Name ID2. I would like to find any record that matches ID1 with ID2.

I've created (as part of a larger database) a staff list which contains, amongst other thing, staff statistics (for sales purposes) and personal details. If a member of staff with low access privileges access the list, the can only view this data fi they are looking at themselves on the list. Those users wit high level access can view anyone's data. My problem is the mouse wheel scroll, because once i've restricted the user's view of these data pages to only theirs, they can still use the scroll wheel to view anyone elses' in the list. Anyone got any ideas how to disable this function or find a work-around?

Hi, i am using Find that is working perectly . The ersult is there... Only I have to display the result to a report - (summary Report) . I am using summary fields.. to display the calculation result. The file has more then 300,000 records. Every time when the user signs in the summary fields are "summarizing" long time.. Is there any other way of showing the result in a report? Maybe if i do not use summary fileds it will be better.. any help and idea is appresiated. thanks, ;)

Ok, I have a really messed up database for a client, but the software program they use means I cannot change the relationships. There are two tables both use a pk that has multiples of itself in both tables. There is no way I can get around this either. I thought of creating another table and putting unique values from one of the id fields in it so I could reference the second id, but I am not sure how to go about getting unique fields from the other table without using sql, but I guess filemaker doesn't let you just use sql in the database without setting up an odbc connection to a database first. So my question is, is there a way of getting unique entries from a f…

Hi.. Each record created by user will be auto assigned a file id. And i have a layout to show all the info of the records in table form, 1 of the field which is the file id. e.g. i wish to obtain record by a search lets say the file id is 1222, how can i actually do it? call for the form layout and search by file id on the layout..?? Help needed.. Thanks a lot.. Kelvin

Hi all, been searching for the answer to this but cant find it. I think I've seen it in a demo somewhere though, but I can't remember where... In my customer database I would like to have a list layout with all companies in it. On that page I want a field where I can enter a part of a company name. I want the list to return only the companynames that contain the letters entered, in that order. If I add another letter, the list shall again only return companies with that combination of letters. Any tips?

Hi Everyone, In my database, I have given users the ability to perform a search with a special layout based on whatever criteria they choose. Results are presented on another layout in list form. On this list layout, I would like to give users the options of narrowing down results from their search. Ex. show results from the find that are equal to a certain value. Thanks

Hello, I was wondering if someone could help me out with something that might be very elementary. I have a database of teachers each with unique IDs which I regularly delete and repopulate from data on our server. There are a couple of flags that I place on my end on FMP which I want to store on a related file with the IDs as the matching field. I pretty sure I've set up the relationship properly because I can click on the checkboxes on the main file and the related checkbox in the related file checks on. But, when I try to find records with the related checkbox checked "on" on the main file, I get a message telling me that "one or more of the rel…

Can i perform a search and replace on the 'return' character' and replace it with for example What is the wildcard for this character? Thanks

Incase you come across this problem... Took me a while before I was able to figure out why I couldn't use the search all records when using the Open Find/Replace script step. Simply unlock the Status Area [Hide] using the Show/Hide Status Area script. Set the Status Area back to Lock after the Search if needed. Hope this helps.

Is there a way that when a customer goes into find mode, they can view it in list view. So for example: Customer puts in Manufacturer in find mode, the customer wants to be able to see all manufacturers at one time, like a list view. But then say the customer now wants to see certain customers and there are many of them. So instead of clicking through the records they can look at it in a view mode. Do I need to have separate view modes or can one be used for whatever they are searching for? Hope this makes sense. Thank you.

I am trying to sort all records by first name, alphabetically. Some of the records have no first name entered, the field is blank, but I still want them to come up in the sort- but I want them last on the list. This seems like it should be simple but I can't figure it out. The only way I can get those with empty fields to the bottom of the list is to start my sort from Z rather than A. I need A - Z, then blanks. Any help would be appreciated. Thanks,

Hi all, Lets say there is a customer layout that has a portal that shows all records from a category table. This category table only has two fields, category_name and CategoryID. There is a third table that serves as a basic line items table. This table stores the CustomerID along with the CategoryID. So, the basic functionality on the layout is that there is a portal on the left side that shows all the records from 'Category' (relationship Cartesian Product). When a user clicks on one of the portal entries, it basically adds the CategoryID to the line Items table for that associated CustomerID. The portal on the left then shows the related records from the curr…

I have a set of criteria that I want to search my db for - search one field for many entries. I want to return a set of about 300 records. I have not been successful in getting a large "OR" search to work. Can anyone help me. I'm new, so if there's any data I need to submit, please let me know. Thank yoU!

I know this should be rather easy, but I am blanking on this. I want each person to be able to pull up, either by script or a calculated field, all the tasks due for a week beginning every Saturday and ending every Friday of the year. Should I do a script, have my weeks of the year in a lookup so I only have to change the lookup every year? I was thinking of using a script with something like this If...then statement: If(task1 is equal to or greater than 11/5/05 and is equal to or less than 11/11/05, task1, If task2 is equal to or greater than 11/12/05 and is equal to or less than 11/18/05, task2.....through every task and/or week of the year??? That is where it becom…

I have a database of email addresses. I'd like to randomly select one email address for a contest I'm running. Any suggestions how to go about this? Thanks. Chris

I'm trying to develop a script that finds specific records by date and then constrains the find to those where "Send eMail" field has been checked. I can find the dates thanks to Fenton and LaRetta, but now what seems to be a simple extension (or constrain) just won't work. I have tried setting the field to both Text and Numeric and it will not find the records. Please help. I've uploaded the text of the scripts in question. Thanks. Script_Name_FollowUp3___followup4.txt

I need to do a find based on the first letter only. The database is a book list with author, title, publisher, description, price. I want to be able to find authors beginning with A and export that set, then authors beginning with B, etc. When I do a find in the Author field using either A or A*, I get all authors with an A anywhere in the name. I want to find only those whose name begins with A. Thanks!

I am brand new to the FM world and have a question... the database has 16 groups of fields.. each group has a FirstName, LastName, Male/Female, Age, and Misc. field. How can I search by last name in general instead of typing in each of the 16 LastName fields to find the person I am looking for? Can I somehow make a master sheet that would have all of this info alphabetically from all 30 records? Thanks for any help! Chris

I have a Dealer management system I am developing. I have a pop up box that lists contact names for manager, buyer, and installer. I have another form that allows the user to add all three of these, to a contacts table. I want to have only those people who are listed for a specific company (from the contacts table) show up in the pop up box on the Dealers screen, also sorting by installer, manager, and buyer depending on the popup box. I have done this sort of thing lots using php, access, c#, Java, etc... but this program just doesn't seem to be very user friendly. I can't find anything when it comes to these basic functions. If you can help me out with this it would be …

Is it possible to do DB wide search? Like search all layouts, all fields and all tables at the same time for a particular word or name? I guess you might call it a Global search. If it is possible, how would I go about doing such a search. Thanks for any help you can provide on this issue. Mike S.

As I build my database, i constantly run into problems that my brains can't figure out all alone. Anyway, I have a "last call" and "next call" field with buttons. The "last call" field inserts current date (fine..no problem. super easy to do). My "next call" field/button brings up custom dialog for "one day," "3 months" or "exact date." Regardless of that, I need to specify a calculation that if the next call equals a Saturday or Sunday, automatically inserts "Monday" into the next call field. Do you follow me? I hope so. More importantly, do you have any suggestions?

I want to be able to find an exact match from a drop-down so, for example, when selecting "Home" from the drop-down in find mode, records for "Home improvement" aren't returned as well. However: - the find is done using a scripted button, not just entering by find mode manually - users can only select values from a drop-down list (so can't type in ==) - users don't have access to the status area - the file is accessed via IWP, so the drop-down stays in drop-down mode (you can't type in the field in find mode). Any ideas?

Does anyone have a good example of how to build search queries. We have an application with many tables and relationships? We need a good interface to do complex searchs without having the knowledge of the underlying table relationships. An example in the mySQL world would be many of the client programs for accessing mySQL tables. Any suggestions appreciated

How do I block a user to perform a find by hitting the enter key? I want them to only use the buttons for adding another find request, cancel, and perform find. I dont want the user to be able to hit enter and perform the find because I use s different layout for finds. If the user hits enter they would get the results on the wrong layout. I have tried to hide and lockout the status area but that did not stop the user from performing the find when they hit enter.

Description: I am a new user of Filemaker. Have been a Lotus Approach user since version 1. I need help with finds and scripts for automated finds. First, is there a way to do a straight out find for multiple records in the same field? A basic OR search. I have a field named "Jobs." It is a number field. I want to search my contacts for all those people I have talked to about these jobs. In Approach I would click on the "Jobs" field and type 190,192, 198, 202. It would return all contacts with any of those ID's. How is this accomplished in FM? I cannot find any discussion of "OR" searches. Second, I have tried to make a script to s…

I'm using FM 8 and need to change curly cue quotes to regular quotes for export to a html template. I can do this without a problem in the normal search and replace feature of FM however, I have not been able to do this through the script step search and replace. In the normal search and replace, you can type in the curly cue quotes and the regular quotes without quotes. However, in the script step, the program forces you to include what you are trying to find within quotes. The funny thing is individual apostrophies work correctly either way. Am I simply overlooking something or is this a bug? TIA

Hello, I am having trouble with trying to perform a find function to find all non-numeric in a text field. Example: 12aa78 65g The number and letter can be anything. Thanks in advance for your help.

I have a fairly large number of fields (126) that I am importing. These fields belong in a variety of different tables within my application, therefore the only way to bring them all in at once is via a separate dedicated table. I then need to be able to move that data to the different fields where they really belong. The only problem is that some imported records may be partial duplicates of existing ones in my database (requiring an update of that data), while others may be new records. How can I begin to manually script this merge-purge procedure?

How do I do a greater than on a text field with a month name in it. Like > november. I want it to equal december how do I get it to do that in a search. Thanks Tony D.

Hi Everybody, So here's my little problem, I have a database to organize a school guidance office. There are four guiance counsellors and 20 slots in which students can book appoitnments (4 counselors x 20 slot fields = 80 fields where appointments can go into. I know this is a bit of a weird system but it has worked amazingly to date (although the next version will have portals probably). Here's my situation, the counsellors would like a way to search EVERY appointment slot in the system. However, is there a way that I can set one field where the user enters the search string into and then have the text copied from this one to all the 80 other ones? I'…

Hi - I am trying to set a caluclated temporary number field equal to an amount of a donation if the donation meets a number of criteria date>5/31/05 and <10/31/06 amount>249 status>new I am using an if statement with Criteria #1 and Criteria #2 etc. but can't get all the conditions evaluated, particularly the date. I think I am missing something basic. Does someone have a suggestion? Thanks

Hi all, I have to carry out a global search in Filemaker6 database. I have a table with 10 different fields but I want to create a new form with a text field where the user can input some free text that will be search in all fields of the table to return any values if they are in the database. Can anybody help me? Regards

I have created a simple database for the school nurse at my school. I have a layout named Data Entry with approx. 100 checkbox fields. The nurse checks the box for symptoms, etc. I also have a layout called report that shows a count of all fields from Data Entry. What I'd like to do is give her the ability to enter a date to get a daily report, then at the end of the month, get a monthly report for a specific month. This newbie is having trouble figuring this one out. My date field is simply called date and is populated upon record creation. Any help you guys could give would be super. Thanks.

Ok guys... since you came to my aid and solved my other question so quickly yesterday, I am gonna rely on you again... I have a field in a table which contains several entries of data in each record... Each entry is a series of letters and numbers, following three types of formats (# are digits). 1. FBgn######## 2. CG#### (eg. the letters CG followed by 4 digits) 3. CG##### (CG followed by 5 digits) I need to do a find/replace in this field to find all occurences of a CG with either 4 or 5 digits and remove it (replace with nothing). I have tried using wildcards in the find/replace function, but they dont find any of the CG's. Any ideas?…

I have one field in a table which has many different values (text) separated by commas and a space. In order to be able to search each value in that field seperately, I need to replace the comma and space with a carriage return. Thus, instead of seeing: Dog, Cat, Rabbit I need to use find/replace to give me: Dog Cat Rabbit Can anyone tell me how to do this?

Hi guys, This is the first time i've had to use line items and I have a bit of a searching/reporting quandry. I hope I write this so you can understand what I'm trying to get at! The attached image is a screen shot of my database (don't flame me for the grey colour scheme - it's the clients colour requisite!!). So two tables lets call them 1. Record Items 2. Line Items I understand completely that if I want to find information based on Line items - then i go to the line items table and do my search. The issue is, what if the user wants to just search on a field in the record items - lets use field 1 (as shown on screenshot), then whilst I can…

I have a table with FirstName, LastName, address fields, etc. On my layout, in addition to these fields, I have a pop-up populated by a value list of all the LastNames. Next to this pop-up I have a button labeled "GO". Once the user has chosen the last name from the pop-up for the record they want to navigate to, I would like the GO button to take them there. Is there some simple script that I can attach to the GO button to do this? I know how to attach a script to the button to go to next/go to previous, but how do I go to the record where "LastName" = the name the user has chosen from the pop-up? THANKS.

We have Get(RecordID)and it returns a unique value that never changes. But having stored it in a variable, I would like to safely find back to it from wherever I am, not having to care about much else. I which there was a Go ToRecordID command! -- One hour has passed and I discovered that the value in Get(RecordID) is the same as a records Auto entered serial number, what a surprice! Can I trust it's always so?

Hi My database is a project database, where a repeating field is used for all the individual parts of the project and the first field is basically used as the overall status, except when there are more than one part in the project. A project with only one part uses just the first field. A project with 10 parts uses 10 of the repeating fields. Where the first is used as overall status. Problem is when searching for open and closed projects. A project can have closed parts, but still be open, which means the first field can be open, while some or all of the parts are closed. I have a script, which is supposed to show only open projects. It does so b…

Does anyone know of a set of external date functions like Most Recent(), Oldest() etc that could be used in date calculations for a fundrasing application? Can you import custom functions into a basic application?

Hello everyone this is the first time I am placing a post, I am having problems with a simple search between dates in one field, something which looks simple but not for me. (I have downloaded the version 8 actually using V.6) I have created a table which includes daily sales with the corresponding dates. The find search for sales of September is simple 01/09/2005...30/09/2005 how could I do this using a custom dialog with scripting where there is only one field with the dates? (Salesdate)

When doing a lookup or replace for a group of related records, is it faster to first sort one/both groups according to the sort order of the relationship, or not?

This might be really obvious to some of you but I am really stumped - I have a found set, say 20 records from a DB of 100, and I am looking at them in List mode. I want to have a single button in the header or the footer that will populate a currently empty text field with a common piece of text in ALL of the found set. I cant use a global because I only want to populate the found set and so far I have only managed to populate one record at a time. Is there a way to populate ALL of the Found Set ONLY in one action?

My database has two container fields, used to store pictures. How would I perform a find, or write a script to find all records with a picture loaded. We're trying to export all these pictures, which sounds like it'll be a whole other can of worms... Thanks.

some quick background... we have an inventory file with a list of tag numbers, its an old solution we are in the process of rewriting, but for now we use repeating fields to enter a new tag number to a coil if per say we cut part of it then return the rest of the material to stock... when this happens we assign a new tag number... If we try to do a search on anything but the original tag number we get no return results??? anyone have any ideas as to why this may be happening or anyone encounter the same problems?? as always any comments are appreciated..thanks

In my first layout I have 6 records... Records 1-4 have the same conditional value I then do a find on this conditional value and (not surprisingly) get the first 4 records which appear in a related layout. However, if I'm in record 2 when I initiate the search, I get the same four records but my found set starts at record 1. Go to Layout [ Found layout ] Perform Find [ Conditional value ] [ Restore ] Go to Related Record [ From table: "Original"; Using layout: "Found Layout"] What I'd love to achieve is performing the find, switching the layout and ending up at the record where the find was first triggered. I've tried doing no end of variati…

Hi, The interface I've created for to search records includes three checkbox fields, each with several options, i.e. "red," "blue"... "large," "small," etc. When I select multiple options, I'd like the result to behave in an "or" fashion, rather than "and" -- what I mean is, if I check red and blue, I want all records returned that are red AND all records returned that are blue, not only the records that are both red and blue. The way I've been doing this is to explode the find into several find records, distributing the checkboxes among the different find records. It's tedious to maintain if I want to change things, and now I am adding another checkbox to…

I have organized clients by the month in text fields (each client may exist for 1-4 months.) In search mode I want to enter a single month and get records that have this search month in any of the four possible (month) fields for a client. I cannot seem to make any calculation work so far and i am in desparate need of help. anyone!

I'm new to FM so correct me if I am wrong with any statements or assumptions: I have 2 tables. product id cat_id tmpCat Categories id Category Categories has unqiue values in 'Category' cloumn. Products has multiple rows with the same value for 'tmpCat'. I am trying to set for each row: 'Products::cat_id' = 'Categories::id' where Products::tmpCat = Categories::Category I want to do this for all rows in Products. The reason: yes Products is not normalised as 'tmpCat' should not exist but this is due to an import from a non normalised table that combined both Products and Categories (and others tables not mentioned) toge…

Hi There, I am very new here and also with FM. I have a problem with my FM-database, hope some one can help me. I have 2 tables which are related (company, product) In a (list) layout you see a company with al the product that must be delivered there in a portal. The transport to this particular company can be by feet, by car or by bike. The product has colors like green, blue and red. Now I have to leave green products out of the portal if the company has the options 'bike'. Like this: Company X – By Feet Product 1 - Blue Product 2 - Green Product 3 – Red Company Y – By Bike Product 1 - Blue [color:red]Product 2 – Green (this o…

I would like to find entries in our database based on their region, found by zip code. I have a list of zip codes that I would like to search for, how can I have FileMaker show me all the records that are in my list? I don't want to have to create a new find request for every zip code, that would take me forever to do. I figure FMP has some way to do this for me. :-)

Hi I am complete beginnner to all this but i have a database (probably set up wrong - but it works) it is to track my students and teachers. I have a calendar page which has a field for every day of the year which is related to the main database which holds all the student info. Each time a student attends a class they are found on the database via a barcode reader which then opens the calendar via a script, I then enter a code in the apporpriate day of the month. the code entered depends on their level and their teacher. (eg UJ or IA). The first letter being there level and the last the initial of the teacher. As the teachers are paid dependent on how many people attend…

Here's an easy one: I want Database A to look at Database B and compare a field called "Record ID" which exists in both. I then want to KEEP only the records in Database A where a match is found. I want to delete all the others. Database B needs to remain intact. Thanks.

I am attempting to create a script to find records with an empty date field using the "If" function. The complete script is Show all records If( IsEmpty(Finished), "", 0) End If Sort [Restore, No Dialog] The script always return all records Doing a manual search I find 254 records with no dates. What am I doing wrong?

Hi, I'm new to FM, so please bear with me. I want to be able to find all the unique values in several fields--one field at a time. What is the best way to do this? Thanks! Charlene

Hi everyone, In my older solution in 5.5 the user (via script)has a find screen one field of which is a drop down list of customer names. If a user selects 'Baxi' as a customer they find not only the records for 'Baxi' but also those for 'Baxi training' I thought I could get get round this by incuding the following line before the perform find script step Setfield(CustomerName;"=="and Customername) but that just gave me a consistent 'no records found' message Upon pausing the script before the perform find I found that this had set the CustomerName to 0 (nought) Can anybody guide me please? TIA Phil

I'm running a report that list a yearly summary of all donations by contributors for the past 4 years. However, I'm now also wanting to list all donors that have contributions more than $5000 in one year. However, the find control won't let me enter a search parameter for a summary field. How do I achieve what I want? Thanks

Hi all. I setup a relatively simple database for my brothers business. It is basically a list of items sold, some of which are bought from one person and sold to another. I set it up so he could search in the received from layout on a serial number, then duplicate the record, and clear out the name, address city state zip etc and leaving the equipment information intact so he can enter the new owner information. A lot of the equipment goes to and from a similar group of people. Would there be a way, once I am in the duplicated field, to display a list of all the users currently in the system (first and last name) and when you click on that name in the dropdown list it wil…

Hello all, I would like to be able to search for records using two fields as the criteria. I am trying to track employee time spent on specific jobs. Right now I have a table with all the fields I want, including an "employee" and "date" field. I would like to create a report style layout to summarize, for each employee, the job#(id) and the amount of time worked on it based on a range of dates(month start and month end date). Some way to choose an employee, enter a start and end date to search, script a button, and then have the results listed in a portal or in some sort of list form. Is this possible? I have tried a couple of different things and none hav…

hello everyone, i'd like to add a kind of itunes/apple mail etc. style search box to the top of my database. so that at any time, you can start typing in the box an it will display all records that include the search term in one of its fields. like the find/replace command, but with the search box permanently present, and always set to search in both directions, all fields, all records. could someone point me in the right direction, if this is possible? thanks! alexandra

[color:purple]I have a huge phone number database, I need to delete the duplicate records, tried (!) and it found the dups but also the original records. Any ideas on how to only mark the dup records for deletion? Read the other posts on deleting dups but didn't find one that addressed marking the dups. Thanks!! Mel

I am building an image catalog and I have an advanced search page which lists search fields that are related to images, such as image title, current location etc and search fields that are related to artists, such as artist name, artist date of birth etc. I have an image view layout and artist view layout with artist info a portal to the image table displaying all images by that artist. I want to make the advanced search page so that the default layout displayed after a search is the image view, unless any of the artist search fields are filled. Please advice on how to go about this. I have the image info and the artist info in separate tables.

I have a request to find records entered in the last week. There is a Date Entered field. The script I used is: enter find mode insert calculated result Status( CurrentDate) & "..." & (Status( CurrentDate) - 6) perform find My results were not found records but an error message that the date must be in the 1/1/2005 format. When I clicked continue the information in the "Date field" is 732215...732221. Apparently this is Filemaker code for 9/28/05 through 10/2/05. Before I started I entered five records with the 9/28/05 through 12/2/05 dates. In find mode using 9/28/05...10/2/05 returned all five records. I have tried scripts u…

Sorry, I'm cross posting this from the portals forum because I just realized this is probably the correct category : Hi, I'm new to the board so hopefully I'm following any established protocol but I have a problem that's stumping me and I'm hoping someone can offer some insight. My company runs a web portal so that sales reps around the country can search for data we've assigned to their user name through our website. When defining the users account priveledges I have set everything up correctly except for 1 fact. Within the record priveledge set, if I set 1 of the tables to limit instead of all, the users will still be able to access their information i…

I have two files named 'company' and 'executives' which there is a one-to-many relationship based on an uniqued Company ID in company and Company ID in executives. Each executive has a key called Executive ID. I have a portal based on the relationship and want to find the name of the executives from the master file 'company'. But the search results are all wrong. Am I doing something wrong with the relationship?