ibaxter

I am trying to do finds where field1 contains "x" and field2 does not contain the value "y" but I can't figure out how to make it work on FM5.5, Mac OS X. I can't use the omit function because I am doing multiple find requests and for other requests, it is okay if field 2 contains "y". Is it possible to do this in filemaker??

but the records that I am getting don't satisfy the specified criteria and they have parent records. I wasn't able to get this to work. I created the value list in B, but I dont' understand where to put that calculation. Is there another way to set this all up?

I guess I am not explaining this correctly (or not understanding correctly ) The relationship between the databases is one to one created on a uniqueID field within each database. I want to search through subset of records with UniqueIDs which are contained in both databases. I thought that using a field that is linked by a relationship would allow me to only search the records in common between the databases. Is this not the case? Let me spell out the situation in more detail than my last post.... I have 2 data bases: A which has 25k records each with a UniqueID. B which has 8K records each with a UniqueID 7K of the uniqueIDs are the same in each database. this is the set of records I want to search through. I want to be able to do many different finds, specifying different conditions, so I would rather not have to create a new relationship each time I want to pull out a different set of records. So I created a layout in A and put a calculated field from B (B:calcfield) into it. The relationship used is A:uniqueID to B:uniqueID Now if I go into database B directly and do a find in calcfield (>2) I get 240 records which all have a value >2 for calcfield. So far so good. If I then go into database A and go to the B:calcfield and do the same find (>2). I get 220 records, 200 of which have a value >2 for B:calcfield BUT 20 of which have a value <2 for B:calcfield. So it is returning records that don't match the criteria that I have specified. And this is my problem. I have checked that the relationship is indeed one-to-one. The spurious records don't share a uniqueID with the records that are getting pulled out. It isn't searching the current database, becasue the field that I have selected doesn't exist in the current (A) database Does this explain my problem better? thanks Ivan

I have a similar problem and I can't do the search in the related database. I have two datasets one (related) with 8000 records and one (master) with 25000. There are 7000 records shared between the two databases (with Unique IDs as the relationship). I want to search for records that are in both datasets and have a value in a calculated (in the related database) less than -2. I have made a layout in the master database that includes the fields of interest from the related database. When I go to that layout and do a find and put < -2 in the correct field. I get a subset of the records where the value is -2 (as expected). BUT I also get a few records where the value in the selected field is >-2 !! Can anyone tell me what I am doing wrong? Or a better way to do it? Ivan

worked brilliantly, thank you

I realize this is a very basic question, but I haven't been able to figure this out from the manual or the help program. I have a database of 24k records with 40 fields, one of which is a unique ID. I have a list of 100 unique IDs (in another database) and I want to pull out all the fields for those unique IDs and export them. I haven't been able to figure out an easy way to do this. Can anyone point me in the right direction? thanks