Select Table lookup and Auto fill in another field

[aron.ridgway]

Hi There, not sure if this is possible or not but i have a user permission table.
that consists of PermissionPK, UserFK, CompanyFK. I also want the username to be automatically filled in?

So when a user ID is filled in on the table, it also fills in what that UserID's Username should be?

As i need both the UserId and Username text for code that looks at the Environ username.

Any pointers?

thanks

 

[pr2-eugin]

That will be the structure it is now. You do not need the new column to store the user name. If you need this info, you JOIN the employee table with the user permission table to get the needed info.

 

[aron.ridgway]

Hi Paul thank you for your reply.

currently i only have the username in the userpermission table, so have no fk to link?

I can put in the userfk into the user permission table but every time you make an entry you are doubling your data input e.g(select username, select userfk)

Is there a way of selecting the username form a list box and it also inputs the id number in a field next to it?

thanks