Finding records.  Broken???

Posted on 2006-05-13
Last Modified: 2010-04-27
I have two tables.

One is the main table and the other is a relation ship to another table containing systems.

There are two fields of interest in the systems table "System" and "Type"

There is a value list built from all the Systems where you can selects one of those systems from the systems field in the main table.

You could also bypass the list and type in your own if it isn't in the list.

I put the "Type" field in the main layout for autopopulation and there are four types.. lets say A,B,C,and D (but if its a custom entry, nothing with be displayed)

The thing thats causing a big problem and I dont know if it just started or not.  But I cant pull a find of all As,Bs, and Ds but Cs will work.

All the types show up at least 10 times in the main table so the entrys are there.  But why isn't it finding anything?!?  This is gonna really screw me up. =(
Question by:Cruizectrl
    LVL 28

    Accepted Solution

    weird, probably a silly error, the kind you see 10 times without noticing it, like a trailing space in the type field
    do we have a chance to look at the file? because I think it is a simple design mistake.
    LVL 1

    Author Comment

    Your right lesouef,  I was hitting myself after this.

    The related systems field which I have the relationship with in the main layout was set for "number".  Everything appeared normal in relationship, list, and the linked field which I was trying to perform the search in.  The strange thing is,  I was able to to find, for example, CT and not MR.

    LVL 28

    Expert Comment

    yes, but the logic is tricky (I don't know if this is till true with fm8), it uses the ascii codes of characters in this case, so it may work in some situations, though the result is of course unexpected...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    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…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now