Finding & Searching

Hello...I'm very sure this find is simple...I just can NOT figure it out to make it work. Here's the deal. There's a pull down full of colleges where our events are going to be held, a 2001, 2002 and 2003 button...and then a find button. All I want to do is pull down the list and select a certain college (Covanent College for instance), click on the year, 2003 for instance, and then hit find and have FM show the results in a specific layout called Camp Registration Overview showing only that College for 2003 that will display all the events going on at that college. The pull down box is called _text 1, the year buttons are called _year, and I can not figure ou…

Hi, in my contact database, i have 4 tabs (Client, Prospect, Employ

I need to know how to structure a query to gather data across relational >databases I use to monitor my patients progress through a research project. >I currently use 11 patient encounter driven relational databases I >designed and need to retrieve data for study. >I am a somewhat experienced user but have not been able to construct >this query to make it work properly. > >Thank you for your help.

I have a saved find that I mostly, but not always use. How would I find a group within this saved Find? I

I have a strange problem with script steps and find. I want to search to dates that

I'm using FileMaker 5.5 . I have a report layout and a find layout. I have a script that takes the user to the find layout and shows the result on the report layout. On the report layout I have a global field so that the user enters data on that global field to prevent the user from changing data by mistake. The problem is that it isn't possible to enter data in a global field during find ? In case it's not possible what should I do to prevent user from entering data by mistake, instead of using the report field on the find layout ? Luiza

How would I save a "Find"? My "Find" consists of 6 requests. Or is this a function of scripting?

Is there a Mac command key for this so that I can use the Home key to go to the top of my current sort and bottom with End?

I have just spent the last 2 hours thinking I am going stupid - perhaps I am but a very simple sequence appears not to work I have a simple manual find followed by a simple sort. Both the find and the the sort are attached to scripts - BOTH WORK FINE on their own. But... Enter find mode and then enter criteria hit return as step 1 of another script then run the sort immediately afterwards on the found set as teh second step AND.... Nothing! I just cant see why. I have tried various combinations of keeping and restoring the finds and sorts in the script steps all to no avail. I am sure this is a case of mental block so please help asap thanks everyone

Hey guys, Is there an easier way? I'm wanting to do a search across all fields. Not a request search because I dont' know which fields my information would sit in (i.e there's 6 directors i want director Joe Bloggs, is he director 1,2,3,4,5 or 6? Therefore I've created a "full text" field that concatenates all information and it's pretty scary (see below example - i just had to add it for fun ). The user will then do a search in this field alone. Is there a simpler/better way? Company & " " & CompanyACN & " " & CompanyACN & " " & Director1BirthDate & " " & Director1BirthPlace & " " & Director1BirthStat…

Hey everyone...I'm a newbie...and I'm sorry for probably asking such an elementary question but here it goes: I need to find a way that when they click on the button it does a search for data that contains the year 2003 and for a specific college name and then sort it and put it in a list layout. IE: "Jane" is wanting to apply for an internship with Converse College, "Sally" needs to find out what times she's got available for her to come and interview with. So "Sally" needs a button that does a find for Converse College and the year 2003, and display the info in a list format so that she can tell "Jane" when to come. The names of the fields that the inf…

I wish to do two things. First, I want to set up a field in File1 that is automatically formatted like a telephone number such that, if one type in the number 2125551212 it will look like (212) 555-1212. Second, I would like to import a file of telephone numbers into a separate file (File2), which are formatted as digits only (i.e. 2125551212), and then find any of the corresponding phone numbers on File1. Thanks, The Mad Jammer And then...there was nothing

Dear All, I would like to know if there is a case for finding with case OR : Enter Find mode Setfield ("A", "a") Setfield ("B", "b") Perform Find That case finding a and b ...but not a or b ....is there a case finding a or b?? Thanks

Hi All I have an intake DB that stores a list of children awaiting placement into foster homes. When placed, the kids are removed and put into a child database. The ones that remain eventually move into a "unable to place" mode. Occasionally, these kids are referred to the agency again and need to be moved from the "unable to place mode" to a "remain in intake" mode. What I need to do is create a find feature that will allow a social worker to enter FNAME, LNAME, DOB, and SSN and have the database identify if the child has been in the intake process prior to the current referral. Any ideas on an elegant and user friendly find interface? Dr. Ken

Thanks guys- I have another related problem: I have a main menu with 4 button choices: Baseball, Basketball, Football, Wrestling-each button goes to a different layout- I have over 3000 records in the entire database. Is there any way that when I select a layout it goes to the correct set of records- for each sport? Is there a checkbox that I can put in each record to specify the sport- and then have it search by this? (So when I hit the baseball button it brings me to the baseball layout and shows the corresponding files) Thanks again, hope you can help with this one! -Christine

I have a layout for students to sign up to take an SAT Prep course. It has 8 sections of Radio Buttons to choose Verbal and/or Math on 4 particular days at 2 particular times each day. I want to create another layout that will keep track of who signed up for each particular day/time. Ex. - If Johnny picks the Verbal on Monday from 3-5 p.m., how can I get the second layout to show the name of the students who chose the Radio Button for Verbal on Monday from 3-5 p.m.? Any help would be greatly appreciated. Thanks!

I need to do a find based on two numeric fields being the same. The value itself will not be constant. In other words the search criteria is that the two fields are the same, regardless of the value in the fields. I am clueless at the moment - only a couple of days into FM (Pro 6) and I can't seem to get to first base with this. Once it gets worked out I then need to save that search somehow - I'm surprised that there doesn't seem to be some straight-forward way of saving queries (finds) - but I'm sure that's just my lack of conceptual understanding at the moment. Very gratefull for help. Glenn

I'm having difficulty using the find command and "<". I have a calculation field (in a portal) that calculates if my clients paid less than their monthly payment. To do a find on who is short this month, i'm finding on this months date (on the date field in the portal (which has the date - MM/DD/YY)) and the payment calculation field using <0 - meaning they owe money (the calculation field will show a negative balance so i want it to find the negative balance). I'm plugging the info in on a singal find request. It's weird. i can't figure out the logic it's using. it worked fine when i had a few test records when i first tried it a month ago. Now i have 30 reco…

Hiya, I am trying to generate a script to run a find based upon the current value in a text field (field title "Interviewer"). This field shows values from a related file and the user enters the data via a popup value list. It is a non-global field. What I am trying to do is find all the records that pertain to the value of the Interviewer field, then run a sub-script that generates a report/summary report. I have the script for the latter part, but I would like some help to put together the script for the initial find. Thanks in advance Jodi

I am attempting to build a media buying database for my ad agency. The project consists of three parts. 1. Insertion Order, this is the heart of the document, the other two parts just pull parts of this to summarize information. 2. Client Summary, pulls specific information from the insertion order 3. Media Flow Chart, Simple sub-totaling of parts of the I/O My problem is the way that I have it set up I can only sort/find by network, I have date fields set up and I need to be able to group by date and then by network instead of the other way around. Can somebody please look at my solution and see if they have any ideas as to how to make this work bette…

I

We need to send E-Mails from within a filemaker runtime aplication on Win32 platforms. Moreover we need to attach a specific file to the mails we send. The only way we can locate this file is by using a relative path to the database we are currently working in (we will place it in the same folder but we don't know the absolute path!). Of course we already tried some plug ins (dbMailer and SMTP.it), but we didn't find a way to attach the file as we don't know the absolute path to it. Does anybody have a solution??? Thank you very much for replying... from within a filemaker runtime aplication on Win32 platforms. Moreover we need to attach a specific file to the mails…

hi, all ! can somebody show me how new fmp 6.0 perform find script step works ? there is [ replace found set ] , [ constrain found set ] , [ extends F.S. ]. what does each option do ? how should i use this in a real script ? --- specially compare to the old perform find. thanks, kyle

Hey, I am having this problem... Well, I have a FMP files with around 70,000 records. Everytimes I do a search/find/delete a record or multiple record it takes a long time to complete (average 20min). Is there anyway to solve this problem? I am sure my computer is not really a big factor since I have the latest computer components (P4,DDR Ram etc...) Any help will be appreciated!

Hello- I'm trying to make a user friendly search layout. How can I use checkboxes to search through my long set of notes in a text box- and then show the records it found them in. (I want to gear my checkboxes to keywords used in my notes for each record.) -Christine

Scenario as follows - In FM file, select an item category from popup list. A sub set of items appears in 2nd popup box (eg select Soda in list 1 - sublist of sodas appears in list 2 eg Coke, Pepsi, 7up etc) Now the next step is to have 4 fields - Supplier, Contact, OfficeTel, MobileTel - so that when you select (eg) Coke - the suppliers details appear in their correct fields. Can someone guide me through this PS ... many thanks to Jason ... thus far. cheers

I SCAN FILES INTO A FILELD THAT FILLS IN THE DATE AND TIME (12/27/2002 @ 12:12 PM) I WOULD LIKE TO FIND RECORDS IN THIS FIELD THAT ARE GREATER THAN A CERTAIN TIME ON THAT DATE (WILL ALWAYS BE TODAYS DATE). FOR EXAMPLE I WOULD LIKE TO FIND FILES THAT ARE SCANNED BEFORE OR AFTER 12:00 PM. I CAN FIND FILES FOR THE DATE BUT CANT FURTHER REFINE THAT FOR THE TIME. ANY HELP APPRECIATED.

I was wondering if its possible to do a search some text field that starts with space or has blank line. Example in a text field users are entering codes by pressing space first or pressing enter key after they enter information. I need to find and eliminate all those information that contains space or blank line. We have tons of records and it is impossible going line by line. Thanks in advance.

Anyone one have a suggestions? I always rececive common questions about our software, so I thought I would TRY to create some sort of knownledge base for my users. All I want really is one field that you select the product you want info on and the other field is where you define the problem you're having. I would like it to some how point to either notes that I've created in another DB or tech notes that I have downloaded off the web. Can anyone point me in the right direction? Thank!

I have two FM databases Main and TimeSheet, in timesheet you enter a job number and a status code status (1 to 5) and the start and finish time on that job - it give you the hrs/mins used for that job - setup in a columnular page/line entries. The main Database holds the job number for the look up and that works fine. What I want to try and do is run a script from the Main database that will open the timesheet database and use the following logic.... get currently browsed record jobno of main database, match to equivilent entries of jobnumber in timesheet database and also match a status code for example = 3, if bth these events are found to occur in the found r…

I am using FM4.0 , windows 2000 pro. I have setup a SalesLine file, where each item sold is a seperate record, appearing as a line. I have a seperate file for customer data. I have a separate file for Inventory data. Since different customers get different discounts depending on the inventory type they purchase, I have a seperate file for Discounts. ********* I want the sales person to be able to enter the customer unique number and the computer whizzes all the desired customer data into the SalesLine record. I got this working, piece of cake. I want the sales person to be able to enter the Inventory unique number the the computer whizzes all the desired In…

I am writing a report which needs to exclude records which have x in field X (boolean OR) have y in field Y. I did this in find mode by making a request to omit records with x in X and added a second request to omit records with y in Y. So far so good. Here's my problem: My report generating script goes to find mode, and then pauses on a layout so the user can enter the ID number they want the report on. Then the script does the find, returning a set of all records with that ID number. Problem is that this find wipes out the original find that gave me the set of records I need it limited to. Can I script it so the find will happen WITHIN the original found set? …

I hope i am asking this question in the correct section. If not i apologize. I did some searching on this forum and cannot seem to find what i am looking for. I might not be entrering the correct search terms. What i have is a membership database that tracks member information. Pretty basic. I do have a field that is called DueDate and we simply use this field to track the date the member has paid there membership dues. I want be able to print a report on what members are past due and then print it out. I tried making the calculation field but no luck. My calc skills are sketchy. Thanks for any help you can give. Thanks and take care.

i am perfoming a search in one file and the data being used in this search is in another file. I could enter find mode then get a script to copy and paste the data across, however i would rather use set field but this does not seem to work. I have set up a relationship between two fields which are always equal to 0 however when i try to set the fields to value from the other file while in find mode it does not seem to work. Can anyone help please. James

I have file (report.fp5) where a user enters information for performing a find and creating a report with data from another file (checklist.fp5). On the report.fp5 file the user chooses the name (from a list), begining date, end date and a checkbox that let let him choose if he wants the report to have everybody from the name list or only the name he selected.Depending on his selection on the checkbox, a diferent script is run. >If [checkbox=""] >Perform Script ["individual report"] >End if >if [checkbox="all"] >Perform Script["group report"] >End if If I perform the scripts above individualy by going to the script menu and se…

Here's what I would like to do: I have 2 files called Customers and Prospects. I would like to somehow compare the two files. If a Customer record appears in the Prospects file (based on first and last name) I want to remove the record from the prospects file. I can envision a script that would do this, but it seems unecessarily complex to accomplish this task. Does anyone know of a shortcut, or is there something I'm forgetting about? Thanks in advance. As always you guys are great!

How can my line items always appear with the last record first. I want to see the last input in the head of a column instead of being sorted by the FM File number

I have a field (Decision) whose value is selected from a value list. Two of the possible values are Exempt and Exempt + Pts. On many finds, I want to omit Exempt while including Exempt + Pts. The obvious solution is to Omit where the field Decision has find criteria: ==Exempt. To test this, I did a simple find (not an omit) where Decision had aforementioned criteria (==Exempt) and I get no records found message when I know I have 200+ records that match this criteria. If I leave out the exact match symbol and just find on Exempt, then it returns the 200+ where the decision is exempt as well as the 100+ where the decision is exempt + pts. Anyone know what could be …

Hi, I have been trying to figure this out for a while. Using FM 5.5, Windows. I have created a homeless shelter resident tracking system. Among the fields are "datein" and "dateout". I need to run reports monthly showing how many days the residents were here in that month. THere are residents that were there all month, some that came in during the month and left in that month and others that came in during the month and left either the next month or are still here. The date out may be empty if the resident is still here. So, for each resident that was here in the month, I need to determine how many days the resident was here. i.e., J. Smith - 5 B. Smith - 21 …

In my database, I often use a change of text color when the calcultations conditions are not made. For instance, a field "Invoice N

Hi all, I've got a file that I use as a list that other files access. It contains each possible item for checkout. e.g. if there are 10 Hyperstudio CDs available for checkout there is a record Hyperstudio1, Hyperstudio2, Hyperstudio3, etc. Now I want to be able to print off a sheet of everything available for checkout, but I only want the last record to show on this sheet. That way we can see which items are available for checkout and how many without actually having a line for each record. How do I do a find for each item and get only the highest number of that particular item to show? Thanks.

Hello! please could someone tell me if it is possible to save a find to a specific form so that when a button is pressed and the report is opened then all the records in the database dont show only the records in the find. Thanks for any help.

Hi again.... I have a little question, may be this question is a newby, but I need your help, ok the question is... Can I compare a found records? i.e. I found the same patient between a relationship, can I compare all dates fields (next_app) with prev_app fields in the found records. Maybe like show above: If found record (1) field -next_app- = found record (2) field -prev_app- Show Message, Stop Script. I hope you can understand this POST. I wait you answers, tks PD I using the FM Developer 6

I've created a value list (client-supplier-personal) in an 'address book' database. What I'm trying to do is work out a way to perform a search based on one of these values, the find would display all our clients for example and not suppliers or personal, with the ultimate aim of printing address labels from the search result. Does anyone have any ideas as to how this could work? cheers, Andy

Hi there I'm new to filemaker, and I'm running into a really frustating problem that I'm hoping a guru out there can help me with. Here is the set up. I have a basic database designed for entering, sorting and summarising bugs in a piece of software. All is going well except for a "statistics / summary" page. What I want is a page that summarizes the number of bugs of different states, and different severities displayed in a table like (and this is a simplified version):- Total A B C D < these are severity categories All bugs 25 2 17 2 4 Open etc Open please verify fixed…

Hi, Is it possible to hide a record or make it invisible while still allowing the record to be in the found set? Basically, is there a way to hide a record without omiting it? thanks! Nate

I've converted an old Excel spreadsheet to a FM database. In my old Excel file I had a list with a column called MoD that contained one of six possible values (FTP, AdDrop, Disk, AdExpress, AdDirect or empty). My new FM database contains a cell called MoD and I need to be able to count how many records have a value of "FTP in this cell, how many have "AdDrop" in this cell, and so on and so on... I can do it using AppleScript but it's very slow as it has to check every record individually. I need this to be quick, dynamic and accurate. I'm a newbie to FM so if you can help me out with clear, precise instructions I would really appreciate it! Thanks, …

2 databases.... 1 statisical with one record just counting records from other bases. The other has 2500 records or so which has a field describing who's approved and how they uploaded the file. FTP, ADDROP or disk. We want to count the number of records in file two whose delivery method is FTP and enter that number in the stats base. Please forgive my ignorance as we 'just' got FM the other day. Lots of ambition....just waiting for the Bible to come out lol. IT SEEMED SO SIMPLE AARRRRRRGGGGGHHHHHH!!! Making me nuts.....grrrrrrr.... Any help woupld be a God's send. Cheers and Beers Andrew Mills

only one of us actually 'needs' help lol....we didn't know we were both posting here. Opps...sorry Andrew Mills

i have a file where i need to search for empty fields regularly. i'm using a find script that puts an equal sign in the field and then displayes the records - easy enough. there are some records i want to exclude from that find, because they're supposed to be empty, so i figured i just put a space in these fields, so they're technically no longer empty, but the find script still returns them as being empty. can i trick FM to make a space count as data? the smallest character i could find (a period) still counts as empty by that script. any normal ascii character works as expected, but then the field doesn't really look empty any longer.

Dear All, I have a little problem when trying to work with self-join. Here is the problem. I got a database name A with fields company(text) and employee(text). Since I want to know the name of each company . So I make the self-join on the Company. On the layout I put like this : Relation : company portal : relation: employee that works ...but if I try to find in the portal , I type the name in the portal ..it give me everything. or I use script to find ...it give me everything ..like setfield(relation:employee,"Bill") It give me all the name. Is it the correct way to do it? And also using self-join we get the same record normal record ...it give same …

I have to create a script which accomplishes the following. There is a master file which consists of student records (student name, social security number, courses the student has enrolled, the name of the prof who course the student has enrolled in, enrollment date, no. of lessons in a particular course, mid term test grade and the final exam grade). The script should search for all the professors and display the number of lessons the each prof graded, the no. of mid term exams the prof graded and the no. of final exams a prof graded. If a professor is teaching more than one course I need the total no. of all the courses lessons, mid terms & exmas she has graded.…

Hello all! I've set up two databases, the parent and the child. I wanted to see a subset of related records from the child whilst in the parent. I therefore created a portal in the parent. In the child I created a single calculated key with a number of paragraphs. The calculated key was essentially a field. In the field I incorporated the calculation below: " All

I am designing Find layouts which need to function smoothly cross-platform. I recall something about Macs and Windows handling the [ENTER] and [RETURN] differently. Unfortunately, I only have a Windows system for testing. I'm not sure how Mac's handle the scenario below. Could someone enlighten a newbie? I want a User to enter criteria in a global then, instead of having to click another button [GO], simply hit [ENTER]. Questions: 1) Does a Mac have an Enter key or is it called Return? 2) Would hitting the Mac Enter (or Return) key activate a script? 3) Can a script be activated upon leaving a field or is it even necessary to hit Enter or Return? And 4) Would…

I have to find all records in the database which satisfy all of the following conditions: 1. Expiration Date is within a range AND whose 2. FirstExt Field is null or empty AND whose 3. SecondExt Field is null or empty AND whose 4. Completed Field is empty AND 5. Withdrew Field/Tranferred Field is empty Expiration Date, FirstExt, Second Ext fields are all date fields and Completed and Withdrew and transferred fields are text fields. Please could anyone help me on how to go about this script.

... was wondering what people do when they decide to toggle the status area to hide? The "continue" button in the find no longer appears. Sure, we know to press enter to finish the find, but want to make it easy for user. Thanks!

I was given the task of modifying our databases to take away the actual "Delete" function and give the "ILLUSION" of deleting a record. I've tried many different ways to do this, but none seem to work. I have a field called "Found Set" (Global)which will show the current found set and a field called "Total Records" (Global) which will show the total records... This Logic seems to be right, but it doesn't happent that way in FMP... Here's what I mean: Perform Find <-- Pre determined find --> <-- Omit's records with the value "1" in the "Deleted Field" --> Set Field [Total Records, "Status(CurrentFoundCount)"] Modify Last Find …

Is there a way to have some buttons appear in a layout only when in Find Mode?? For example, an "omit" button. Or a "perform find" button. And the inverse... if I have next and previous buttons, how can I make them vanish in Find Mode? (In fact, I'd like those pairs to occupy the same space on screen... you see one or the other pair depending upon the mode. In both cases, the buttons need to be transparent to show through the graphic object underneath.) Can it be done?

Hi all. I have an event file with each event occurring on some date. I have another file, of activities, each with its date. The events and activities can be related via a common denominator, bookstore ID. What I need is to identify those activity records that fall within 1 week before and two weeks after any event to which they are related. Many of the activity records are not related to any event records and will be omitted. But some activity records could be related to more than one event record. I doubt that this is Find question but thought I would start here. I would appreciate any ideas for approaching this problem.

I want to write a script which will display all the records in my database which have enrollment date within a user specified range For example display all records where enrollment date is between 25th August 2002 to 25 Sept 2002. How do I go about writing this script ? Please could anyone help me out.

I have records for events at bookstores. Some stores have multple events. I want to Find those stores with multiple events with a date range. With Date1...Date2 in the date field and ! in the store ID field, the found set includes stores that have only one event within the date range. These store do have additional events outside the date range. Why does the Find include stores with only one event within the date range?

The FIND button worked great in my layouts when I was dealing with one set of records. When I was able to divide the data into two sets, filtering governed by a find on one field to separate in the "go to" scripting of both layouts, then the FIND ALL stopped working since it is still returning answers in both data types. I've been trying since yesterday to fix this and I did post in the scriptmaker forum but realize that that was a mistake and it should go here. Which is probably why I have not had any answer. The script-to-txt export is not perfect, but you'll get an idea at least of the FIND script (the global one) as it stands: Go to Field [ Recipe title ]…

I'd like to script a find to catch all records with event dates from two months back (say 60 days) through today and all future dates. I can't figure out how to set up that kind of date range. Thanks in advance, Leah

I want to omit all but one duplicate in a find. I have a class roster for each weekday but the people change daily. I only need them to sign in once so, I want to find only the first occourance of a person's name and omit the rest. This is to generate a list each day of people who were not on a previous list. Did that make any sense?

Help! I have a DONORS db (parent) and a related db of Donations (child). We add a record in the Donations db for each donation made with the donation date. In a portal (of donations), I do a find in the donation date field for all donations made during the year for DONORS. The found set of DONORS includes anyone who has donated during 2002, which is great, but the portal also lists all the pre-2002 donations. How do I omit these pre-2002 related records so I can print a 2002 YTD tax receipt for each DONOR that doesn't include portal rows of 2001 record. Please email me directly if you can as well as the post: [email protected] Thank you! Van DONOR db …

Is there anyway I can get FM to return in (a) summary field(s) the number of instances of several specific values from a single field? e.g. How many times "10" appears, and how many times "20" appears, and how many times "30" appears etc. Thanks, Ben

I am stumped on one aspect of my solution I am making for a local rental agency. I have a listing of about 2000 properties. THere is a properties page that includes the contact info for the property, and the property's features (ie; number of bedrooms, baths, type of parking, area in town, dog, cat, etc.). Noww the fun part..... the owner wants a QUICK way to search for a property using MANY of the filds and multiple vlaues in the vlaue lists within the fields. For example: I want to see what properties contain: 3 bedrooms, 2 or 3 bathrooms, in area 1 or 2 or 3, that takes cats and dogs with covered parking. Right now, I can't search for all of those because of the …

When in find mode, can a search be perfomed that is based on alphabet? For example, find all records where the first word in a field begins with "A" LR

Dear All, Do you see below how find unique does not work? enter find mode[] Set[field,!] show omit Perform Find let'say I have 1 2 3 2 3 ...I want to to find 1 2 3 ... since it is only unique value I want o show only unique value. Someone has any ideas? Thanks

I am a relatively new user, I just can't figure out how to use the FIND to show me records that have a particular field empty. I know how to use the IsEmpty function in a calculation, but is there a symbol to put in a filed when performing a find? I have tried < a certain # and <>. I need to solve this problem for fields that contain numbers, dates and text. Any help would be appreciated.

Dear All, How can we know that the position we are now is the last record? Thanks

Hi there. I have a re-direct page that finds a user name & gender and goes to the specified format file. The code looks something like this "...&username=john&gender=M&-find". When editing this line in my HTML editor, it says there are invalid characters, but the code works in Internet Explorer. The code does not work in Netscape unless I put the dash character before the search fields "...&-username=john&-gender=M&-find". This, however, produces an error in IE. Has anyone had a problem with this before? Thanks!

I've run into an interesting problem with the search routine I'm building into a solution. Say I have a record whose email field has the value "[email protected]" If I perform a search for "[email protected]" no records are found. But if I only search for "a.com" it finds the record. I know the problem is with the "@" but I'm not sure how to get around this, since users will want to be able to search for email addresses using the complete address.

Let's say I have an employee database. To save space, is it possible to set up something like a pop up menu, but the pop up menu would include all the fields in the database? For example, someone could select "city" and then in a space enter "Chicago" and then do the search. Can FM go one better and allow multiple pop up menus like this, so I can add a button for "more" and it would bring down another popup menu with all the fields, so I can search for all employees who live in Chicago and are named Smith. It's easy to do this in a regular FM database, just go to find mode and type the data in the necessary fields, but for lots of reasons I'm trying to save spac…

Ok it is working but it is complex and required a lot of thinking to accomplish. In my scenario I am using a self-relationship to a single file. The left side of the relationship is a global and the right side is the data. The field on the left side "KeyA" is a calc field based upon a few other globals. For sake of this description we will use: f1 f2 f3 f4 f5 f6 f7 These fields are all numbers and are only a few characters long. KeyA is a concat of all these fields with a space in between: The result would be 2 1 2 1 0 0

Hi, I need to add advanced search features in FMP, for example, there are 5 fields I want to put search criteria, there are "AND" and "OR" in each field. Field1: State Field2: Sex Field3: Grade Field4: Membership Field5: Profession I use checkboxes to display all the possible choices for each field. How do I make a script to search for people satisfying, say, the following criteria: From State 1 OR State 2 OR State 3, AND Male, AND In Grade 1 OR Grade 2, AND Member OR nonmember, AND Civil Engineer OR Architects I know how to use script to search multiple selections for a single field (counting the carriage return signs between the chec…

I have a Invoice LineItem db. It contains PayorID (related to Payor db) and ClientID (related to Client db). Each month it will contain 2-3,000 lineitems. Our payors have two criteria: 1) Each client must be on a separate invoice and 2) Invoices can only have six lineitems. I need to SET Invoice # and Line # through the series of records, to generate invoices. We have 18 payors and 850 current clients, so I thought of using a found set on a form in the Client db (Status Active) to find related invoices, perform the SetFields, then goto next record. Or a calc Payor/Client find combination in LineItem? I've even played with using Status(CurrentFoundCount) for the nu…

Going crrrazy. Here's my problem: I am working on fixing up a very scarily designed, uncommented, undocumented, nasty db that is used to track various factors related to clinical research. A very small piece that is currently an issue: Two files: Study and CommitteeReview Study with fields: Study# Title TrialType OpenDate ClosedDate etc. CommitteeReview with fields: ReviewDate Decision etc. related in a 1-many relationship (StudyReviewRecord) by Study# when viewing study record, the history of the committee review is displayed in portal...NOT A PROBLEM just want full picture expressed Then, the same two files are…

I have a large database with 3 fields (procedure1, procedure2, and procedure3) which may contain many responses from value lists. each of the 3 fields may have any of the value list responses. I would like to have a summary page where the frequency of each response is given. I have worked out a way of doing this by running a script with a loop counting through all records and checking the 3 fields for their contents. This has to be done for each possible answer from the value list, then putting each on the page. This works but it will be a lot of work to do it for each and may be slow when the database has a lot of records. Is there a simpler way of doing this? …

Okay, I give up... and I'll let my ignorance show... How the heck do you use Modify Last Find??? I want a script that simply goes back into Find Mode with the fields filled in like they were the last time Find was performed. (Not with what were there when the Script was created.) I tried just doing Modify Last Find... it doesn't go into Find Mode. So, I tried doing Modify Last Find and then Enter Find Mode []. That goes into Find Mode... and I briefly see my previous find settings... but then they vanish away. As if Enter Find Mode wiped them clean. So, I tried doing Modify Last Find and then Enter Find Mode [Restore]. That restores the sett…

FMP 4.1 on desktop clients, central server, on the way to FMP 6 real soon. In the past, I have created a browser-like find (type in search terms, hit enter/return, results appear in list) by concatenating the fields to be searched into one field, indexing it, putting the user into find mode on that field. Check "pause" in the Enter Find Mode step. Works like a charm. Well and good. However, now I would like to have users type their search terms into a GLOBAL field, hit return/enter and have the find execute (script takes global contents and runs the find on the concatenated field--one of the advantages is that they can enter these terms from any database but hav…

Is there a way to have variables in find mode? I have a bunch of finds that search for a specific $ amount. The price has gone up so I have to change all the find scripts. When I update the find this time I want have a variable for the money so if the $ amount gets changed again I will only have to update it in one place instead on 20.

field_a is a field in a related record on a layout. when i want to find on that field the find process is way to slow. it takes minutes to perform. the message i get is "find in progress - Processing field "field_a" is there something i am missing??

Dear all, I have two fields ...projectno and invoice Project no, invoice 1, 10 1, 20 When I use a find by projecno = 1 how can I get like below projectno, invoice 1, 10 , 20 I don't want to show duplicate number of projectno Thanks

Hey guys, I have this field that uses a value list of checkboxes. For some reason, when I do a find; checking a checkbox and trying to perform the find, but I get this error regarding the checkbox field: - "This field contains invalid find criteria, allow the invalid value?" Because of this, the query will not work.... Can anyone explain to me what is causing the field to be invalid in general? And what would be the best way to fix it? Thanxs Steve Griff

Dear all, Sorry my english ...hope you all understand. I have a database named A with fields (3 fields) Projectno Invoiceno comment 1 123 A 2 222 B 1 129 C When I use a find by Projectno with Projectno =1, how can I get like below Projectno Invoiceno comment 1 123 AC 1 129 AC What i mean is if same project I will get all the comments related to that projectno together. Do I use a calculated field or use script to to that? I really have no idea how to start. Thanks all

Dear All I would like to know if i have a field to enter (say Date1) and a field (say Date2) How can I find the records between two dates? or just enter into a field (Date2) ...I find all records before Date2? or just enter DAte1 ..I find all records after Date1 All by entering data in to Date1 and Date2 ...(not go search by ... in criteria) Thanks all

Hi, I have a database that is run through a browser. The problem is when searching for a field that contains something it will only search the first few numbers or letters. Thanks for any help Chris.

When I do a search for a word(s) in a large text field, I would like to know if there is a way to get the found word(s) highlighted in that field so as to make it easier to locate the word(s) in the field. TIA, Dave

Have five fields field 1:, field 2:, field 3:, field 4:, field 5: Can I create a field 6, to search on all 5 records? would this be a calc or script? RET

Not sure if this is the right section for this question, but I will post in both sections. Is there any way to copy the results found in a list to a field in a relational database? RET

Hi. I am doing a single date search, not a range. I would like to search 2 fields in 2 different related databases and have the single result placed in the main data base. restated: I would like to enter a single date and search for all "followup appts" and all "initial appts" for the search date and have that information displayed on the layout "daily schedule", along with the corresponding time and appt type (initial or followup) the structure: DB1= daily schedule DB2=followup appts DB3=initial appts the appt type is a global field in both DB2 and DB3 where I =Initial and F=Followup Currently, DB2 and DB3 hold the appt information. DB1 is where that…

I did a script to find data but when it finds the record , it goes to the record but doesnt move, i can edit it but if a want to move to the next record i cant do it and if I advance to next record FM shows me empty records , thats all in browse mode... Am i doing something wrong ? Sorry my english, i am not a native english.. thanks !

Hi, I have a database that I want to put on a CD and share with others. Is there a FMP viewer or something that I can put on the CD without putting the whole program on it? I don't know the correct terminology... packaging maybe? I can't find anything in the help under that term. Thanks,Kathy Maine Historical Society

Hello FM'ers - I've come across an obstacle, and I fear I just haven't gotten the right basic level of abstraction in my mind to tackle this. I have a list of records displayed in a standard layout, using a "find" criteria (e.g., all "active" issues). Now, each issue has an owner and a title. What I'm trying to do is to have a control of some sort in the header area of the layout where a user could select an item from a value list based menu to execute a "find" based on that value. For instance, when I first display my list, I see ALL the records by all owners (but just the "active" ones); then I go to my "control" in the header, select "Chris", and now I see a…

My invoice db contains thousands of records. Is there a way to search for non-consecutive invoices -- for example -- invoice nunbers 2222, 3333, 4444, 5555 -- without having to search for each invoice individually?

Who can help me with this? I want to have a script in a databasefile that will open another database and have only show records with the (company)name 'grafidruk'. Sounds simple(?), but I can't get it to work...

I have 2 databases... I need to be able to perform a find in one and perform that same find in another database as well in 1 step... I'm sure this might have to be scripted, but I'm totally in the dark on how to complete this. I'm doing this because 1 database has a set of fields and the other has a few of the same fields, but a totally different set fields of it's own.

Dear specialists, My database consists of 11 files. One of them is a kind of bulletin board, where people leave a messages to each others. One of the field is Attention field, with a View List (All users, Supervisor, and particular names). My aim is to show users only those messages which are meant for them (ex. John Black is able to see only messages to "All users" and "John Black"). What I did I set a respective privileges in Browse Records with limitation: Attention = "John Black" or Attention = "All Users". It works fine, however there are also other messages with a "not accessible" message on each field. Is there any way to avoid this - I mean to view…

I've got a big database spanning over several files, those files has different fields. All this is linked together via a menu system. But, how do I do a search function that finds the criterias in more than one file? If it was so that every field was unique, this would have been no match, but now, I've got some fields that is unique, and some that isn't. I want this search function to both contain a "multisearch" that seeks for the inputted criteria in every single field in every file, and a "normal" search function that let's you input one criteria per field. The matches should be displayed in a list and then the right one to be choosed of the user. If I …