Confusion about Master/Detail view

FRW

Well-known member
Within a test-app I have:

a table called "Bewirtschafter" with a lookup table called "Kassen". It seems that the ID from the table "Bewirtschafter" ist used to show the detail view of the table "Kassen" and not the ID from "Kassen" as it is selected in the admin area.

Table Bewirtschafter:
Bewirtschafter

Table Kassen:
Kassen

Admin:
Admin 1
Admin 2

About:
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
 

eugenio

Administrator
Staff member
Hello,
I am not sure, from your screenshot, if you set the master details correctly.

Let's say you have a master / details view between sales and sales_items:

sales (id_sale, date_sale, ....)
sales_items (id_sale_item, id_sale, product_sale_item, ...)

you have to set, for the primary key of the sales tab (id_sale) the master details section saying, in this case:
items table name: sales_items
fk field name: id_sale

is this what you did?

Best,
 

FRW

Well-known member
I have a table "Bewirtschafter (idBewirtschafter, bewnr, kassen_idKasse (as FK))"
Second table "kassen (idKasse, namekasse, nummerkasse, strasse)"

Within forms configurator I choose table "Bewirtschafter" field "kassen_idKasse"
Lookup tabvle name: "kassen"
Lookup table primary key field: "idKasse"
Lookup table linked fields: "namekasse" (this is show correctly)

master/details view:
Items table name: "kassen"
Items table foreign key field name: "idKasse" (here it shows only the data with the same id as idBewirtschafter...)
 

FRW

Well-known member
Weird, I have to think the other way round...

in master/detail view I have to choose:

table name: "Bewirtschafter"
foreign key field: "idBewirtschfter"

and now, it's show as I suspect...

Thank you!
 
Top