Form questions ...please help

[Hotdog]

I have a table contains all the staff informations and a table contains the
vote records from the staff.I would like to ask how can i update the staff
name , position....etc from the vote records table when i enter the staff
ID??

For example, when i typed in staffID , staffname is shown and stored in vote
records table.How can i store the staff records from staff information table
into vote records table.

 

[Norman Yuan]

Not knowing how your form is designed, I cannot say much, but, one thing for
sure that staff information should never go into vote table except for
staffID, as foreign key (assume there is One to Many relationship between
staff tabel and vote table).