Search with Except

[Iris]

I'm quite a newbee with FMPro and I can't seem to resolve this problem:

I have two databases. Both contain a field with numbers. Now I want to perform a search in the first db that should result in giving me all the records that don't have a match on 'number' in any record from the second database.

Could any1 help me out?

[jasonwood]

Why can't you just perform the find (as an omit) directly in the second database?

[Lee Smith]

Hi Iris,

Welcome to the lists and FileMaker.

[color:"blue"] > I'm quite a newbee with FMPro and I can't seem to resolve this problem:

> I have two databases. Both contain a field with numbers. Now I want to perform

> a search in the first db that should result in giving me all the records that

> don't have a match on 'number' in any record from the second database.

As Jason pointed out, it could be as simple as doing a search and omitting those records found.

However, I read your inquire a little different. It sounds like you are wanting to compare and select those records that are the same in both databases, then omit the matching ones, and then probably import the unmatched ones into database one.

If so, maybe some additional information needs to be given for us to help you. Such as, what type of fields are these numbers in (text or number)? Is this a serial number (consecutive)? How can you identify the the matches from the unmatched? Were these numbers created within FileMaker auto entry? Are they a simple, either or, such as 1 or 2 (X Marked) ? Are there other characteristic that will help you identify them as unique or the same?

Lee