Primary Key Problems

[skg]

I have created a database using autonumber fields for the primary key. For example I have a Vendor table with an ID field and a Vendor Name Field.



When I link the vendor table to, let's say, an Invoice table I link the primary key, but set the Vendor Name field to be displayed.

The problem is that when I run reports, queries, and export, the primary key is displayed instead of the Vendor name. Is there a fix for this?

Thanks in advance.

[ajetrumpet]

yes there is, but with this little information it's impossible to analyze it and give you anything to work with.

got anything else, like details perhaps? the only thing to really infer here is that it's a problem with a multi-column control somewhere.

[skg]

I am creating a purchase order database. I created the following tables.
tblPOData
tblVendor

tblVendor's Primary Key is VendorID(autonumber field)
tblPOData has a VendorName field. I used the lookup wizard in table design to link tblVendor to tblPOData. When it asked which value I wanted to store I selected VendorName so that VendorName would appear in the table or on forms instead of VendorID.

The problem is that when I run a query or report the value that displays is VendorID not VendorName.

[ajetrumpet]

I used the lookup wizard in table design to link tblVendor to tblPOData.

most likely, that's the problem. I'd change it right now, before the complexity grows. drop that, and link the two on vendor ID, which is the correct way to do it anyway.

When it asked which value I wanted to store I selected VendorName so that VendorName would appear in the table or on forms instead of VendorID.

See....right there is a perfect example of how these wizards can simplify your life but not offer disclosures to you as how they work their magic.

The problem is that when I run a query or report the value that displays is VendorID not VendorName.

what's the basis for your report? statement? query? whatever it is, please post it in a code window for us. that'll tell more than words.

[skg]

I am not sure how to post the code for this query.

I want to run a report that displays only approved and proposed projects. So two tables are involved
tblProjects (Child field ProjectStatus)
tblProjectStatus (Primary Key field StatusID)

The StatusID field is an autonumber.

When I run the report it displays the StatusID instead of the ProjectStatus

If this information is not enough please explain how to post the code for this query.

Thanks

[skg]

I managed to solve this problem by setting up the query correctly.

I was using the field ProjectStatus from tblProjects in my query which naturally has the StatusID field stored in it.

Instead I used the field ProjectStatus from tblProjectStatus.