Smart Database

[jwallace]

I am creating a database for our employees. Let's say my table names are Personnel, Violations, Performance & Certifications. Within personnel, I have "Employee ID" (number), "First Name" & "Last Name". Violations, Performance & Certifications are linked to personnel via "Employee ID". I want to create forms for new entries for Violations, Performance & Certification NOT change current entries but add new ones. Those 3 forms will be accessed from completely separate areas of the database so I won't be selecting which form to choose from. In my mind, I want to click on a Button "Add new Violation" for example and then choose from an employee from a ListBox and have a subform appear with the correct information. Here's the kicker. I want the ListBox to have the employee's full names NOT their Employee ID. I've tried a couple of different methods, short of using VBA, to obtain those results and nothing has worked. Help!

[June7]

Review http://datapigtechnologies.com/flash...combobox3.html

Your combobox RowSource can be an SQL statement that concatenates the name parts.

SELECT EmployeeID, LastName & ", " & FirstName AS FullName FROM Employees;

Advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.

[knarfreppep]

Wouldn't it be preferred to make your operator interface Employee-centric?

So op first navigates to an Employee and uses buttons Violations, etc. which open the relevant form which then uses the Employee ID from the Employee form to populate its Employee ID field.