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.

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.

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.

How do I issolate and save the id of the current record the user is on?