On Tue, Oct 14, 2008 at 07:48, Greg Ewing <[EMAIL PROTECTED]> wrote: > > Necmettin Begiter wrote: > >> At the admin page (or my template, whatever), when I select Person as >> the source table, SourceIdx / SourceName should be dynamically fetched >> from the Person model. If I change it to Phone, this time members of >> the Phone model should be listed. > > This sounds like a user interface issue, and you shouldn't > be trying to solve it by warping the data model to cram all > your relationships into one table. That's an extremely bad > way to design a relational database. > > I'd think about having one page where you select which > source table you want to work on, that leads to one of > a number of other pages, each one tailored for a > particular table. > > -- > Greg
So you're saying if I have ten tables, I should create ten pages? And when I need to fetch related items for an item in one of the tables, I should query each one seperately? (10 queries x 10 pages = 100 queries) What about add record, delete record, and modify record operations. If I want to add another table/class to this structure, do the same and create relationship pages for each and every other table? What if, I had, say, 15 tables? Honestly, that does not sound Pythonic, not even programmatically logical. If I distribute these relations among tables, I will need as many ManyToMany fields ^2 as there are tables (because each record/row/item/whateveryoucallit can be related to another record in that same table or another one). If possible (I believe it should be, and there *must* be a way to achieve this), I would prefer keeping all relations amongst all tables in one table, not distribute them as many ManyToMany relations in all tables. Necmettin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
