I have a object with a many-to-many relation with another object.
In the Django Admin this results in a very long list in a multiple select box.
I'd like to filter the ManyToMany relation so I only fetch Categories that is available in the City that the Customer have selected.
Is this possible? Will I have to create a widget for it? And if so - how do I copy the behavior from the standard ManyToMany field to it, since I would like the filter_horizontal function as well.
These are my simplified models:
class City(models.Model):
name = models.CharField(max_length=200)
class Category(models.Model):
name = models.CharField(max_length=200)
available_in = models.ManyToManyField(City)
class Customer(models.Model):
name = models.CharField(max_length=200)
city = models.ForeignKey(City)
categories = models.ManyToManyField(Category)