Form for table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Here's the problem:

Access 2003, XP Pro-

I have three tables that are related by primary keys. I have a
table[Table QC] that has the field [EmployeeID], the data type is
number--that field is linked to the autonumber primary key of the
Employees Table. So far so good. I am trying to make a form that has a
combo box that looks to the Employee Table to get me the drop down of
the employees (Last Name, First Name). The SQL statement builds out
okay, and I get the correct name config., but because the data type is
a number it won't accept the data. I looked at the Northwind example
and it is identical to what I am trying to do. I have the properties
set identically. In the Northwind example the names show in the field
Last Name, First Name, but the data type is set for number. I must be
missing something simple. Please help.

Thanks,

Sean

.

Relevant Pages

  • Re: Form for table
    ... I have three tables that are related by primary keys. ... the employees. ... In the Northwind example the names show in the field ... Last Name, First Name, but the data type is set for number. ...
    (microsoft.public.access.forms)
  • Re: Form for table
    ... number--that field is linked to the autonumber primary key of the ... the employees. ... In the Northwind example the names show in the field ... Last Name, First Name, but the data type is set for number. ...
    (microsoft.public.access.forms)
  • Little Lammy Cranston Is A Flaming Queer And Proven Liar - #4
    ... Super Sector: Total nonfarm ... Data Type: ALL EMPLOYEES, THOUSANDS ...
    (alt.politics)
  • Re: What are common indexes?
    ... Index on primary keys in all three tables. ... > SELECT e.last_name, e.first_name from employees e, departments d, ... > ALTER TABLE employee_addresses ADD FOREIGN KEY REFERENCES ... search for city,state then an index on city state would work. ...
    (comp.databases.oracle.server)
  • Lickin Ass and Fakin Names Is A Proven Liar - #107
    ... Super Sector: Total nonfarm ... Data Type: ALL EMPLOYEES, THOUSANDS ...
    (alt.politics)