Action query....replacing a field

[kbrooks]

I have a basic table called ApplicationFunctions with 3 fields in it:
UserID
ApplicationID
FunctionID

I enter however many application/function combinations each user has access to, so there could be many records with the same UserID.

I want to be able to copy everything with a certain UserID and ApplicationID, and append it to the ApplicationFunction table only REPLACING THE ORIGINAL USER ID WITH ANOTHER USER ID. That way if several users have the same accesses, I don't need to enter 57 application/function combinations for each user.

Make sense? Thanks for any help you can give me.

 

[kbrooks]

Has anyone ever told you that you're absolutely amazing? I knew it was possible, but BOY this works slick! Thanks a lot!!!