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

Master-Detail Information in grid view

Posted by huggi 
Master-Detail Information in grid view
February 06, 2019 05:31AM
Hi,

i would like to be able to show the contents of a Master-Details relationship in the results grid of the Master.

The way the data is displayed could be controlled with expressions like "max", "sum", "group_concat" etc. as you would with a sql group by function.

Example:
-------------------------------------------------------------------------------------------------------------------------------
order_id customer_id Customer_name Article1
Article2
Article3
--------------------------------------------------------------------------------------------------------------------------------

Cheers,
Michael
Re: Master-Detail Information in grid view
February 06, 2019 05:35AM
Sorry, example should look like this:

-------------------------------------------------------------------------------------------------------------------------------
order_id........customer_id.......Customer_name........Article1
..................................................................................Article2
..................................................................................Article3
--------------------------------------------------------------------------------------------------------------------------------
Re: Master-Detail Information in grid view
February 06, 2019 09:35AM
Hi,
I don't understand what you mean exactly, can you provide more details/examples?

Best,

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

Click here to login