More combo box help

[Joe]

I have posted here before with the same inquiry. However, none of the
suggestions seem to be working for me. I am sure it is because of how I
stated my request. Pleas indulge me as I try to state it again. I have a
table that is updated via a form based on the table. I have a combo box on
the form with the following columns: SupplierName, SupplierNumber with
matching column in the table. I am able to select the supplier name and have
the supplier number auto populate in the supplier # field on the form. The
problem I am experiencing is that only the supplier number is saved in the
table. I have tried changing the record source but only one field (Supplier
Name or Supplier Number) is saved in the table.

What am I doing incorrectly? Is there a solution that any one knows of?

Thanks again.

 

[Jeff Boyce]

Nothing. As in, "you are doing nothing wrong".

Your assumption is that both the ID and the SupplierName should be saved.
THAT's whats wrong.

Access is a relational database. If you already have the SupplierID, you
already have/can determine the SupplierName. There's no need to redundantly
store it in another table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Joe]

Thanks, Jeff. I am relieved! I will lay this subject to rest.

Have a good weekend!

Joe