torifile Posted August 12, 2004 Posted August 12, 2004 This may have been answered previously but I'm still new to FM and I'm not sure exactly how I need to word my search... I've got a database with things like appointment times, gender, treatment phase, etc. Let's say I want to run a query for all women who have appointments within the next 2 weeks. I've designed an interface for the find, but I want to format the found results to say: ________ Found xx records with your criteria Jane Doe Janis Joplin ... ________ Anyone have an idea how I can do this?
TSC Posted August 12, 2004 Posted August 12, 2004 Get(FoundCount). To display, you can create a calculation field, unstored. Then found <<field>> records with your criteria.
torifile Posted August 12, 2004 Author Posted August 12, 2004 That sounds easy enough, but where do I put that? Is it a script? (Like I said, I'm still new at this)
torifile Posted August 12, 2004 Author Posted August 12, 2004 Nevermind. I figured it out. Is it best to put it in any particular table or does it matter?
-Queue- Posted August 12, 2004 Posted August 12, 2004 It is table-dependent. You'll need a calculation for it in every table that you want to display the found count dynamically.
Recommended Posts
This topic is 7477 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 accountSign in
Already have an account? Sign in here.
Sign In Now