logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Managing tables with circular references: msg#00003

Subject: Managing tables with circular references
Hi,
first off I'm new to zetadb *and* Zope, so I hope this is not a too dumb question. And I don't know proper english for the stuff I'm dealing with, so let me construct following example:

customers - as usual
invoices - have a invoice_customer_id and a billing_customer_id

I want to go from customer -> invoice(s) -> billing_customer -> his invoice(s) -> billing_customer -> and so on.

I don't think it's possible to create a 'recusive' folder-hierarchy, so I create table-managers for customers and invoices as siblings.

Now if I add invoices as a field in the customers table-manager and let it (re-)create the objects, I get a seemingly correct link on the customers view form, e.g. to 'myzetadbapp/invoices/filter_action?params'.

But if I click on this link it finds the customers-filter_action first and I get an error because the unfitting parameters (I'm still in the customers-context I suppose, and before Zope starts to traverse the folder tree up, it already finds a filter_action. Right?)

So the question is more Zope-related: How can I go 'up' if all these objects get the same name? And more zetadb-related: Would it be a solution to tweak zetadb to use unique names like 'invoice_filter_action'? Changing this manually works, but is of course a lot of work...

Juergen


-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click


<Prev in Thread] Current Thread [Next in Thread>