This is both a Perl question and a SQL question:

I'm working on a big web database system (CGI-perl and PostgreSQL and MySQL for the curious), and I now need to tackle relationship management. Ultimately, I'd like a similar user interface to that used in Access or Filemaker - basically, the user will go in and define what primary key of one table is a foreign key in another table, and the back end will take all that information, and use it in constucting the SQL statements, both for data output as well as for data input (i.e. the right options will appear in menus and checkboxes, etc. from another table for data input.)

It's a big job, and in the interest of not re-inventing the wheel, does anyone have examples of doing this for web-based dbs? How was it accomplished? Any appropriate modules I should be looking at? If people have tried it - perils and pitfalls?

Thanks!!

.Michelle