Hi folks,
how can I add a new table with geographical and some more standard information related to existing/new link resources? I mean not to simple add a new table in an existing database ;-) I mean the build of a relation to the "Links"-Table.
I know, I can add a few more fields in the "Links"-table but in fact of redundancy, I try to find a solution with a new table... like "Links_geo_and_more_info".
The next problem is: Can I sort the links with a field of the related table? Can I force the internal search engine to find links depending on fields of the "Links_geo_and_more_info"-table? Does a simple template-modification (for example in add.html, link.html...) with the entry of the new fields still working? How to index and set up the relation between the new "Links_geo_and_more_info"-table and "Links"-table?
I know, a lot of questions, but I think a solution can be a concept-solution or a part of a FAQ for many other ideas.
kind regards
Vavilis
how can I add a new table with geographical and some more standard information related to existing/new link resources? I mean not to simple add a new table in an existing database ;-) I mean the build of a relation to the "Links"-Table.
I know, I can add a few more fields in the "Links"-table but in fact of redundancy, I try to find a solution with a new table... like "Links_geo_and_more_info".
The next problem is: Can I sort the links with a field of the related table? Can I force the internal search engine to find links depending on fields of the "Links_geo_and_more_info"-table? Does a simple template-modification (for example in add.html, link.html...) with the entry of the new fields still working? How to index and set up the relation between the new "Links_geo_and_more_info"-table and "Links"-table?
I know, a lot of questions, but I think a solution can be a concept-solution or a part of a FAQ for many other ideas.
kind regards
Vavilis