Solved Form with 2 controls calling the same table for different purposes (1 Viewer)

Woodywoodpecker

New member
Local time
Today, 13:03
Joined
Oct 23, 2020
Messages
6
Hello Everybody,

I am facing a small problem that I am sure is pretty forward to solve, but I obviously missed something somewhere ... maybe in my concept ...

In my attached basic test database to illustrate the question, I have :

* 1 table for companies
* 1 table for projects
* Projects have supplier from the table companies but also client from the same companies table.

In my projectForm, I would like to have in my projectTitle textbox "the project & the supplier name & the client name"

what I get for the moment is "the project & the supplier ID & the client ID" which is somehow logic.

How could I get the names in the title instead of the ID ?

Sounds pretty basic but there must be a mismatch somewhere with 1 table linked 2 times to the other table for different purposes.

Many thanks in advance for your help.
 

Attachments

  • Test_project_supplier_ver0.accdb
    576 KB · Views: 34

Gasman

Enthusiastic Amateur
Local time
Today, 12:03
Joined
Sep 21, 2011
Messages
8,337
Use the correct column from the combos, not just the bound field.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:03
Joined
Oct 29, 2018
Messages
15,268
As @Gasman said, try it this way:
Code:
=[projectName] & " - " & [projectSupplier].[column](1) & " - " & [projectClient].[column](1)
 

Users who are viewing this thread

Top Bottom