Drop down list

[vaa571]

Hi,

I have a databse with a table Customers - field customerID and CompanyName;

On another table (MRB LOG TABLE) has the same fields (customerID) and
(CompanyName). I have a form with a subform (MRBlogsubform) and I would like
to use an lookup to update it. How can I do that, for instance, when i select
CustomerID from a drop down list or combo box, the CompanyName is
automaticaly updated or vice-versa, if i select the CompanyName then the
CustomerID field is filled?. I hope I explained enough, if not please let me
know.
Thank you very much.

Val

 

[Jeff Boyce]

It sounds like you are saying that you have two tables with the same
information. If so, how do you keep them "synchronized"?

It is quite rare to need to record the same data twice (in two separate
tables), and it will require that you add some customized programming to
ensure that the data stays synchronized (i.e, ensure data integrity).

Before you focus on "how" (using forms/subforms, etc.), consider reviewing
your table structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[vaa571]

Hi Jeff,

Thanks for the reply...

I am not recording the same infromation twice. On Customer Table I keep
information like CompanyName, Address,Phone, Contact informaton etc. and on
MRB log Table I keep the "issues" that i have with each customer. I
downloaded the "Issues database" from Microsoft site, made some modifications
and i am using it to keep track of my returns. Each return is related to a
costumer, reason why i need the customer name and number as part of the "MRB
log table". I could just type customer information for each return, but since
my customer base does not change i think it will be easier to select from a
drop down list or combo box. Let me know what you think. Thanks

 

[Douglas J. Steele]

You shouldn't require both the customer name and number in the MRB log
table. Customer number alone should be sufficient. You can join the tables
together when you need to see the name of the customer.

 

[John W. Vinson]

Each return is related to a
costumer, reason why i need the customer name and number as part of the "MRB
log table".

Well, actually, no you DON'T.

Relational databases use the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place". Your MRB Log Table needs
the customer ID, a link to the customers table - and that's ALL that it needs.
You can use a Query (or another tool such as a combo box) to *display* the
customer name as needed, without storing it redundantly.

If you're using the table datasheet to enter and view data... don't. That's
not its purpose; use a Form instead.