Hi,
You can use <%Dbsql::Relation::HTML::generate_description('primary_table', 'foreign_key', 'description_field')%> in your template to get the description of foreign key.
E.g: The Book table is related to Category table on CatID which is the foreign key field, so the command should be:
<%Dbsql::Relation::HTML::generate_description('Category', 'CatID', 'CatName')%>
Hope thats help.
TheStone.
B.
You can use <%Dbsql::Relation::HTML::generate_description('primary_table', 'foreign_key', 'description_field')%> in your template to get the description of foreign key.
E.g: The Book table is related to Category table on CatID which is the foreign key field, so the command should be:
<%Dbsql::Relation::HTML::generate_description('Category', 'CatID', 'CatName')%>
Hope thats help.
TheStone.
B.
