Forum: Ruby on Rails Single view over multiple tables

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Kevin (Guest)
on 2006-01-24 01:37
In my effort to learn rails, I'm writing a personal Information
Management "system".  So, something where I can track passwords, credit
cards, ssn, drivers license, etc.  What I have done, and perhaps not
correctly, is created a table for each category.

I want to create a master list page.  One view that displays all the
data from the various tables by category.  Do I fail as a database
designer or is there a way to make this happen easily?  Is there a
tutorial I might benefit from?

I started off creating a categories, passwords and creditcards table.  I
can enter data into all three.  I have the relationship between
categories and passwords and categories and creditcards working just
fine.   I started to create a join between creditcards_passwords
thinking that I could then create the scaffold and view from there that
would allow me to see all my password and credit card entries in one
combined list, but IĆ¢??m feeling like I might be way off the reservation
on this approach.

Thanks for the help.
This topic is locked and can not be replied to.