autocomplete one field after filling one

hai Steve and all,
i want to autocomplete one field such as log book number after some one selects thecomputer serial number in my form.
ie when i select computer serial no. the log book no fields get automatically filled by the respective logbook no.
i have the table having logbook no and computer no. in my database .
thanks in advance
i want to autocomplete one field such as log book number after some one selects thecomputer serial number in my form.
ie when i select computer serial no. the log book no fields get automatically filled by the respective logbook no.
i have the table having logbook no and computer no. in my database .
thanks in advance