Selecting Specific Records In A Multiuser Database

There is two approaches I often use:
>
>
1) add two fields MailSelect + UserName
>
so, when user clicks on the MailSelect field, you automatic place the
current logged on users name into the Username field.
>
>
2) You create a table that is local to your front end, and simply insert
the ID's into that local table.
>
Then, to select, you go
>
select * from tblcustomers where ID in (select id from myLocalSelectTable)
>
Note that these "where" clauses that are sub-selects even work as a
"where" clause for reprots.
>
Approach #2 might not work if you need others to be able to print, or use
that list you made from different workstations.
>
You can get the current network logon name with:
>
http://www.mvps.org/access/api/api0008.htm
>
And, the current computer name with:
>
http://www.mvps.org/access/api/api0009.htm
>
And, if using ms-access security, then currentuser() will return the
ms-access logon.
>
I often log all 3 of the above values in some applications.
>
>
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
>
>

Thanks for responding, Albert!

In approach#1, if another user clicks on the MailSelect field of a customer
you selected while you are making your selections, you lose your selected
customer. That's what my question is about!