in reply to Class::DBI has_many


Well.. I finally got it working the way that I wanted. And yes - a column may appear in more than 1 page.

Here is the way I have designed it.
Table page
page_id page_title
1 Geography
2 History
Table page_column
column page
1 1
2 1
3 1
4 2
Table column
column_id column_title
1 Geog 1
2 Geog 2
3 Geog 3
4 Hist 1

Two things I noticed which Class::DBI required -
1) In table page_column, "column" should be the primary key and not "page"
2) while coding the relationships, its better to use "page" and "column" column names instead of "page_id" and "column_id"

Now the "mapping" stuff as suggested by PodMaster works like a charm, and I can get all columns in page easily.

Thankx a lot for all the help.
I know that this design may not be realistic but it very much suffices me for now.
--
arc_of_descent