How can I create a field in a table that's multiple choice?

[teknic111]

I am creating an employee database for a client. The employee table has a performance column for each employee, and my client wants to be able to choose from four performance codes – Excellent, Good, Average, and Poor. They want to choose these descriptions instead of typing them in each time. How can I make this happen?

Thanks in advance!

[orange]

Consider 3 tables

Employee (EmployeeID,EmpName,EmpDateOfBirth,EmpHireDate,...other Emp specific fields)

PerformanceLookup(PerfId,PerfName)

EmployeePerformance( EmpPerfID,EmployeeID_Fk,PerfId_Fk, PerfDate) <--green indicates these should be a Unique compound INdex)

You should research Normalization and you should read
http://forums.aspfree.com/attachment...2&d=1201055452

Good luck with your project

[Bob Fitz]

Create a table for perfomance called tblPerfomance With 2 fields. Name one of them PerfomanceID with Field Type AutoNumber. Name the other field Perfomance with Field Type Text.
Create four records (Excellent, Good, Average, Poor).
Create a new field in the Employee table called PerfomanceID with Field Type Number.
Create a form bound to the Employee table. On this form, use the wizard to create a combo box based on the table tblPerfomance. Set the Control Source property of the combo box to PerfomanceID.

[orange]

Bob,
Are you suggesting an Employee only has 1 Performance Ranking? "The company" doesn't do performance reviews/appraisals of staff at different times?
No history of an Employees performance with time?

I mean, it's possible, but not too realistic.

[Bob Fitz]

Orange,

You are, of course, quite right. I just didn't give the OP's question as much thought as I should have.

[orange]

It's hard to say what the OP was expecting -- but apparently he/she has a client.

[Bob Fitz]

It's hard to say what the OP was expecting -- but apparently he/she has a client.

Yes, apparently so. I wish both of them well with their project.

[alansidman]

Why not put an options control on the input form with radio buttons that gives the user a choice and the result will then be input to the table.

Alan