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

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
Sign in to follow this  

×

Important Information

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