hmmm something interesting has happened when I added the Autonumber to every table.

Vendor Table
MFGID-PK
Company name
Etc

Parts Table
PartsID-PK
MFGID-FK
etc

When I enterd the parts in I did so through the subtable in the Vendor Table.

Now when I go to Parts it is showing the Autonumber associated with the MFG Table rather than populating the Company Name.

I looked at the properties and they seem fine.

Is there something I am Missing?

Yes, you need to go to table design view, and then click on the look up tab for that field, and add the field you want to be displayed to the query. Then set the column count to the new number of fields, set the bound column to 1 (if that is the PK) and then set the column widths to display the proper widths for each field.

So if you have to columns in your look up, and the first field is the PK, so this:

Select the pk field, and the meaningful field in the query designer, then sort ascending on the meaningful field.

Column Count: 2
Bound Column: 1
Column Widths: 0";2"

Did that help? This is only a problem because you modified the tables after you established the look ups.

mmcdonal

Awesome! You really know your stuff, Thanks alot =) It worked now all I need to to is go through all the tables and do it.