Mark Stanton wrote: >> Yes I follow a more C/S apprach where your only getting the data your >> looking for instead of all of the data and pick what you need. >> > > Yes, but how do you go about that. > > To be more specific about an example, someone on the database may have > been making payments for several years, but the finance person only > needs to see this year. What does the "payments" view do? Have a > filter for this year? > > Hmmm, talking this "out loud" it's starting to sound like a daft question. >
Here's a screen from one of my applications: http://mbsoftwaresolutions.com/images/joblibrary.png The data in the grid is a parameterized view, using several "filter" variables from the choices above the grid. Here's the WHERE clause of my view that enables the "filtering" : http://mbsoftwaresolutions.com/images/joblibrary_whereclause.png -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
