Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I select a record and immediatly assign it
- Thread starter ynnepztem
- Start date
Not sure from your description if this is exactly what you're trying to do, but I'll give it a shot.
I'm thinking that what you want to do is to make it so your users only see the records they created (like their sales leads for instance). To do this I would add a field to the table called CreatedBy and then when a record is created I would grab the userID of the creator and put it in this table. Then I would filter the records they see in their user interface by this field.
Go to SQL Books ONline and search for USER for several ways to get the user information.
I'm thinking that what you want to do is to make it so your users only see the records they created (like their sales leads for instance). To do this I would add a field to the table called CreatedBy and then when a record is created I would grab the userID of the creator and put it in this table. Then I would filter the records they see in their user interface by this field.
Go to SQL Books ONline and search for USER for several ways to get the user information.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question