Jump to content
Sign in to follow this  

Maintaining found sets for flat files

Recommended Posts

My database consists of one file that's organized into several different record types (Customers, Orders, Products, etc.) There's one layout (used for viewing and modifying records) for for EACH record type . Finds are performed as the user navigates between layouts to ensure that they see the appropriate TYPE of records only. Example: When user goes to the Customers layout, his found set becomes all of the Customer records in the file. Other finds can done from within each layout to find more specific subsets of each record type. However, these found sets are not retained as user navigates between layouts.

Example: User goes to the Customers layout and finds only those customers who live in California. Then user goes to the Orders layout and finds only those order that were placed on 2/10/01. User then returns to Customers layout. But information about the previous found set of customers is gone (since the database made no effort to retain this info anywhere).

I'd like to be able to restore the previous found set of California customers when returning to the Customers layout in the above example. I'd like this behavior to be the same for all layouts for each record type. What's the best way to do this?

Should I just have a set of Globals for each record type that stores the find criteria that was last used on each layout? Then, everytime the user navigates to a layout, I could just perform a find based on these globals. Is this kosher? Is there a better way?

I'd also like to keep track of the last record that was viewed on each layout and return user to that record.

Note: I'm not interested in solutions that involve breaking my flat file up into a multi-file database structure, but I would like to discuss the pros and cons of flat file designs over "relational" with someone sometime.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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