[Last Call] Learn how to a build a cloud-first strategyRegister Now


I can't seem to figure out how to gather a found set of the records I need displayed...???

Posted on 2007-08-06
Medium Priority
Last Modified: 2013-11-05
I have a table called Auctions that has both an ItemNumber and a ScanID in it.  ScanID's are unique to ItemNumber's, so if I have 10 auction records with the ScanID 12345 they should all have the same ItemNumber.

Somehow I've gotten lots of auction records that are getting incorrect ScanID's.  I need to figure out how, but right now I simply need a way to find all of the problem records.  

I can put a ! in the ScanID in Auctions to get a found set of records with duplicate ScanID's, however, I don't know what to do from there in order to filter so that I only see records with duplicate ScanID's but different ItemNumber's.  

Any information would be greatly appreciated.  Thanks!
Question by:Andrew Angell
  • 2
LVL 28

Accepted Solution

lesouef earned 2000 total points
ID: 19641137
maybe you could create an extra temp field showing if scanID=Itemnumber. this way you would see the guilty ones once you've got the right found set, and restrict the found set to these.
LVL 11

Author Comment

by:Andrew Angell
ID: 19663163
I wound up creating a calc. field in Auctions that allows me to more easily find the problems.  The calc. I created is:

If (
ScanID ` "" ;
If ( Item_Number = AuctionsToScansByScanID::ItemNumber ; 1 ; 0 ) ;

I just store it as text.  Not all items have ScanID's because they didn't get introduced until just a few months ago.

So then I search on this to show me only items with invalid scan id's.  That helps a lot.  The problem now is yet another stupid thing with our system.  This ScanID field, before we started using it for our own ScanID, was being used to store an item ID from another company we were working with.  Many auction records with ScanID's are actually this other company's ID, not ours.  They're easy to spot because theirs have a few more digits than ours.

Is there a way I can do a find displays only records where this field is less than 8 characters, for instance?
LVL 11

Author Comment

by:Andrew Angell
ID: 19663493
Also, on this same situation, how can I add validation to the ScanID field?  Now that I have the calc. that shows whether it's valid or not it seems like it should be easy to add validation to popup a message alerting with the ScanID is not valid and won't accept it.  I'm confused over the validation calc. dialog for some reason.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question