More combo box help


J

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.
 
Ad

Advertisements

J

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
 
Ad

Advertisements

J

Joe

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

Have a good weekend!

Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top