Jump to content

Holy Search Batman!


Moon
 Share

This topic is 7472 days old. Please don't post here. Open a new topic instead.

Recommended Posts

FileMaker made it easy, but you are making it too hard.

Do the first find request, entering name AND date criteria. Don't use separate requests for name and date, as that results in a found set containing all records with the same name, and all records with the same date criteria. Such a search is a boolean OR search, which you don't want.

The find step for the the incompletes is only missing one thing: click the OMIT box.

As to your request for good reading material on this, permit me to use an old Air Force term: RTFM (Read the f*cking manual). It really spells out how to do finds in FileMaker very well.

In my experience, finding and sorting are worth a full day class for those who don't read the manual. And worth it, as it is the bread and butter of reports.

Link to comment
Share on other sites

I have never seen anything so complicated. Reports for FileMaker are strange. All I need to do is create a button (got that part)that when the user clicks it, he/she can choose a name, select a date range and it returns a report/layout. Here is what I have:

Find Mode [Pause}

Go to Field [Name]

New Record/Request

Go to Field ["date"]

New Record/Request

Go to Field ["date_completed"]

Insert Text [select, "="]

Here is where I need to somehow Omit records that are not completed.

Perform Find[]

Can FileMaker5 handle more than 2 pieces of criteria during a search b/c I cannot even do it manually: Can omitting records be automated and can anyone recommend a good book for FileMaker5. I have lost my patience with FileMaker. I learned SQL and ASP together faster than FileMaker. Until then, it is back to the Bat cave to decipher some more FileMaker. mad.gif" border="0

Link to comment
Share on other sites

This topic is 7472 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.