DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

3 tables master/view

Posted by drashrafsabry 
3 tables master/view
March 19, 2019 05:11AM
Table General has Field1 ID , Field2 Name , Field3 Phone

Table Visit has Field1 id_visits, Field2 ID , Field3 Notes

Table Requests has Field1 id_requests , Field2 id_visits , Field3 RequestSummary


Table general has table visit in Master/View where in form configurator i choose ID then added table visit and the primary key is ID
when i open table visit in master/view mode i choose ID field to show ID , Name

Now the question is , i want to add table Requests under visits , and i linked them ,
i want a way to display NAME from General table in requests table
Re: 3 tables master/view
March 21, 2019 09:16AM
Hello,
if the idea is to add two nested levels of master details, this doesn't work, see the DaDaBIK known bugs and limitations

https://dadabik.com/index.php?function=show_documentation#bugs

"Nested Master/Details views (a master/details view on a table which is already in a master/details view as details table) don't work correctly."

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Sorry, only registered users may post in this forum.

Click here to login