What is the depth capabilities of the relational capabilities between tables? Can portals be inserted in screen layout of single record, such as paid dues records? I have seen one presentation on foreign keys. Are there any other?
You can take a look at this page from our documentation to see all capabilities of foreign key feature. Also you can can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features. There you can create your own relation table to see does it fits your needs.
Thanks for the response. I have been using Filemaker for my database and am trying to determine how much I have to adjust with wpDataTables. An additional question also came to mind. What would be the procedure for loading into the table additional records of 100 to 500 at a time?
Not to muddy the water I will leave Filemaker out of the discussion.
Our 501c organization maintains a list of Jewish burials in the state of Texas. We currently have over 43000 entries with 10 fields. After this file is installed as a table there are periodic addendums (2-3 times a year). Can this addendum be updated to the existing table? Or does the table need to be recreated from scratch? Another way, perhaps, of looking at this, can the addendum be merged into the existing table? Obviously, same format, etc. We seem to adding approximately 500 additional records per year.
While I have you on the line, so to speak, while related tables via foreign keys, can be created, I also maintain an ongoing payment record of dues paid by members. This is currently be processed through Filemaker. (Sorry to mention it.) I have created a portal so that the payment record displays the individual member form; this is where I enter payment information displaying: date of entry, year for which the payment is credited to, and the amount of the dues donation. Can one table (with specified fields) be displayed inside another table?
"Can this addendum be updated to the existing table? Or does the table need to be recreated from scratch? Another way, perhaps, of looking at this, can the addendum be merged into the existing table? Obviously, same format, etc. We seem to adding approximately 500 additional records per year."
- If you are going to create a table from your excel file that will not be server-side table, then it could be possible just to replace the old file with the new one. But because you have 43000 and more entries table without server-side will not work. Unfortunately when you are using server-side it is not possible to add more entries by merging old file with the new one (we have plans to add this feature in one of the future releases). For now it could be maybe possible only from phpMyAdmin or any other database management software.
"While I have you on the line, so to speak, while related tables via foreign keys, can be created, I also maintain an ongoing payment record of dues paid by members. This is currently be processed through Filemaker. (Sorry to mention it.) I have created a portal so that the payment record displays the individual member form; this is where I enter payment information displaying: date of entry, year for which the payment is credited to, and the amount of the dues donation. Can one table (with specified fields) be displayed inside another table?"
- Unfortunately I didn't quite understood this case and question. You can preview data from one wpDataTable to the another wpDataTable using foreign key feature. That means that if you want to show e.g. total payment from wpDataTable 1 into wpDataTable 2, you have to have relation column (with ID's) in wpDataTable 2 (that will represent ID's of wpDataTable 1). You can read more about foreign key feature at this post from our documentation.
What is the depth capabilities of the relational capabilities between tables? Can portals be inserted in screen layout of single record, such as paid dues records? I have seen one presentation on foreign keys. Are there any other?
Hi Marc,
Thank you for the inquiry.
You can take a look at this page from our documentation to see all capabilities of foreign key feature. Also you can can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features. There you can create your own relation table to see does it fits your needs.
Thanks for the response. I have been using Filemaker for my database and am trying to determine how much I have to adjust with wpDataTables. An additional question also came to mind. What would be the procedure for loading into the table additional records of 100 to 500 at a time?
Hi Marc,
I am not sure that I have understood your question. Can you please describe it in more details?
Not to muddy the water I will leave Filemaker out of the discussion.
Our 501c organization maintains a list of Jewish burials in the state of Texas. We currently have over 43000 entries with 10 fields. After this file is installed as a table there are periodic addendums (2-3 times a year). Can this addendum be updated to the existing table? Or does the table need to be recreated from scratch? Another way, perhaps, of looking at this, can the addendum be merged into the existing table? Obviously, same format, etc. We seem to adding approximately 500 additional records per year.
While I have you on the line, so to speak, while related tables via foreign keys, can be created, I also maintain an ongoing payment record of dues paid by members. This is currently be processed through Filemaker. (Sorry to mention it.) I have created a portal so that the payment record displays the individual member form; this is where I enter payment information displaying: date of entry, year for which the payment is credited to, and the amount of the dues donation. Can one table (with specified fields) be displayed inside another table?
Thanks.
Hi Marc,
"Can this addendum be updated to the existing table? Or does the table need to be recreated from scratch? Another way, perhaps, of looking at this, can the addendum be merged into the existing table? Obviously, same format, etc. We seem to adding approximately 500 additional records per year."
- If you are going to create a table from your excel file that will not be server-side table, then it could be possible just to replace the old file with the new one. But because you have 43000 and more entries table without server-side will not work. Unfortunately when you are using server-side it is not possible to add more entries by merging old file with the new one (we have plans to add this feature in one of the future releases). For now it could be maybe possible only from phpMyAdmin or any other database management software.
"While I have you on the line, so to speak, while related tables via foreign keys, can be created, I also maintain an ongoing payment record of dues paid by members. This is currently be processed through Filemaker. (Sorry to mention it.) I have created a portal so that the payment record displays the individual member form; this is where I enter payment information displaying: date of entry, year for which the payment is credited to, and the amount of the dues donation. Can one table (with specified fields) be displayed inside another table?"
- Unfortunately I didn't quite understood this case and question. You can preview data from one wpDataTable to the another wpDataTable using foreign key feature. That means that if you want to show e.g. total payment from wpDataTable 1 into wpDataTable 2, you have to have relation column (with ID's) in wpDataTable 2 (that will represent ID's of wpDataTable 1). You can read more about foreign key feature at this post from our documentation.