Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Display related info?

Quote Reply
Display related info?
2 part question "related tables"

1. Do I need to create a primary field for every table I have, to be able to relate. I only have 1 table with primary 'uniques' records in it. Next 5 tables have info related for first tablem, but most of them have multiple records in them when searching for 1st tabel unique record.

2. how do I display info on my template pages? Looking to combine everything (6 tables, which have been 'related')on single page?

I tried <%Dbsql::Relation::HTML::generate_description('testtable', 'testcolumn', 'testname')%>

I have no clue how to do this?
Thanks