IMPORTANT Please notice that tab Manage Table Options is no longer available. Table Options was renamed to Project Templates and can now be accessed directly from the plugin menu.
I am wanting 3 tables, Table A the parent of Table B and Table B the parent of Table C. It looks like I cant just have a relationship (1:n) on Table A ==> Table B and Table B ==> Table C. This only gives me access to Table A and B.
I tried adding a relationship Table A ==> Table C, and that gives me access to tabs for Table B and Table C but it wont let you link Table B to Table C.
What am I doing wrong. I have only one template for each table.
The plugin supports only one hierarchy level on a page. If you want to manage multiple levels on one page, you can use dynamic hyperlinks to jump between different levels. Multi level supports is planned for Data Forms (not yet available). Not for the back-end and shortcode wpdadiehard.
When I attempt to “Add New” child row in a many to many relationship, I get an insert error.
The child row is created but the links between the two tables are not.
Add existing does not get an error.
See the PHP log entry below:
family ==> member ==> details
Table family has the parent record
Table details has the child record
the row fails to insert into table member
The database is named directory…. not wp_testsite_db
[02-Apr-2022 03:55:51 UTC] WordPress database error Table ‘wp_testsite_db.member’ doesn’t exist for query
SHOW FULL COLUMNS FROM `member`
made by do_action(‘directory_page_wpda_wpdp_1_1’), WP_Hook->do_action, WP_Hook->apply_filters, WPDataProjects\WPDP->manage_project_page, WPDataProjects\Parent_Child\WPDP_Parent_List_View->show, WPDataProjects\Parent_Child\WPDP_Parent_List_View-
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok
I’m close, but when I test the table I can delete items from the class table, but I cannot add.
ERROR: Not all rows have been added
Hi Zack,
Can you send me some screenshots? Please use the contactform if you prefer to send them in private.
Thanks,
Peter
I am also getting this same error, was there a solution to it?
Can you send me your table options the related tables Jeffrey? Please use the contactform to send it in private.
Thanks,
Peter
I am wanting 3 tables, Table A the parent of Table B and Table B the parent of Table C. It looks like I cant just have a relationship (1:n) on Table A ==> Table B and Table B ==> Table C. This only gives me access to Table A and B.
I tried adding a relationship Table A ==> Table C, and that gives me access to tabs for Table B and Table C but it wont let you link Table B to Table C.
What am I doing wrong. I have only one template for each table.
Hi Carl,
The plugin supports only one hierarchy level on a page. If you want to manage multiple levels on one page, you can use dynamic hyperlinks to jump between different levels. Multi level supports is planned for Data Forms (not yet available). Not for the back-end and shortcode wpdadiehard.
Does this answer your question?
Peter
When I attempt to “Add New” child row in a many to many relationship, I get an insert error.
The child row is created but the links between the two tables are not.
Add existing does not get an error.
See the PHP log entry below:
family ==> member ==> details
Table family has the parent record
Table details has the child record
the row fails to insert into table member
The database is named directory…. not wp_testsite_db
[02-Apr-2022 03:55:51 UTC] WordPress database error Table ‘wp_testsite_db.member’ doesn’t exist for query
SHOW FULL COLUMNS FROM `member`
made by do_action(‘directory_page_wpda_wpdp_1_1’), WP_Hook->do_action, WP_Hook->apply_filters, WPDataProjects\WPDP->manage_project_page, WPDataProjects\Parent_Child\WPDP_Parent_List_View->show, WPDataProjects\Parent_Child\WPDP_Parent_List_View-
How can I fix this?