autopopulate field in a table based on value entered

[Guest]

I want users to enter client ID in the Client ID field. I want Client Name
to populate automatically based on the value entered in Client ID field.
Client IDs and Client Names are stored in a separate table. How do I
accomplish this?

 

[Van T. Dinh]

It sounds to me that you are storing redundant data ... Suggest you check
the Table Structure since if you have the ClientID, you can find the Client
Name from the Table Clients so there is no needs to store both ClientID and
Client Name in the Table your are trying to add data to.

 

[Guest]

I want user to input client ID and client name to appear so the user will
know that he or she inserted the correct client ID. Client id and names are
stored in a table in a different database. This table is linked to the
current database I'm creating.

 

[Van T. Dinh]

I assume you use a Form for data entry into this Table???

If this is the case, you can simply use a ComboBox to show ClientName for
selection by the user but in the Table, store the corresponding ClientID.
This way, from the stored ClientID (as the ForeignKey), you can retrieve the
ClientName as well as other Client attributes from the Client Table.

Check Access Help on ComboBoxes.