Geek asks and answers

MS Access - identifier selection by selecting the associated name in the form

Problem

I am currently modifying the MS Access database, which will focus around the client ID, not the client name. However, all my forms are still based on the customer name. I need to change this based on the client ID, but I want it to still display as just the client name for users.

Structure

Before moving on, I must explain two relevant tables:

ClientTable:
- ClientID (PC)
- ClientName (indexed, no duplicates)

EntityTable:
- EntityName (CK, no duplicates)
- ClientID (CK allowed, duplicates)
- ClientName (the rest of my past structure, I suppose I won’t need it as soon as I remove this problem)

Key relationships: one client has many objects

There is also a good reason for my composite key (CK), but I will not explain it - my whole structure is much more complicated than shown above.

The form

Let's get back to the form. I currently have an Entity form that includes an EntityName text box and a ClientName drop-down box.

, , " " (.. , ), , , , .

, , . ?

+3
1

, Row Source :

SELECT ClientID, ClientName & SomeIdentifierForDups FROM ClientTable

...

Control source : ClientID  
Column count   : 2
Column widths  : 0; 2

ClientID .

+2

More articles:


All Articles