Jump to content
Sign in to follow this  
Rainy Pass

Save found set to a user table

Recommended Posts

Is there an effiecient way to preserve a found set to a user table? The solution has many users using one of two machines. The login scripts return the user to the last layout they used. How can I put them back in to the record state they where in when the logged out? The final solution will have many tables.

Share this post


Link to post
Share on other sites

You're going to need an accounts table with a record for each user. The records need to have a field for each table to store the record ids of the found set.

On solution close you need to script going through each table and getting the record ids of each record in the found set, then putting this list into the appropriate field in the user record. The List() function might be useful for this.

On file open, use the stored IDs to restore the found sets -- this can be easily done with relationships and GTRR.

Share this post


Link to post
Share on other sites

Thanks.

Can you dirrect me to any good references for using GTRR and the required relationships?

Will this method visibly slow the login process? I think returning the user to where they left off is very important to the interface yet, creating a delay at login in may discourge employees from loging in and out.

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.

Guest
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.