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
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