Daniel, I'm building an invoice system. The data relations are as follows:
Customer -1toN-> Orders -1toN-> Products The products can have different tax levels which, during creation of an order, get chosen by the user from a drop downlist. As shown in my first email, a tax level value (e.g. 0%, 6% or 19%) gets copied to a product.tax_level attribute from the metadata model. Since the value of those taxes can change overtime (by law), I copy them. If I don't copy them (and use relationships), adjusting the value to a new tax level would 'cripple' the old orders. Note that performance or normalisation is currently not a priority, code and app readability is. Then since it's a copy of the tax value level to the product it does not have to be a relationship, and thus a lookup will suffice. Hence my earlier question, how can I fill a dropdown list (BTW_CHOICES) with values from a (different) model. # MetaData model: http://paste.pocoo.org/show/85368/ - The display represents the value that the user sees in the dropdown list (see below). It can be compared with the __unicode_- function for objects. - The value is the actual value that is copied and on form submission stored in the product object # Product Model: http://paste.pocoo.org/show/85370/ The way BTW_CHOICES should be filled is '(attribute, display)' taken from the metadata model: BTW_CHOICES = ( ('0.0', '0%'), ('6.0', '6%'), ('19.0', '19%'), ) I hope this clearifies things. Thanx a lot for your interest and help! Regards, Gerard. Daniel Roseman wrote: > On Sep 13, 10:56 am, Gerard Petersen <[EMAIL PROTECTED]> wrote: >> Daniel, >> >>> If you want a field that's populated with values from another model, >>> you should use a ForeignKey. >> Is it then still possible to use filters and such, and keep it in the model >> logic? >> >> Because the Meta model has these fields: 'attribute', 'value', 'display', >> 'description' >> >> And it's more like a lookup then a real relation between the models Order >> and Meta. > > > I can't really understand what you're asking here, I'm afraid. Maybe > you could post your models code (preferably on dpaste.com) along with > some indication of what you're trying to do. > -- > DR. > > > -- urls = { 'fun': 'www.zonderbroodje.nl', 'tech': 'www.gp-net.nl' } --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
