mediacritical
Member
Hi Eugenio,
I have the following scenario:
TABLE "participants" with a lot of fields. One field is "employee" and it links to another table "employees" ("employee" contains the ID of the entry inside of "employees").
Another field in the table "participants" is address. My goal now is to get the address of the participant from the "employees"-table.
This should be done using the entry in the field "employee" of the "participants"-table.
But I don't want to create an individual VIEW for that. Is there another way to achieve this?
Thanks in advance!
Best wishes
Andreas
You are using DaDaBIK version 8.1-Lerici enterprise, installed on 11-12-2017 (installation code: 124685910a21b35192), the latest version of DaDaBIK is 8.2-Lerici released on 12-19-2017
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.0.25
mysql version: 5.7.20
Web server: Apache/2.4.29 (Unix) PHP/7.0.25
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:59.0) Gecko/20100101 Firefox/59.0
I have the following scenario:
TABLE "participants" with a lot of fields. One field is "employee" and it links to another table "employees" ("employee" contains the ID of the entry inside of "employees").
Another field in the table "participants" is address. My goal now is to get the address of the participant from the "employees"-table.
This should be done using the entry in the field "employee" of the "participants"-table.
But I don't want to create an individual VIEW for that. Is there another way to achieve this?
Thanks in advance!
Best wishes
Andreas
You are using DaDaBIK version 8.1-Lerici enterprise, installed on 11-12-2017 (installation code: 124685910a21b35192), the latest version of DaDaBIK is 8.2-Lerici released on 12-19-2017
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.0.25
mysql version: 5.7.20
Web server: Apache/2.4.29 (Unix) PHP/7.0.25
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:59.0) Gecko/20100101 Firefox/59.0