View Single Post
  #1  
Old February 10th, 2005, 07:01 PM
Shel
external usenet poster
 
Posts: n/a
Default Use same data for all records

Is there a way to do the following?

The scenario: The “Animals” database contains the “AnimalsInfo” table.
tblAnimalInfo contains the “AnimalType” field. User1 is always entering data
for Cats. User2 is always entering data for Dogs. User3 is always entering
data for Fish.

The question: What is the easiest way to automatically fill in the
“AnimalType” field based on which user is entering the record?

I really don’t want to use the built in security feature for this because
that entails setting up security and permissions for each user, which is not
necessary in this application.

--
Thanks in advance!
Shel