Hello all,
I wish to use dadabik for my mysql server front end, however, in the database I have setup I have the current database structure:
Mail list (which contains all people we mail to)
Adoptions (some people adopt cats)
Cats (cats those people have adopted)
The mail list table has a foreign key in adoptions to link the adoptions and the Mail list
The Cats table has a foreign key in the Adoptions Table to link cats to their adoption numbers (a unique number)
What I am trying to do is show the cats and their adoption numbers on the master/detail section of a person on the mail list. However, the master/detail only goes one level deep so I can only show the adoption number but I cannot display the cat associated as the link between the mail list and the cats table is through the adoption table.
I would also want to be able to add a field to the cats table and the adoption table in one create because as of now when I want to add data for an adoption and a cat I have to go to each table and enter in the data individually.
Suggestions Appreciated!
Enviroment:
PHP Version: 7.1.11-1+ubuntu16.04.1+deb.sury.org+1
mysql version: 5.7.20-0ubuntu0.16.04.1
Web server: Apache/2.4.18 (Ubuntu)
I wish to use dadabik for my mysql server front end, however, in the database I have setup I have the current database structure:
Mail list (which contains all people we mail to)
Adoptions (some people adopt cats)
Cats (cats those people have adopted)
The mail list table has a foreign key in adoptions to link the adoptions and the Mail list
The Cats table has a foreign key in the Adoptions Table to link cats to their adoption numbers (a unique number)
What I am trying to do is show the cats and their adoption numbers on the master/detail section of a person on the mail list. However, the master/detail only goes one level deep so I can only show the adoption number but I cannot display the cat associated as the link between the mail list and the cats table is through the adoption table.
I would also want to be able to add a field to the cats table and the adoption table in one create because as of now when I want to add data for an adoption and a cat I have to go to each table and enter in the data individually.
Suggestions Appreciated!
Enviroment:
PHP Version: 7.1.11-1+ubuntu16.04.1+deb.sury.org+1
mysql version: 5.7.20-0ubuntu0.16.04.1
Web server: Apache/2.4.18 (Ubuntu)