combo box incorrectly looking up the primary key records

[Guest]

We have created a table which has relationships and a primary key, we have
then made a form from this to enter our data into. Our records have been
entered into the subform and in form view they appear to be correct. We
wanted to create a query from this data, however when doing so we noticed
that the info that was now in the table was incorrect as to what had been
entered in the form ie. our site name column was filled with the serial
number data (the serial number being the primary key) We cannot change the
primary key because of the relationships that it is involved in.

To us the problem appears to be that the combo box is looking up info in the
primary key field rather then the specified field in the table, however when
in the form the combo box shows the correct info.

Urgent help is needed before we can continue.

I hope someone can make some sense of all this and help me. Thanks

 

[Brian Bastl]

Leahw,

Actually, it sounds as though you're storing your FKs correctly. What you
need to do is use a query instead of the table as the record source for your
report. Then you can join the appropriate tables to display the FK's
corresponding text field.

HTH,
Brian