use combo boxes to create new record

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I am working to design a simple database that will allow
employees to be assigned a computer. I have a table with
all of the employees and a table with all of the
computers. The key for the employee table is the empid
and the key for the computer table is the compserial. The
computer table has the empid field in addition to all of
the computer specs. I want allow the user to pick an
employee and then look through the list of computers
available in order to match up the employee with the
correct computer.

Any ideas?
 
-----Original Message-----
I am working to design a simple database that will allow
employees to be assigned a computer. I have a table with
all of the employees and a table with all of the
computers. The key for the employee table is the empid
and the key for the computer table is the compserial. The
computer table has the empid field in addition to all of
the computer specs. I want allow the user to pick an
employee and then look through the list of computers
available in order to match up the employee with the
correct computer.

Any ideas?
.
Click to expand...
Hi Kate,

consider having another table to store details of employee
computers. At very least this table will have 2 fields:
empid
compserial

Set up a form and use the combobox wizard to have each
combobox lookup the appropriate table and store the id
field for that table.

For example, the combobox for the empid of the new table
will lookup the employee table, show employee name and
store the empid field.

Luck
Jonathan
 
Back
Top