Finding & Searching

Hello, quick question about a minor frustration. Currently, I have a script that prints out a report of machine setup time allowances vs. what an operator actually used and displays the variance. This works fine, grouped by machine and looks great. Now, management wants an exceptions report... i.e., only times that were OVER the value. However, doing a simple find on a form with grouped data actually "ungroups" the data. Is there any way to search on grouped data and retain the grouping?

Hello, I'm new in the community, and I have a doubt I believe is very simple. I have a database layout for managing Jobs, with many fields. What I want to do is to print a copy of this information but in another database , with a specific layout for printing. Every script that I try to do gets the Information for the first database record, not the record that I want to print. My question what kind of script can I do to make it get the record I am viewing, put it into this print layout and print. Thanks

I have a database of ESL students that keeps track of the courses they register for. My 'Registrations' table holds multiple registrations per session for each student. Each student has a unique ID as does the course they register for. Student IDs are typed in and their personal info is brought in from the 'Student' table. A one-to-many setup. The same for the courses. I'm trying to get a report to count the number of students registered for less than 4 courses in a given session. With multiple instances of each student in the table how do I go about calculating this? Thanks to everyone with advice.

Hi everybody, I would ask for some help with date range search. Up to three time intervals shell define the search criteria. All "from date" and "to date" are to be manually selected and will be different every search. I have stuck linking the criteria with the table. I would appreciate any suggestions. nena Выше гор могут быть только горы на которых еще не бывал.

Howdy, all! I was told recently that it was good practice not to allow users to have access to the gray Status Area bar in a runtime solution...which makes sense when you think about it. However, if a user were to perform a Find request without the Status Area present, then the "Omit" box--as well as the arguments they could select from for a "Find"--wouldn't be accessible. I dabbled with the Custom Menus function and couldn't figure out a way to enter into the Requests menu the selection, Alt+O, which would enable/disable the Omit box. (There's still the issue of the list of arguments--I guess a custom window is in order for that?) Is there a way of getting "O…

I created a relationship between 2 tables as described in the Filemaker Pro help section under "About realtionships that return a range of records". One table contains employment information about Shift Supervisors and the other table contains data on overtime hours worked (for individuals & departments) I used SearchStartSS & SearchEndSS in place of the StartingDateE & EndingDateE in the example. Both fields are date fields. I created a report format that has a portal in it for the data from the overtime table. The intent is to have a report that can list overtime data for a range of pay periods. When I try to do a find it will not allow me to en…

Hi. Somehow I can't get this to work: I have two tables: A, B. Table A is related to table B via the key X, which is of type Text. I would like to display all records of table A that equal to the text "dummy". In SQL this is equivalent to "select * from A where X = 'dummy'". I can get this to work as long as I enter the text directly in the find window in the script editor, however, I can't get it to work when I use a script parameter or a variable. How do I get it down statically: // works A::X =dummy How do I want to get it done: // doesn't work - I checked, it's the right parameter there A::X =Get(ScriptParameter) …

Hello every body, Thanks a lot for that extraordinary forum. I love It. BRAVO ! My problem is: I use a Valuelist: with 06 possible choices: BSP,BRP,BID,BLE,BRE,BDI. (The choce is made by user). When done, I want to generate an incremental serial ID for each category, wher the format is - BSP1,BSP2,BSP3,... - BRP1,BRP2,BRP3,... - BID1,BID2,BID3,.... When a new record is added, and the selection of category entred by the user, I want a calc that searches in the table to find the last categ serialized, pick the max and then add 1 (exp: BSPxxx+1 and so on) same for the other categories.These Numbers should be displayed automatically to the user and no chag…

Hi everybody, I need some help with this: Making a new record in an articles table I would like after typing the article's code in a field, the next field named "article's description" to be autoentered with the content of the first existing record having the same code. In fact I made this functioning using scripts. So far it only looks clumsy, but I am afraid, when the database grows it will also work like that. Thanks in advance. nena Выше гор могут быть только горы на которых еще не бывал. я болгар, энтусиаст

I am fairly new to the Filemaker world. I have recently created two databases. My main database is called EmpMstr and it holds employee information including EmpNum. A secondary database called PayReg contains payroll information which also inlcudes EmpNum and a PayDate field. I have created a relationship and a portal that displays specific payroll information for a searched employee, but now I want to do a search on employee name and a beginning pay date and ending pay date, and then have the portal display just those records that meet that criteria.

Hi, I have a doubt regarding the found set. Is the found set consistent throughout the execution of script? If another user performs find on the same table at the same time at which my script is executing , will it effect my found set?

Hi, Couldn't find this topic anywhere else - [color:blue]is there a way to have a list in Browse mode "auto-sort" by a particular column/field?? In other words, I have a basic list of records that I currently sort manually by "Date" VERY FREQUENTLY (after every new record is added). When I add a new record, I'd like the list to automatically sort by a particular field as soon as I click off of the new record. Any ideas? Maybe this is a basic script that runs in a similar way that the "spotlight search" script HERE works. (i.e. it runs after you click out of the field)

I created a database where I have several layouts that are based on a single field whether or not an item has shipped. I have four buttons at the top, one revealing all fields, one revealing orders that have not shipped, and one button which reveals shipped orders. I press the button that shows orders that have not shipped and then try to press Ctrl + F to reveal a specific showroom (and thereby omit all the other showrooms) but my operator field for whether the order has shipped or not does not remain. It instead shows all orders, shipped or not. I want to use Ctrl + F to find orders that have not shipped and are based on what I enter when I am in find mode. …

I was wondering if there was a way to seach according dates. I have a timestamp in my layout and was wondering if i could use a function to search for all records from the last two weeks. Thanks, Jonny

Merry Christmass to everybody! Here is my question. FMP7. A table contains one field named "products" with different, but repeating records. Another field -"price" can have different values for the same product. I would like during data entry for a new record first to choose a product from a pop-up menu. That's easy. What I can't is to make the "price" selection from another pop-up menu displaying the existing prices for the selected product only. Will somebody help me with this?

Hello, I have not gotten my copy of 8.5 advanced yet but I want to start asking questions already. In the interest of full disclosure, I am not a programmer. I am an ex-electrical engineer that was never too crazy about coding because I was not too fond of the debugging tools. However, I do still consider myself pretty sharp and can pick things up if I am interested and if they are available in a well documented form. I have for many years wanted a simple way of being able to answer a question that comes up time and time again from our customers: Can you tell me if you have a dealer close to me? I would like to be able to plug in their zip code and have dal…

I'm trying to use Filemaker (ver. 8) to manipulate student test data. I have two files, one with test scores for many, many students. I have a second file, with demographic data for students in one particular building. I need to either move data from the scores file into the building (demographic) file, or use the building file as a search list and limit the test results only for the students in a specific building. The ultimate goal is to generate an export file of matched students which will then be exported into a web-based analysis program. The export file should contain records for those students with results. These files are from outside sources, and I wil…

Hi I am new to this forum, and this is probably a basic qustion and searched the posts for the info on, How do you do a find for: The past 15 days, in a date formated field, that does not allow you to set a greater than or equal sign in? So it would be something like ( ≤ //-15 )?

I have a found set of numbers going from 1 to 70. Problem is that in taht range (2 digits), there are numbers with 3 digits. The 'sub-numbers', who are also in the regular number fields. Sorting on the numbers will put the sub-numbers (like 610, 620, 650 etc) at the beginning or the end of the sorted range, where I need them (in the above example), between 60 and 70. The range should be: 60 610 620 650 70 ... any hint how, without creating too much 'in between fields' ? TIA

Still a Noob but getting better. I have 3 tables Groups, Contacts and Joiner. Each has a unique ID field. Contacts can be in many Groups and Joiner is the table that stores Group IDs and related Contact ID. I have a layout which shows a Group and a Portal that show the related Contacts. This part works fine. Sometimes a Group will have several hundred Contacts. Is there a way I can locate a particular Contact within the portal? And also, if possible - is there a way to do the search similar to Apple Finder searches where you start typing letters and it filters? Thanks in advance for any advice. Cheers M

Good evening, I would be very grateful, if someone could help me. I have two related tables, Shops and Products. Shops contains informations about the shops (address, contacts, etc.) and Products contains the name of the products, and their prices. Both table has an ID field - ShopId and ProductID-, and Products has a ShopId field, which is the foreign key. I would use a Report layout showing the prices of the MacBook and MacBook Pro in each shop, but the second product with the same ShopId is not in the list. Is it possible to display them in the same row of the Report? I am a PHP/MySQL developer, and I am completely lost. I've tried to create a new rel…

Ok, so I want to tackle the birthday problem but with a slight twist: find everyone who has a birthday this month including the last 5 days of the previous month. So for December I would find 11/26 to 12/31. Now, I know how to calculate the day, month and the range but it's the year that trips things up. If you search for a range it always puts a specific year in. So if I search (manually) in the date of birth field for "11/26...12/31" it puts in the current year and shows no results. If I put in "11/26/*...11/26/*" it returns every record in the db. Thougths?

Hi all. I have a question relating to finding with scripts. I have a file with 2 tables, Table 1 and Table 2. Both tables have corresponsding fields with linked data. Here is what I would like to do. I would like to create a button in Table 1, that will copy all data from a field named "Code" in table 1 and then switch to table 2, perform a "find" and insert the data copied from "Code" in table 1. Please can someone guide me on exactly how this would be done step by step. Thanks

Kind of a Noob so I'm not sure I'm in the correct group. I have a multiuser database with let's say the fields contactname and selected. The users want to select contactnames and export those selected. This is easy enough as a single user application. However, multiple user want to make unique selections at the same time. For example, User 1 may want to export Sam,Dave but not Andy so Sam and Dave would be selected. User 2 may want to export Dave and Andy. Any recommendations on how to achieve this? I'm thinking having a global variable with the current user and selected records get the username in a container field. After the export that usernane…

Greetings! Any way to create hyperlinks in a text field? Meaning, Create a dynaminc text block PORTION to become a button link to act as a button (much like hyperlinkng in html)? i.e. Text Field "Four score and [color:blue]seven years ago our forefathers..." or something like that... Thanks in advance, Royce

Hi all - This forum was quite helpful and patient with me several months ago when I was putting together a simple application for my office. Since then, my FM Pro skills have oxidated quite a bit, and I find myself lost for a requested enhancement. Help! I need to produce a simple list report of all records that contain no relations to a particular associated record. In plain english, all the product records that have no relation to an entry in the repair records. What's the simplest way to do this? And...can someone once again recommend the best reference book available for FM Pro? Thanks again...

I was wondering if there is a way to search for similiar feilds in the find mode. i.e. The real name of the record is "stop and shop" but I wanna search for just "shop". Thanks in advance

Hi! master I have a field content with number or percentage follow as 12000 or 40% , How to judge percentage in the field? I want to add a script for the total's field. thanks! fage

Hi, I'm having a little problem with my script. I have two repeating fields, description and cost. Each field has 10 repetitions. I want to write a script to do a find on all 10 repeating fields in description that have something written in them and all the cost fields that have nothing in them. Here is the script I wrote, the problem is that is only does the find on the first repeating field. [color:blue]Enter Find Mode[] Insert Calculated Result["Description", "*"] Insert Calculated Result["Cost", "="] Perform Find[] Is there something I'm doing wrong? Please help. thanks, Wild.

I'm hoping to do the sql equivalent of 'select distinct' in a filemaker find. I'm in version 7. I know I could write a script to give me distinct values, but I would hope this is a built in function. The manual makes no mention of such functionality. Thanks

Is there anyway to do an "OR" find without having to use "Add New Request"? For example, I would like to search for all projects completed in either 2006 or 2007 is there some command that will allow me to do so? Thanks for any suggestions... -Rebecca

Table1::Field1 is a global field. It contains a value I'd like to use in a find with Table2::Field2. I've tried the following as the Criterion in ScriptMaker: Table1::Field1 ==Table1::Field1 "Table1::Field1" GetField("Table1::Field1") ==GetField("Table1::Field1") None of these work. A literal does work. What am I missing? Thanks.

I have a form with some fields for entering data into an inventory table. There is a portal on the form that shows the records related through a self-join to the PartsCode field in the Inventory table. I need to have the PartsCode field on the form perform two functions. One for entering new records and one for finding the related records in the portal.The PartsCode field has a popup with the list of Partcodes from a related bill of materials. Currently, when I select an item from this popup, it will find related the records in the portal, just through the relationship, but it also automatically creates a new record in the inventory table. This I can't have. I want it to …

I'm using Filemaker Server 8.0v4. Filemaker 8.5 Clients. I have a Company table that has a InactiveCalc: Let( LastDate = Max(CompaniesToOrders::OrderDate); Case( Date(Month(LastDate); Day(LastDate); Year(LastDate) + 2) < Get(CurrentDate) or IsEmpty(LastDate); "INACTIVE")) Basically if a customer hasn't placed an order within 2 years or hasn't placed any orders since we implemented our new database the Companies::InactiveCalc will display INACTIVE. The problem I have is when I do a Find/Omit on the field Companies::InactiveCalc I still have companies that show up in my found set that are INACTIVE. I created a sample script called Omit Inactiv…

I recall an answer posted awhile back but I've searched for 3 hours now and can't find it. User is viewing a found set. Script (button) performs another find. I must provide User with messages and choices if records are found so I need Error Capture [On]. But, by doing so, I lose the prior found set if cancelled (FM only restores the prior found set if *it* handles it). The Exception (if no records found) must return the User to the prior found set. Allow User Abort [ Off ] Freeze Window New Window Set Error Capture [ On ] Perform Find [ Restore ] If [ not Get ( FoundCount ) ] Close Window Show Custom Dialog [ "No records found" ] Halt Script…

Hi Guys - I am without a doubt an FM newbie. I am building a database for our small, online, business that checks the identity of a customer before we authorise payments to them. Customers have to send us documents that prove their identity and address. That part is all working just fine. What I need to do is to look for similar records to this customer record in the Customer Table and display the found records in a portal - if any are found. (We are checking to see if this customer may have previously registered with us using slightly different details). I want the Find Criteria to be defined through Check Boxes that the user can check or uncheck any co…

I want to make the follow find set: Let we have a field called find and a button to perform the find script beside it just like the webpages. I want depending the text or number I put in the field and then push the button to find anything in the database matching the text or number that I put. Just like a search machine of a web page that finds anything matches inside the site. Pascal

Hi , I've searched for an answer on how to find and omit duplicate records in Filemaker Pro 6 but can't seem to find an answer. It looks like I need a script, but the only ones I have found are for FM 7 and 8...can't use those! Can anyone help? thanks, MT

How would solve this problem: The user has a list of numbers to find. I have created a script that creates a new request every time the user type a number (in the number field) followed by Enter: if the number is left blank and the user press Enter, it is the end of the list and the find is executed. What the user is asking is: "Of all the numbers I have entered, which one has not been found?" The user can retreive the last find and get the list again, but it does not help him to know if the number exists or not or if any has been mistyped. I can compare the number of find requests with the number of records found but it won't tell me which ones were m…

I am trying to do a simple find. I have a checkbox field the user selects to add a record to the print queue. I have a script running that goes to that layout, finds all records, enters find mode, sets the field to "print", and then finds. It works the first time I run it, but when I add more records to the print queue it doesn't see the records. So I went directly to my layout cuz I thought maybe it was a scripting thing, but I get the same behaviour going to find mode and doing it manually. It seems to work if I quit out of my file, relaunch and then it works the first time through... does this sound familiar to anyone?

This is probably a simple question, but can you change the way FMPro 8.5 does a find? I believe it defaults to "begins with", but can an option be changed, or an input added that will make it find with "contains"? I know it was possible with CDML in 6, so the code for it must exist in the FMBrain. I am trying to get around using wildcards to search. Thanks for your help!

What is the script step to perform a find for a range of dates to be entered by the user. Is there a way the user can use the drop down calendar.

hi when im searching for emails in my database the ones that doesn´t exist results in a notification "record doesnt exist". is there anyway to add them to my database? if my search results in a record that doesnt exist cant i simply just have it added as a new record?

My database will consists of loads of duplicates to act as a backup whenever there is any amendments needed, but i only want to display the lastest of the duplicates, omitting and not deleting the rest. Each record is accompanied with a timestamp. I tried using the lastfunction but the results aint good, thus i am trying to script this omitting duplicates without any result.

Hello, I would like to create a script that would find and sort all the events that occur within a given month. The find would include all the events that have are associated with a certain contact person(d_contact) whose events are either in progress or successfully done(d_Show status can equal; First contact, need info, Waiting to be bid, Bid submitted, Bid approved, Contract sent, Signed contract in hand, Show done). I'd love to be able to select the month or have FM just select the current month. Any ideas?? Thanks in advance. Chris

Is there a way whereby you can click on a particular field, and by assign a script to the field will return any records base on the content in that field? ;)

I hope someone can help this neophyte. A "Samples" layout contains sample information and freezer locations on 60,000 biological samples. It is very tedious to manually create multiple sample find requests because each find requires the entry of three fields. To automate finding samples, users populate Excel records with three fields: SampleID, SampleType, and SampleDate. A script imports these fields into a related "SampleQuery" layout, but this is where the script fails. The plan was to create multiple find requests in "Samples" corresponding to the number of requested records in "SampleQuery". The script would move SampleID, SampleType, and SampleDate from each"Sampl…

I am trying to do a find where I am searching through keywords in my db. I want to find any record that has at least one of these keywords in them: doll barbie marie osmond but not these words dollar dolly I cannot figure this out from my filemaker books. Any tips on this would help * Thank you for taking a look Okay I understand now that I can use =doll & then do another find & constraining or extending the found set, but just wondering if there is a syntax that can be entered in one find field that will end up with the same final result set?

I have a database of paint colors that I purchase. Each color has 3 purchase costs depending on the size of container I buy. For Example, my code for containers is K3, DM, and TT. An example price for Green is $5.97, $5.28, and $4.85 (for K3, DM, TT purchases). For Blue, I have $5.86, $5.23, and $4.75. I have a master table of colors (rows) and prices (columns). What I want is when my purchasing agent enters the color (from a dropdown list) and the container type (K3, DM or TT), I want a field to return me the correct purchase price. I am confused on how to define the unit price. I know I need to tell it to look up the color and then look in the proper container-typ…

Most of the post here are basically finding records that fall within a range of dates. Right now, i need to search records base on a date that falls within a date range in the record. E.g.A record with these fields: Arrival date = 20-12-06, Departure date = 25-12-06. With the find mode, i need to find a specific day, say 23-12-06 and if this date falls within the arrival and departure date, will display all related records. If i input 26-12-06, it will not display the record above.

I am trying to get the tutorial "find dupes" working but it will not put the 'x' in the box. Does it work?

Hello there I am new here so please forgive my ignorance but I could not find an answer to the following question when I searched the forum. My problem is actually a fairly simple one, although (obviously) the solution may not be all that simple. Let’s assume I have two related databases (in Filemaker 6, I am afraid) a master database called “People” and another one called “Letters”. Letters can be of different types (eg, “Invitation” and “Rejection”) and will have a date associated with them. I would have several letters per person in the “Letters” database. I have a portal in the “People” database displaying all the letters sent to a particular person. P…

I need some help on how to set up the following type FIND in possibly one step. I want to search on the STATE field pulling up only records for certain states, e.g., MD, VA, NC. (I have no problem adding other fields to the find, e.g., those with email addresses in the above states and those who are "active" records.) When I enter the criteria in the initial FIND screen, is there a way I can enter multiple states on the same FIND screen instead of doing individual finds for each state? I suspect the answer may lie in creating a script but I'm new to FM and not well versed in scripts. Or do I have to do a series of repeated "constraints" Or, alternately, …

I've just changed my database so that instead of having space hungry "Yes No" radio button fields, I have a small container field. Which, by way of a script, shows either a tick image, or no tick image to denote Yes or No. However, If i enter find mode, it no longer shows a tick and clicking the field will not toggle it on or off. Any ideas how I can get around this without puttin gback my unsightly radio buttons?

If you look in the attached file and go to the "CFA letter" layout, you will see that the list only shows one record thought there are two there. How can I set it to show all records listed downward as it does in the "master list" layout? FM.zip

Hope I am in the correct forum. I am very new to the whole Filemaker thing, am taking over for our previous admin. We're using Filemaker 7. I am mostly used to working client side. There is one thing I have not been able to figure out in all this time. Is it possible to use the Find/Replace function across multiple records (instead of fields), so that I can change certain values across all the records? I can't figure out how to do this no matter how much I have looked. I am assuming it is possible. (Or is it?)

Hi - I have a field called max(Trans_Date) which returns the most recent transaction posted, but I also want to return the amount associated with that record. I have tried (and failed) a few different ways. If the related table has only one record I get the right amount via if(max(trans_date),trans_amt), but if I have multilple records I always get the oldest amt, or presumably the first found in the table. What am I doing wrong? Thanks

Okay, is there a way to make the cursor jump to a specific field when entering the find mode? I know I can make a script to do this via a button, but I want the keyboard shortcut (Command-F) to do this too. Any thoughts? Thanks! Jason

I have list of people with their current employers. At the top of the list I have a pop up box (Field: EmployFilter, global value I suppose?) with all the employers names. How can I tell filemaker to only show the employees of the company that I selected in the popup box? Help would be appreciated, thanks :

I've got a database with a field called "job #" which is a five digit number. How can I search for multiple job #'s at the same time? For instance, say I want to search for three job numbers --58347, 59315, 60301--and have Filemaker return 1 or 2 or all 3 records if they exist. Thanks.

I have created a field that counts hits from a related table, that works fine. BUT, i cant search on the field, it just gives me the result that all matches... The count field is not stored cause it is going to change, does that have anything to do with it? And what can I do to make it work? Regards Jocke

Hi everyone, in my solution I have this scenario: My main detail layout has 3 different "Reference Fields" (these fields hold reference numbers for clients etc). I would like to have a find screen that lets the user enter a search term once, and when the user presses the Find button (my own creation, not the FM status bar button), have a script search each record in all 3 Reference fields for the search term they entered. The problem I've encountered so far is that you can't set all 3 Reference Fields to the search term at the same time because not every record has the search criteria in all 3 Reference fields. If extend found set is the answer, how would …

I need help displaying info, I need to get records for a printing list that are from x date to y date, where can I find an example like this? Thanks, JBarber

Hi, I'm using Filemaker 5.5 and I'm trying to write a script that finds records in the past 7 days. This is what I've done: [color:blue]Enter Mode Find[] [color:blue]Set Field[Date, Today-7 & "..." & Today] But this does not seem to work correctly. The only thing that gets entered into the date field is the value for 'Today-6'. The rest of the code some how just gets ignored. Does anyone have any ideas how I can get this to work?

I have several showrooms in a "Shwrm" field and wish to have status reports generated in another layout for each showroom. I can successfully run a script that gets the showrooms to list in the layout but want to know if there is a way to have a new record (page that can be printed independently) created in that new layout for each showroom. Here is the script I am running currently. Enter Find Mode [] Set Field [Current Order Status::Shwrm; "JRFL" New Record/Request Set Field [Current Order Status::Shwrm; "GMAT" New Record/Request Set Field [Current Order Status::Shwrm; "JRDC" New Record/Request Set Field [Current Order Status::Shwrm; "IDCD" N…

Is there a way to exectue a script when a one of the "cancel" "continue" "Modify Find" buttons are pressed. I know how to continue the script when the continue button has been pressed. (ie If[ Get(Last Error) =400] etc). Essentially I would like all my buttons to work the same way the continue works, or just being able to disable them all. If anyone has any insight it would be appreciated. Thx Jeff England

Some background first. I have a database where I have about twelve showrooms with multiple fields per line. I want to select six of the twelve showrooms so my options, so I think, are to either omit the six I don't want, or to find the six I do. I am able to successfully find one of the criteria but cannot seem to include multiple showrooms in the find field. What I am doing now is for the Perform find I am Finding records and for my Shwrm field I put AMNY for the first field, and for repetitions put 2 and for the second field I put JRFL (and so on), but it does not return multiple. The same happens when I try to omit several. How do I do this? See pictures below.

Hi, I'm trying to create a field that will tell me whether someones membership is current or not. By current I mean renewed within the last 18 months. I have an expiration date field so I would like the new "current membership status" field to be a calculation that used the case formula (I think)that would give me either "okay" or "expired" as the result. Am I on the right track? I just can't seem the calculation to work. Here's what I've come up with so far: Case(GetField(current date) >= Date( Month(expire date), Day(expire date) , Year(expire date)),"expired","okay") But I'm stuck with how to figure out 18 months calculation.... Do I use the month (expir…

I have a database set up to keep track of customers. Each customer has a unique ID number (automatically assigned). The problem: Customer A's ID is 128 Customer B's ID is 1287 When searching for Customer A by ID number 128, both records are found instead of just the one. (This creates a problem when trying to pull up one customer's purchase records, which incorperates their ID.) Is there something about the ID field itself that needs to be changed? It's not a huge problem, but it gets more irritating the more ID numbers that are added. Any tips?

Searched the forum threads for this problem but came up empty handed. I am searching the "last name field" for names M I also get the "Smith-Doe" name included in the search. Is there a way to avoid getting these hyphenated names in both searches? Many thanks,

In the "Job Pro Central" application, during order entry, you click on a line to add a line item. Instead of the usual lookup, this brings up a screen where you can enter a few key characters, then press TAB to see a filtered set of the items you are looking up. (see attached screenshot). Then you select the item you want from the filtered set. Anybody know how to do that ? thanks

I am new to Filemaker. I am setting up a Customer contact list, that has a calculated date field. I have the customer's birthday, and then I calculate the date 3 months, 6 months, 9 months, and year from that date. How can I set up a report that will go through all my contacts and pull out just the calulated dates that happen this month? Can I set this up to automatically run and print a report on the first of every month for example? HawkLA

Hi, Is it possible to have a layout only show certain records and not all records? In other words, can I make a layout that automatically finds a select set of records so that I don't have to run a find every time I use that layout? Thanks, MT

Hello Everyone, My current database project is made up of read-only data imported from fixed-field text files and all fields are made of calculations that grab certain characters from the line of text using the Middle calculation. So, no data is modifiable because of being based on a calculation. My problem is that most of these text files contain an even 15,000 lines or records. I have one import, however, that shows 15,001 records, despite its corresponding text file only having 15,000 lines (i.e., there is a duplicate record that snuck in somehow). Without visually scanning all records for the duplicate, is there an easy way to find a duplicate? I'm currently…

I have a products, cutomer, vendor, invoice and a join (this table is a link/joint between invoice and products) table In the products table I have Stock_in_Hand and Min_order_level and Reorder_Level fields. If Min_order_level is less than or equal to Stock_in_Hand then I want to show in a portal Reorder_Level is in red. I can do this. But I do not how to create a portal that shows automatically that a particular product is less than min order level, which indicates that it must be reorder... Do I need to create another table or something linked to the products table?? Please help....

Please forgive me if this has already been addressed, but I can't seem to find the answer to my question anywhere. I have a simple image database which needs to be searchable by keyword (like your standard search engine). Is there a way to enter keywords into a single dedicated search field and perform a find which will search all fields and return all records that match the search term(s) in any field? thanks, Jenn.

Okay...I'm in way over my head here. My very limitied DB exp is with Access, so I might be over thinking this database in Filemaker. I'm just following orders on how this thing is supposed to look and operate...so bear with me. This is going to be long. The REAL "find" question is coming, I swear. The DB is to track resume data (pretty straight forward). The end result should be a single form with the general stuff at the top (name, retired rank, status, etc.). The bottom of the form has three tabs. 1. Experience - this is supposed to be a series of check boxes. We're tracking functional expertise, where they were stationed, specific aircraft, etc. [THIS IS…

I have an inventory table that will have thousands of records in it. There is a calculation field named "Available" which is the current inventory level of the product. When that value is negative, it flags the product to be purchased. I import the flagged records into a temporary table to work with. My question is; Is it faster (better?) to use the "Perform Find", or the "go To Related Record" script step? I have used both in other situations, but never with so many records involved.

Hello Team, I'm working on a database that lets me look at student attendance for a school district. There is a table for "Students", a table for "Schools", and a table for "Attendance". I would like to be able to include a "Top Ten List" of students with the most attendance problems for each school. A top ten list for the district would be great, as well. But I want the fields to be displayed on a layout, not just in a preview. I see how I can run a search and sort for a report. But I would like to display this on each schools summary layout. And I don't want it to bury the user with EVERY instance of an absence, just those students that appear the m…

I have found a set of records that fall between 2 dates. Now I want to do a report on all those records "except" for the ones where fieldx = "abc". Records with fieldx equal to "xyz" or "pdq" are OK, I just need to eliminate the records where fieldx ="abc" from the find set. Is there a way to FIND for fieldx "not equal to" "abc"?

Ok, so I am making a very simple Book Inventory DB. All I want to do is make a button that will sit besides the "Author" "Series" "Ratings" and "Genre" fields that, when clicked, will look at the current information in the appropriate field and pull up al records that match. I can't figure out how to set up the button to look at a specific field. Thanks for your help. Jbob

Is there a way to extract a list of unique values from all records. I am trying to produce a list of vendor names from checkbook entries. Some of these vendors receive just one check during the year and some receive several. I want a simple list of everybody who received a check, without regard to how many checks they received. How would you perform a find that just displayed one value for each vendor? Any ideas? Jarvis

I have a drop down list where it is necessary to search for any of the items in the list that are selected (by holding down the command (apple) key). This creates a repeating field entry in the find global. The field it is searching is not a repeating field and therefore would never match the repeat of the find global. Is there a way to take each entry in the repeating field and have the search return any records that match any of the words in the repeating find field? Thanks, Drew

I've got a customer page that displays cutomer information. Each customer has a series of Jobs associated with them. I want to be able to display a single job at a time, and have buttons that will advance thru the rest of the jobs. How do I go about doing this? I've got a table for contacts, and a table with the job information in it. Each cutomer has a unique number and the jobs table has that number assigned to each job for that customer.

I have set up a table for all my media assets and I track the type by having the user select a dropdown list to select what type of media they are entering for each record (tape, cd, still image) etc.. I have a related table that is my project table and when the user views the project table I have a portal showing all the assets that associate with that project (no problem). What I want to do is have the user go to a layout where they can see the media assets listed in their separate catagories in scroll-able lists.... if I could get the portal to run a calculation that would do the trick, or is there some other method? Thanks for any help you can give.

My database has three value list fields which are check box type. Each fields contains four to five values. For instance, Field 1 contains value list of A1, A2, A3, A4, A5 Field 2 contains value list of B1, B2, B3, B4 Field 3 contains value list of C1, C2, C3, C4, C5 I would like users to be able to find records using both "And" and "Or" criteria on one search. So another field with "And" and "Or" selections will be added for users to choose for each value list field. An example of the search is: A1 or A2 or A3 B1 and B3 C2 and C5 Is it possible to write a script to perform the search?

Hi All, is it possible to use a variable in the Preform Find Script Step? I'm trying to match the exact part number in variable set earlier in the script but == $Part#Search doesn't seem to work -( Thanks Peter :-)

Can anyone tell me how to change from find to omit after entering find mode? Enter Find Mode [] Set [table name::field name; $variable] New Record/Request THIS IS WHERE I WOULD NEED TO OMIT INSTEAD OF FIND Set [table name::field name; $variable] Perform Find []

Ok Gurus... what started out as simple seems to be more complex than I have imaged: I want to query some data in my DB. I have a date range and a drop down box (which I have also tried as check boxes). When I try to query the drop down list and make more than one selection, it seems to think of the selection as AND not as OR so I get no results. Did I make some kind of fundamental design flaw or should this be possible? I don't see the value of check boxes and drop downs if you cannot query based on their selections? Any help would get me out of statistics hell today... Thanks.

I have several tables (4). What I need now is a central search screen (I have), where I can input a search item, and search for this item in the 4 different tables. Then display the result of the found set from the different tables in portals on one layout. An empty portal = no records found, otherwise a list of items. Right now I have only or nothing, or all the records in the different portals. How do I have to go for this ? A separate table ? But how do I have to make the relationships ? Or am I looking for something that is impossible ? TIA

Hi I am trying to build a music archive database. One of the layouts has graphic buttons of various instruments featured in the archive. Another layout is a list of all the instruments in the database. I'd like to be able to click on the instrument icon in the first layout and reveal only the entries pertaining to that instrument in the the second layout. I've tried using omit all and find but I've hit a wall. This would really get me out of a jam. Also. I live in Cork in Ireland and would be keen to find someone who could train me to a reasonable level of expertise in FM. Thanks in advance

I have a database of 100,000 records. the records vary from random letters to words to words with random characters. Anyone know if it is possible to compare these records to a list of words from a dictionary and "FIND" all records that have dictionary entries in them?

When a find is performed and no search data is entered into the find form and the user clicks on find button in my find layout the find script exits and the user is dropped out to a form layout that I don't want them to access. Has anyone come across this problem and, if so, how do I control this default action with my find script?

Is there away to perform a Find Script in a database (or database table) using a global field or a calculated field that stores the result of the global field?

Hello, Kind of a dumb question - I am creating a script that needs to find all of the records with a blank field. In my case it is a service_date field. Anybody have an idea on how to do this? I have tried service_date= to no avail along with service_date="" and service_date=" " Any help would be greatly appreciated. B

Here is the problem. I have an employee layout. When I am looking at an employee on that layout, I want to be able to run a report that shows all info for that employee. I have a script that runs this report with a button on this layout. The problem is, I don't know the correct way to put in the script, "show me this record only", and not the found set. I want the correct way for the script to select the current record shown, and print that individual only. Thanks Dave

I have set up a find using global fields. In the example below I would like to search the size of something. The calculation I used resulted in an error that says this number cannot be evaluated and I dont know why. Here is the case statement: Case ( (IsValid ( F_Size_Low ) and IsValid ( F_Size_High )) ; "(F_Size_Low) & "..." & (F_Size_High)"; (IsValid ( F_Size_Low ) and IsEmpty ( F_Size_High )) ; "(F_Size_Low) & "...50"; (IsEmpty ( F_Size_Low ) and IsValid ( F_Size_High )) ; ""0..." & (F_Size_High)" ) The first test says that if both are valid then search the range. The second say that if the low is valid and the high is not, s…

Hi all, I am working with Filemaker 7 and one of the main problem I encouter lately is that people are in find mode and dont know about it. They then try to enter new customer information and then freak out on me saying 'It was all there and it all Disapear I didn't don anything wrong'. I try to teach them the find mode but still error are comming in. Is there a way to Put a big red FIND MODE in the middle of the form so my staff dont screw up ? Or somthing like change of color, I feel the dotted line arond the field just is not visible engouh Thanks

Hello, I would like to be able to find records that the text is in all capital letters. Is this possible? If so, how? Thanks, MT