I'm currently trying to make a form for a car maintenance database. I have a table for cars and a seperate table for users. I want to select the username in a form and this then to update the cars table with the User ID as found in the users table. On the form I then want it to show the first name and surname for the user involved, rather than user ID. Basically what is probably a masked value or something.

Does anyone know how this could be done?

Thanks,

Piggeh