Finding & Searching

Is there a way to display a report in FIlemaker so that the fields in each record that I want to display on the report are lined up in a top to bottom fashion instead of in a left to right fashion. I am trying to get for example, 5 records to disply their data on 1 page in a top to bottom fashion; 1 record with all its fields displayed top to bottom on the left side of the page, then another record with all its fields dislpayed top to bottom to the right of the previous record, then a third and so on. Is this possible because I sure can't figure out how to do it. Ron

Hello, I am merging some mail lists for a customer of mine and we are running into some difficulties. We are trying to compare a list of 15,000 names and addresses to about 12,000 names and addresses in his current database. We are updating his database with the NEW list. Everything works fine when the records match. However, sine sometimes the company name or addresses may be spelled differently then there is no way to match and import these records. Is there a way to import "similar" records together or remove the "similar" records? I have a remove duplicates script that works great when the data matches but it isn't much good when: customer A is in the o…

FileMaker Pro 5 on a Mac I think this application was created from a template or two. It has four databases which make up a POS system. Roster (No relationships) Inventory (barcode = barcode in Sales and Line Item) Sales Line Item (barcode is a Lookup field from Inventory) The problem is that Inventory wasn't designed with Item quantities so every Item is a new Item and Inventory is getting HUGE. Nothing is deleted from Inventory after a sale. I am trying to create a (Find View) Layout in Inventory that will find matching Barcode records in the Line Item database so I can delete all the matching records from the Inventory d…

See the 3 records below Hardware version: 0; OS: VxWorks 5.3.1; Software version: 3.2.17p Hardware version: 0; OS: VxWorks 5.3.1; Software version: 3.2.12p Hardware version: 0; OS: VxWorks 5.3.1; Software version: 3.2.17p No matter what I try, I have multiple records of the type above and I would expect FP to sort the 3.2.12p records first but FP seems to be having difficulty in looking this "deep". All the field are text. Anybody got any ideas on how to improve the sort? sandy

I am new to FileMaker, but I have had experience with other databases. I am having trouble figuring out how to do a specific search. I have three files. One is called "Jobs" which keeps information on the jobs our department is working on. The other is called "Assignments" which keeps an Employee ID and a Job Number. The last one is called "Employees" that has the info on employees. I already have a relationship that links the Job Numbers from "Jobs" and "Assignments" and on one layout I have a portal that shows all the employees assigned to the job. What I want is to make a layout that will show the jobs that each employee is working on, so each week the b…

Hi, I have a database that lists a series of film, and the music titles in each film. I want to do a find that will return all of the music for a specific film, but my find is not working properly. The best way to explain my problem is like this... If I search for the film, "The Mummy," my find not only returns music from "The Mummy," it also returns music from "The Mummy Returns." How can I set up my find to return just the specific text of a film? Thanks.

I know I've seen it somewhere. I've scanned the forum. I've searched my Scriptology index and contents. I've even stopped and thought for a few minutes. But I cannot remember how to Save a Found Set of Records. Can anyone help please?

Hey now, I have written a database for a client of mine that tracks shipping data. The application accepts information about items that are being shipped in containers via ocean freight. Each containers may carry several items. What I want to do is update all the records that have the same shipping information in one stroke. I want to develop a form that will have the container number, vessel name, ship date, arrival date, booking number, ship line, etc... and then be able to enter up to 30 record numbers that will be updated with the aforementioned information. When the UPDATE button is clicked a script will loop through each record number on the batch updat…

Hi, I have a problem where I am trying do a date search for specific comments that relate to a person in my database. The first thing that happens is that I do a Go to Related Record based off a value list of ID numbers eg. a person is assoicated with a number a objects now each of those objects have a number of comments attached to it so a value list is being created in the person table of all of the objects that a person has and then a relationship has been setup between that value List and the comments table and when a goto related record in the comments table it brings up all of the comments for that person. What I am wanting to do is allow a user to en…

I am very new to the Filemaker world. I have created a DB to keep track of training for our employees (35). I created 35 fields all having drop down menues with all 35 names contained, so that person entering can list who attended and not have to type each or start a new record for each. Now I want to create a report that would produce all the records entered for (1) individaul regardless of where name appears on records. Make any sense???

Hi All, I have a text field (DayType) using value list with: 6 - 6 6 - 5 5 - 5 4 - 4 When i go into find mode enter the field, select from the list 6 - 6, hit enter. Why do i get results that include 6 - 6, 6 - 5 ?? Is there a way (with value list) to specify an exact match? (thru script?) Thanks --Dan

I have two fields a status field and a Date modified field, Can anybody help me create a script that will find the vaule of the status field that was modified more than 8 hours ago. Example it would find all the records of status that have been "outstanding" for more than 8 hours Regards

One field in my database indicate record's status. I flag this field with "New" when a record is created. the flag should be changed to "Old" two days later. I try to run a script as: goto record/request/page [first] loop go to field["status"] if [current date - created date > 2] Perform Find/Replace["New", "Old", "Replace"] end if goto record/request/page [exit after last, next] end loop But seems the Perform Find/Replace[] doesn't work. Help me please!!!

Hi, Hope this does not turn out to be long winded! Timecard app has 3 files, employees, CommonDayInfo, WorkdayInfo. Common is linked to workday on a commonDate field. I want to select a period (7days) to produce a timecard from the WorkdayInfo. In that period i will end up with the same employeeId more then once if the employee worked more then 1 day. how can i "summarize" employeeID to end up with a list of employee that worked for that given week? It must be usable in Browse mode (i tried the preview with sumarize...) because i will ask the user to "check mark" the timecards they would like to print. So users should only see one of each employee t…

I need select a record and import it to another file. I can do it in table view. But how can I omit or select one record from a found set in form view?

Hi I have a script that runs on the current found set: Goto first rec Loop If (sys_id>1000) Omit rec End if goto next rec (exit after last) End loop Sys_Id is calculated unsorted field (un-changeable). The problem is that some record are still not omited. This is a logical step and I don't understand WHY it is "skipping" records. I have to run the script 6-10 time to get rid of all the "bad" records. Any Ideas? P.S I don't want to use "find" because it is tooooooo long.

I use a database with approx 23k records. I need to be able to find a group of records then omit duplicates for a particular field. For example, I find all records entered since Jan. 1. In the field for vendor I might have multiple entries for ACME Vacuum. I want to omit all the duplicates and show just one of the ACME Vacuum records. It doesn't matter which one is shown. Is there a way to do this? The result of the find and omit will be a vendor list with each vendor represented only once.

Anyone experienced blank records that appear to contain no data yet you can not delete them or get rid of them? I think I have found the field that seems to be messing things up however I can't get rid of these "empty" records. When I do a search for a field called "Recall Date" it returns both records with data and without data. If I try to delete the empty records they don't get deleted. Thanks in advance for any help.

Hello i am a new user of FileMaker and i want to ask you something about dates. Firstly i try to make a script with ScriptMaker but without success. I try to make a script that when i complete two fields of date tell me that found or is available. For example if i searching for 15/8/2003 - 20/8/2003 and i have a date in record from 15/8/2003 - 19/8/2003 tell me that is not or available in contrast if i have a record in 15/8/2003 - 20/8/2003 and search for 15/8/2003 -21/8/2003 is available not for this date but later. Is it difficult that ? Thank you very much in advance. FMAsker

I saw a post on this a little bit down, but im not sure if it is exactly what I am looking for. Im trying to do a find for a date(s) that fall between Today and 3 months from today. Anyone have any insight? If possible, i would like to do this w/o using a calc field. If I need a calc field, how would that be done? Thank you all very much in advance

I have a FM database with text field that has 200 repetitions. This lists the contents of book and magazine articles in my collection. Whenever I do a find for a specific set of text, it's an exercise in total frustration to locate the exact occurence of the found text. There used to be a script, called Hilight, or the like around that tried to accomplish this task, but I could never get it to work on repeating fields and now I can even locate it. All the url's are broken. This is an egregious oversite for FM not to implement. Any thoughts, ideas, workarounds? Thanks in advance. J.D. Thomas ThomaStudios [email protected]

How do I format a find request in the same field for two records? Say I want to find record 1000 and 2050. I only want these two in the result. Thanks, Daryl

I am having a problem with a simple find script. here is the script Enter Find Mode[] Set Field["Talent", "ShowTalent::Talent"] Perform Find[] However when I run this script is continue to get the previous find request. I can't seem to override that info. I am sure this is something very basic I am doing wrong, but it is stumping me at this point. ------------------ Thanks, Kevin

Hi, I've never seen anyone flamed on this site. But I'll probably deserve it for this questions, because this seems too simple. Yet I can't get it to work. I have a portal with a check box in each row. I just want to find records in the portal where the box is checked. I have a record that has related records in the portal, and some of them have the check box checked, but when I enter find mode and search for checked portal records, it tells me there are no matching records. I've used this type of find in other portals with no problem. What am I doing wrong? Thanks, Dan

What is the easiest way to omit duplicate find results?

is there any way to find out the criteria behind a Perform Find[Restore] script step? I am taking over a database filled with things like this and I would like to know... thanks

I have a db that worked great since yesterday. Today an unindexed search on 250 records take over 40 seconds (yesterday it was performed in 1-2 seconds). I've noticed that the overall performance of the solution have been affected. The db is on a PowerMac G3 333, FM Server, Mac os 9. Any help would be greatly appreciated, Thank you, Paolo.

Hi all, I have written a set of reports on a database - these are just find requests but quite complex ones - ones which the users are finding hard to write, so I have coded them in as scripts and step by step layouts. What I would like the users to be able to do is to be able to print off a report from the find results but for them to specify which fields appear on the list layout - i.e. Create layouts on the fly - has anyone attempted this before, I'm sure one of you gurus must have done! - please could you tell me how you went about this? I only got as far as allowing them to specify a report heading - just a global field which they can type the heading …

I'm embarassed to ask this simple question here, but I can't find the answer anywhere else; it's not in the FM help file and I can't formulate a Google or other search for it. I want to find all records - not in a script etc, just plain Find mode - that contain a specified string *in any field*. So for example, I want to find all records that mention "India", but I don't know what in what field that will appear (because of previous bad table design and data entry). At the moment I have having to export to a spreadsheet and search that. Can I do it in FM? TIA!

From: techy I was trying to post for help on this problem. I am trying to find/omit records over multiple fields. I have a Postcode Field (Main DB)(set as a valuelist checkbox) this works fine on it's own. I have a Members Field (Relational DB) again works fine on it's own. I have a County Field (Main DB) again works fine on it's own. I need to find AND/OR Omit Records that match ALL 3 Fields?: My Current Script is..... show all records enter find mode[pause] set field["membership:membership"] omit record(depending on what the user enters) new record/request set field ["county"] omit record …

I know if I want to find omitted empty records that are text fields that I would do a find on "*". But when I try to find omitted records on number fields, this does not work. Does anyone know how to do a find on a number field that omits empty records?

I'm trying to do a search for any date that is greater than today minus 30 days. Here is what i'm using > // - 30 Of course it doesn't like that. Is there a way i can do this w/out using a calc field? Thanks -j

I have a layout that sorts according to a calculated field that joins 3 fields together & produces a summary - the number of qualified scores by that person at a level in a phase. I want to do a find on the summary field - find only those that have 8 or more qualified scores at a level in a phase. I may be going about this in the wrong fashion..... thanks for any help, Martie

Hello, I have two fields (A and :. They contain two digits each. I'm trying to create a script that will perform a find for any other entries that share the same values in A and B, of the entry, that the button is attached to. For example. One entry has field A equaling 01 and field B equaling 02. I'd like the script to see and remember both values from field A and B, enter the find mode, and assign these values to the appropriate fields. I was hoping that I could set up some sort of variable to temporarly store these values, whetever they may be. The reason why is so I could only write one scrip for this instead of specific scripts depending on what b…

Need to set up a way for users to enter a specific set of record ID numbers into a "find" window (scripted for them) and dump those records into a list report. Help? I'm stumped.

Hi! I have a Traffic db that lists all jobs (roughly 3,000). I have a script that finds and only shows all open jobs (rougly 150) when you switch to the Traffic Schedule layout. When I click "Find" within that layout, obviously it searches all records in the db. What is the command to say, "Only search for <user input> within the open jobs"? The criteria of the find will change each time depending on what the user needs to see, but she doesn't want to see every job ever created, only the ones that apply within the open jobs. Am I rambling? Thanks!!

Hey gang, This is probably easy, but I'm stuck. I have a text field that is approx. several hundred lines long. Within that is burried a code that I need to dig out. I can locate the code, sort of. I know that the code lies between a " character at the left side, and a : on the right side. So how do I select the text that is between the " and the : and paste it to another field? Thanks, Frustrated Dan

Hi - i seem to have a problem searching for values generated by a case-calc. I have the startweek of a range and the endweek. Lets say the startweek is 4 and the endweek is 9. The maximum range is 25 weeks btw. The calc below generates a list of all weeks in this range using a simple case-function. In browse-mode it all looks fine but when entering the find mode and entering - lets say - 5 it doesnt find anything, as if the calc-results are not searchable. The calc i use is: Startweek & "

Hi am trying to clear five fields over around a thousand records for a script. this take a while to loop through the lot so i need to cut it down to record just with text in the five fields does any one know how i can script it to enter in "" into a field to find any text if not does any one know how to find blank fields in a script the i can just show omitted and hey presto i have my record set i need cheers all

after a search, wat is the easiest way to see all the records again? Now, I go back to find, fill in nothing, get an pop-up with error and then go back to browse mode. there has to be an easier way?

This may be a very simple problem, but I've never encountered it before. And since the problem is actually not with my database, but with my personnel department's database, I can't physically look at it and play around with it, due to confidentiality issues. Also, I did not create the database in the first place. Anyway, here's the problem. This particular database will only allow one find at a time. So, for example, if I want a report that lists all of the certified teaching staff with Masters Degrees or PhDs, who have been in the school district for 7 or more years, the logical answer is to search the "Degree" field for 'M' and for 'P' (or ask it to omit 'B'-bache…

Hi everyone, Is it possible to set up a layout, & perform "Find" using: less than all the feilds on the layout? In other words, I want to leave some of my feilds on the layout out of the "Find" criteria...

Newbie here, I read in the help file that typing ! in the field when running a find will find all duplicates of that field. It has not worked. Instead almost all of the records are returned. Obviously I want to limit the find to only exact duplicates to get rid of them. I know this must be easy, but I am not finding it. Can someone help?

Hi, Would anyone know how to capture find criteria for a Number or Date type field when >, <, <>, etc. operators are used. My users want to see search criteria before they perform a search, and want to be able to print them for future references. I created a gSearchCriteria global field, which is populated by a script which is looping through all filelds on a layout (they are in a FIND mode). If Status(CurrentFieldContent) is not empty, it appends Status(CurrentFieldName) and Status(CurrentFieldCo…

Hello All, I am a beginner with FileMaker 6 and need some help with reporting. I have a TimeCards Database which contains these fields and some others: EmployeeID EmployeeName Dept JobNo JobName EntryDate TimeHourMinutes A Form collects Entries by different Employees where they record time spent on a particular Job. Some sample records might look like this: "1000" "Dept 1" "John Smith" "1048" "Job No 1" "04/20/2003" "3.25 "1000" "Dept 1" "John Smith" "1055" "Job No 2" "04/20/2003" "2.0" "1002" "Dept 2" "Mary Brown" "1048" "Job No 1" "04/19/2003" "1.5" "1002" "Dept 2" "Mary Brown" "1055" "Job No 2" "04/20/2003" "3.25" "1002…

Hi, I am trying to create a report that will search my entire database using something like this: Nextservice data <= Date(Month(today),Day(today)+30,Year(Today) ) I think this will do what I want, If my NextService Date is less than todays date + 30 days from now, then I want to add that record to my found set in my search. My problem is with the script. Heres what I've got so far Enter Findmode[] Insert Calculated Result[] *** Perform Find[Replace Found Set] Go to Layout["Next Service Date Report"] *** I'm not sure If I should be using the Insert Calculated Result[] as I think, from what I've read is it will change the value of th…

I need to be able to do a find on a number "2B" and not get 2, 2A, 2C and so on. I have the field as a number field and I've tried "==" inside the field when I do the find and that's not working either. Everytime I do the find on "2B" I get all 2's. I've tried everything I could think of and I'm not getting the correct answer. Could someone show me what I'm doing wrong.

Here's another one: I'd like to implement a security feature: I have records, all of which have a field called "Creator", that is automatically filled in when a new record is created. Now I don't want people to see each other's records. So when a user logs in, I'd like to use the Status(CurrentUser) calculation somehow to create an Open-Document-Script that will automatically do a find on the field "Creator" to match the current user, so that only a subset of all the records is displayed, which only belongs to the creator. How would I be able to make that possible? The "Find" script step only seems to offer "hard-coded" finds, not conditional ones (i.e. based on u…

Hi guys, this one seems simple but I can't figure it out. I want the user to enter a value into a global Field. Say he enters "Fred". I want to create a script, that will change the layout and go into Browse mode as soon as the person entered "Fred" and hit a button. However, the script should automatically jump to the record that has the value "Fred" inside of its "Name" field. Can you guys help me out? I'd love to hear your ideas...

Hi there, any idea on how to implement a "fuzzy" find? Or find similar based on certain criteria) The problem is that I have a product database with thousands of misspelled records, all in one field, and would like to find duplicates or similar records. I tried ranking with multikeys (replace(textfield;" ";"q|"), giving me every word as a key for a portal, and a calc which would add up the occurrences of every word of the original record in the related record. (sorted portal). painfully slow and too many finds. Then I added a filter which would filter out common words like "q|theq|", "q|andq|", "q|mmq|". How do I filter out words under a certain length? And wha…

k.. I've searched the forums and found a few posts on just this topic, but i must be missing some fundamentl understanding of scripting. here's what i want to do. I have fields A, B, C, and D on a layout. I want to put a FIND ALL field on the layout where the user can enter what they want, click a button, and all the fields(a to d) are searched with the entry. Now, I set up a CalcALL field that puts these all together into one searchable field. what i'm missing is how to tell the script to take the data in the FIND ALL field and use it to search the CalcALL field. I hope this makes sense, and sorry if this is basic. thanks Steve

Hi, I just want to click in a text field when in find mode and type something like: John* AND Paul* This will give me all the Johns and Pauls. Is this possible? If so, what's the syntax?? thanks, J.

I need to find a way to script a "date find"! My file has over 90000 records of customers and once in a while, a customer "borrows" a car from us, and a "rental" type form is created. Three date fields are present on the layout: 1. Dateout (which triggers a "Car Out" flag) 2. To Be Returned 3. Returned (clears the flag) The task is to create some reports these rentals. One showing all cars currently out was simple to build. However, another report showing ALL cars that were ever loaned out, current and closed! Out of 90000 customers, only about 300 have EVER borrowed a car, and currently there are only 3 out right now. So far, my attempts …

I am looking for a method of sorting a catalog of data. I like the idea posted by DatabasePros.com titled Substitute Portal Filter. Their example file shows how to filter a portal, but I would also like another filter. I would like to filter it by a wage within a given range. For example, if you were to assign a wage to each of the volunteers(yes, I realize they wouldn't be volunteers any longer ; ). Then with the filter you could enter in a wage and then check a box to look for values within a range. For example, you could enter $50 as the wage and click a check box to search for wages within +/- $2.50, or another check box for $5.00, $10.00 etc... thu…

i need to set up a script that will show me which orders have the same title. I have no idea how i would do that. I have two companies that give me orders to process and sometimes a book will sell with the first company and that same book will sell with the second company. i simply want to mark the orders that have already been sold for the day. Any ideas?

This may not be the right place for this, but I don't see a Layout forum. This involves scripted finds, so I'm posting it here. I'd like to put a global field on a layout where the user would enter a find keyword, then click a go button. This would run a script that sets ten fields to the global contents in ten find requests, runs the find, sorts, and clears the global. My proiblem is that I'd like to place this field in the header of a list layout. But it looks like global fields in a list header cannot be entered. IThis will work in the header of a standard layout, but not list! I'm sure this has come up before. Is there a workaround, or some other w…

Hi I am struggling to get my head around this problem, let me first explain I have 2 databases 1 is a database of activities (ie Football,Swimming etc) and I have another database called bookings in the booking database I have the following fields (just the relevant ones shown) Name MondayMorning MondayAfternoon TuesdayMorning TuesdayAfternoon (basically 2 fields for everyday of the week, morning and afternoon.) The fields are ComboBoxes showing a valuelist of all the available activities from the activity field in the activity database) I need to be able to produce a report showing in popularity order the activities, someth…

Hi, Simple question, I've got a layout with a number of fields I want to create two buttons, one to sort by one field, the other to sort by another field. The Sort commands within Scripting does not provide the ability to select a field, how is it done please??? take care, J.

Hi All I have created a tab interface (seven layouts) to complete a two page form. The first layout is a menu and instruction page. I tried to add a find button to the fist layout with no success. I wrote a scrpit and attached it to the button. When you enter a serial number and then push the button, the message "enter a valid criteria" appears. The script example: Go to layout tab2 Enter find mode insert calculated results[select,gfind,Serialno) preform find The serial number is on the second layout gfind is formatted as a global field The message appears on the first layout. The goto layout tab2 does not happen until the message appears and y…

here is the script Close["CustomerInfo Converted.fp5"] Copy [select, "one"] Paste [select"Alibris_Order_Num"] Perform Find[] Why wont it copy and paste that info?:??

This makes no sense to me. I have a layout that features a pop up list of reports that I wish to run and a button that runs a script. The script queries the contents of the pop up list and performs a subscript based on this. The subscript then performs this code Set Error Capture[On] Perform Find[Restore] Sort[Restore, No Dialog] Go to Layout[Refresh window, "Layout1"] This is the same piece of code in all the subscripts. The problem is that the new reports I added to the pop up list don't find anything, whereas in native Find Mode it works great. The subscripts work for all the other reports in the pop up list but not the new ones. What is the problem? …

I would like to be able to "import" a list of unique criteria all for the same field to create a multiple request find. The goal would be to find all records that match the criteria in one pass. In doing this it will allow me to associate product names with the codes if someone sends me a list of product codes with no names. In this case it would be product codes like while each one creates a new request: 11-06-01 42-20-02 07-01-03 99-99-99 80-02-07 80-11-01 98-01-01 98-01-02 10-15-01 10-17-02 18-06-02 18-08-02 18-10-01 18-04-01 18-02-02 18-01-02 42-05-02 41-13-02 25-04-01 05-00-04

Hi Geeks, I want to know members who didn't check in for the last 30 days. In other words, I am looking for records that do not exist. Each time a member ckecks in, a log is created. This logs hold this information: member id, name, date, time and a counter that displays "1" automatically. I found half of the solution but I want to get rid of duplicates. It looks like this: Copy (Select, Last 30 days) --> calculation field Enter Find Mode Insert Text (Select, "Date", "<=" Paste (Date) Perform Find Show Omitted This script works as long the member didn't check in the past 30 days. To narrow the search, I need to get rid of the duplicates…

Is there a way to do a find on a summary calculated field after the report is run? Or a sort? If not can the results be placed in a perminent field in the same database? Currently we are running the report and then exporting the information to another fp5 to do the find and sort. Dan

So, I have a button formatted to "Perform Find" but, no matter what I do, it only seems to go to the first record. Am I nuts? Isn't "perform find" the same as the little "Find" button on the gray sidebar?

What is the best way to perform find using a checkbox? Let's say you have a field Location with values City A, City B and City C. I want to give a user opportunity to click on a checkbox (ex chosing City A and City B will list all records with City A OR City B in field Location. I know checking multiple checkbox means typing Locations with new line sign. Is the only way to achieve that sripting it by cutting lines and for each line performing New Record/Request command? Is there any easier way?

Is there any way to print the field used to perform a find as the title of a report? I have a layout called Demographics that displays information like work address, work phone, position, district, etc. the user prints from this layout often, and would like a title on it so she can keep track of who the people are she's looking at. For instance, if she does a find for Superintendents, she wants the printout to say "Superintendents" at the top. But if she looks for Grad Standards Committee (a different field), she wants that at top. Thanks for your help. Susan

How do I perform a find in a related database?

Hello, I was wondering if there is a way to do find using drop down menu. where a person selected what they want to see and than click on button that will run the script?. i am new to FM. wondering if it si possible. you can view a picture of what i am trying to do at this url: http://www.asmt.com/dblayout.gif where the yellow box is locate, it is what i am trying to do. if above is not possible how can i do using check boxes like this layout http://www.asmt.com/layout.gif

I'm trying to build a date find script; I've had no luck finding info. I would like to enter Monday's date and get records for the following 6 days (until sunday). The general find part of the script is easy; I will grab it from filmaker6 template. But when I enter the date how do I tell it find the next 6 days? Thanks, JP

Hi, I wonder how I can find this kind of things suppose I have 3 fields 1- color 2- cars 3- price now I want to find all red,blue and grey BMW - Ford cars in stock with a price between 10000$ and 40000$ I want as less as possible requests.

Hi, I've got a killer find problem. I've got a unique set up here. The user needs to do a custom find and then run a report in that find. Easy enough. Not when the report needs to do another find on 4 fields. These fields contain MMYY combos and the report finds a range (entered in globals). The script that runs the report Enters Find Mode, then does 4 new requests (since the report does ANY within the range) and then does a Perform Find. I need to combine with the user find since the user needs to filter out some of them. I've tried everything using Modifly Last Find etc. but that just adds records to the found set. I can't use a field to mark the fo…

I'm looking for a way to find related records from g_Name::Name where the Last Name is empty. I've tried Count(selfjoinon_gName_tName::t_LastName) = " " or PATTERNCOUNT(selfjoinon_gName_tName::t_LastName; " " ). Cannot have the number of empty last names for the same first name.

I have a database that has 3 different layouts that I use for inventory. (1) Consignment Vehicles (2) State Vehicles (3) Miscellaneous Is there a way to do a find on the ID_NO and have it look in all three layouts to see if it is there?

I don't know if anyone can help, i have 6 fields with various data in them including a serial number (which sometimes contains text) I want to be able to have a global field that you enter a serial number to be found, then run a script to find this data in any of the six fields, i can not use an if(global = any of the others) type script as the 6 fields contain other information aswell. Sorry about the laymans description!

I'm quite a newbee with FMPro and I can't seem to resolve this problem: I have two databases. Both contain a field with numbers. Now I want to perform a search in the first db that should result in giving me all the records that don't have a match on 'number' in any record from the second database. Could any1 help me out?

Hey there....i'm new at all this filemaker stuff and i've been sort of thrown into doing this...well...thing.... ok...i have to make a database that gives me the option of searching under one "serial" number ...and shows me ...two drop down lists of items attached to said "serial". now i think i need to create a portal..but....i guess it would be a portal..within a portal..(so confused) is there a tutorial somewhere thats a good guideline for beginners?...

I would like to find all clients that have a birthday in the chosen month (e.g. June), and that have an insurance policy with anyone of the 10 insurance companies that we deal with. Then from that found set I need to omit all clients that have a policy with e.g. AXA, MLC & AC&L.

Hi all, I've come across the following problem which I need to solve, but can't find the answer... I'm working on a database solution that has to be multi-lingual. Fields labels are pulled dynamically from another file by calculation, related by language indicator (e.g. NL). This works like a charm, except when you go into find mode. All field labels are empty then. Is ther a way to solve this? Hope the question is clear, let me know if not. Kind regards and thanks for your help/attention. Hein

I have a db that has morethan 600 records and it has a field=name. I made a form called list that will list all the names in ascending alphabetical order from a~z. My question is? how can I make a clickable alphabets in the Form:List like A~F, G~L, M~R, S~X and Y~Z. When a user click this link it list only the names with beginning character of A~F (as example) and the rest of the alphabeth category. I'd appreciate if somebody can help on how I can write the script on this matter. TY

Is there a way to go from field to field and tab or enter into a button to click into a script. ie.. [FIELD] (TAB) [FIELD] (TAB) [bUTTON] (ENTER)

I have a report that I want to show status's. I need a script that will do a find and omit empty records.

Hi all I have a slight predicament... with the help of this forum I have managed to create my project, practically to the end... apart from the find feature. To summarize, this is what I'm struggling with: I have defined a field called "model number", I then use a calculation field, to turn this to CAPITALS for 1 of the 6 layouts (FRIDGE, OVEN, DISHWASHER, FREEZER, HOB and HOOD). I would like to create a find page, that can search for "model numbers" and when the user clicks on the model number, this will link back to 1 of the 6 layouts... can anyone offer any help, or advice? please Az

I have a find request that searches on a calculated field. Its basically, fieldX = 1. Everything is wonderful when running on the server. If I try to do the same find, fieldX = 1 from a client computer, I get invalid find request. I -think- I have all the nessisary related files open and being shared. "Looking closer now." But this has me totally stumped. Why would it disallow a find on a client computer? Many thanks in advance. -jim lee

hello, How do i find "monsters" in "scarymonsterssuperfreaks" can't seem to find a way?? Thank you paul Apted

Perhaps the solution is quite easy but I can't sort it out right. Could you please help me with the scripts for these three buttons: 3 buttons, a global field "input" and a calculation field "counter" I have a global field to put the search criteria in and I need: 1= A FIND button that takes the word(s) or number(s) of the global field "input" and searches it in field "A" "B" "C" "D" & "E". When the value is found (lets say) in field "D" at recordnumber 321, it would be nice to have the field highlighted or [color:"red"] something that puts focus on field "D" of record 321 and also put the find count result in field "counter". 2= A NEXT button t…

I have a question similar to another question in this Forum. I have a file (Customers) with 22000 records containing last name, first name, company name, address, phone number and customer number. In the main file (Data Entry) I need to do a find for the records in the Customers file. I should be able to do the find by either of the fields mentioned above. There was an answer given in an earlier Post that said: Your process will be something like this: get the search data in the other file, then use Set Field [] to put this data into a global field in the main file. Your search data is now in where you want. In the main file, enter find mode then use Set Field…

I have a gadzillion records. There is a container field that can have a picture in it. What I want to do is pull up ONLY the ones that have something in this field. I can't seem to find the correct statement to do this. OF course it would be nice and easy IF I could just export container fields. grrrr

Hi, I have a database that is published using web companion. I have set up a search form that I want to use in the browser. When I click search it goes to the form but when I try to search a field that has a 1 and a 5 in it such as 19285, it wont work. does anyone have any advice? Thanks Chris

In order to prevent users to create new account for existing clients, I already had "installed" a find duplicate using a seljoin Clients:g_name :Clients:name. But obviously, ABC & A.B.C aren't duplicate, nor FA.MI.LY & FAMILY. My first thought was of using a calculation for a new "multikey" global field, using a looping script to set the multikey with an "Insert Calc result"... But as it could also be F.AMILY, FA.MILY, FAM.ILY, FA.M.LY,..., I'm sure there is another way I cannot think about. 1. Is there another way ? 2. What would be this calculation like - I'm stuck with Left("."...) ? Thank you very much.

I have a line item file with products to be ordered by a business. Each product has a field called Supplier_Code indicating the company which supplies that product. I want to sum the total dollar amount of all products from each supplier and display the total for each supplier on a single page in browse mode. I know I need to use a self join and a sum(selfjoin::supplier_code) calculation, but I have not been able to get this to work properly. Am I correct that I need to create a separate self join for each supplier? Do I need to use a calculation with a Case and Status? Every time I try this (assuming my self joins are correct), only one supplier total at a time…

I have a text field that consists of two numbers, then three letters, then three numbers that is part of a barcoding system. The three letters in the middle represent the class of object that the barcode refers to. This format is part of a legacy system that I am stuck with. My users want to find all records in a particular class by simply entering the three letters in the barcode field in a find. Such finds do not produce any matches, even though the three letters are in the field. It must be something about the number, text, number, arrangement that makes FM lose its ability to find on partial data in a text field. I realize that I could separate out those…

It's me again! We are using FM 6 and we will be networked. I want each User station to have control over a global field, in which they can input *find criteria* which will active a script (or be implemented via relationship(?)) and search certain fields to find all or partial matches. Then the User will be taken to a list of the resultant found set. I know I've read about the problems using globals if they are being used to control functions from the Server - that these globals can be overridden by each station? Oh, please bear with me on this ... I have so much to learn I want each User to be able to enter several partial bits of information, such as M…

FMP 5.5 Mac I

Hi Everyone! I need to generate Contract balances. I have a Contracts dB which holds ClientID, ContractID, PayerID and the Max$ per Contract. Contracts also contains a FromDate and ToDate. I have a Service dB which contains services performed (per Client), during the Contract period (FromDate, ToDate). I also, of course, have a Clients dB. I need to create a report. This report is to display the balance remaining on each Contract. However, I want to find only certain Contracts (Payer LaneCare) and Contract::FromDate > 9/30/2002. While in Clients, viewing Contracts from a portal, I've tried entering the portal and finding only the appropriate Contracts, bu…

Can someone tell me if there is an easy way in FM v4 to calculate the percent of male (or female) members there are curerntly on a team? There is a TEAM_NO field that is populated with a 4 character alpha-numeric code and a GENDER field that contains either a "M" or "F". On a summary page where I can see the number of players on each team, I'd also like to see if I need to add males or females to balance the team, by see the percentage of one gender on the team. In another language it would be something like - (Count for GENDER="M") / (Count) Thanks

Hi everyone! I'm in a quandary ... ... whether to let Users remain on an existing layout or jump to a Find layout. If they remain on an existing layout, I'll need to deal with issues such as: accidently entering data while in Browse mode, having to change the background color using Status(CurrentMode) or other methods to alert them that they're in Find, dealing with long screen redraws because of multiple portals, etc. OR ... Always switch to a Find layout, possibly as a pop-up window that they can move to view to live data below to assist them in entering the find criteria. And utilize globals. As I review my options, my primary goal is user-friendliness, wh…

Is it possible to do a find that works like the the "Search" does in Address Book? In other words- as you type in a field FMP narrows down the available choices with each subsequent letter. I believe this works somewhat in a pop-up text box, but was hopeing to get it to work without the pop-up. Thanks!!! Blackberry

I'm suddenly unable to perform a find in date fields where I search for a range of dates ie: using the range symbol (...). I've done this before countless times, but suddenly can't. This problem exists in version 4.1 as well as 3.0 which I tried re-installing and it still doesn't help. Any help would be great. Thank you.

I have an Excel file containing approx. 12,000 records that I imported to FMP. How can I filter out duplicate records? For example: The fields are serial number, product name, and sales order#. I want a count of each serial # only once, even though the serial # may exist several times with different sales order #'s. It seems like a simple task, but I'm stumped. TIA for any advice. Cheers! Johnny Z