Problem with relationship

FRW

Well-known member
You are using DaDaBIK version 8.3-Lerici enterprise, installed on 04-25-2018

PHP Version: 7.0.7
mysql version: 5.5.5-10.0.34-MariaDB
Web server: Apache 2.4

Client: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.119 Safari/537.36



I have 3 tables: A, B and C, relationship A to B and B to C

Fields to configurate from table A. Now I have a field f.e.: "customer" with a lookup table to table B (f.e. "address"), that works fine. Now I want to show the depending entries from table C (f.e. "country") to B while select the entries from table B.

At the moment it will only show the corresponding ID (f.e.: "1") and not other linked fields (f.e.: "Germany") as it would be possible from A to B.

Cascading field isn't the solution I think, becaus I only want to show the corresponding entries and don't want to do a selection.
 

eugenio

Administrator
Staff member
Hello,
the typical solution in these cases is the creation of a view D (B join C) and the use of the view D as a source of the lookup field in A.

Best,
 
Top