Woodywoodpecker
New member
- Local time
- Today, 13:00
- 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.
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.