Filtering ChoiceField by Multiple id's and same value ('name')

Hello,

I have a form with three fields (1 Choicefield and 2 ModelChoicefields):  The Choicefield displays names of objects by id's. However, in my db, I have multiple objects with the same name.  I am trying to filter these objects by "species" and "gender" (the two ModelChoiceFields).  I would like to display these objects as singular values, so they can be selected from the Choicefield without it displaying the same name more than once.  I am new to Django, so I "attempted" to write code to accomplish this in my form.py.  The following code displays multiple id's and singular names.  However, I am having a lot of trouble trying to filter these items using functions in my views.py and JQuery in my template.  Basically, I can only get the names that have single Id's naturally associated to filter in the species and gender drop-downs, not the names with the multiple id's.  I realize the following code may be way off base, so I'm wondering if someone could enlighten me on how I could go about this dilemma.  Many thanks in advance.  By the way, I have written a Crispy Form's "Form Helper" Class which aided in display of my Tabs, so that is why my Tab Layout does not look complete.

# crispy forms
class AnimalsList(forms.ModelForm):
    #namequery = Animal.objects.values_list('id','name').order_by('name','id')
    namelist = forms.ChoiceField(label='Animal Names', choices=[])     
    specieslist = forms.ChoiceField(label= 'by Species', choices=[], required=False)
    genderlist = forms.ChoiceField(label= 'by Gender', choices=[], required=False)
    
    class Meta:        
        model = Animal
        fields = ['namelist', 'specieslist', 'genderlist']
        
    def __init__(self, *args, **kwargs):
        #namequery = Animal.objects.values_list('id','name').order_by('name','id').annotate(the_count=Count('name'))
        # get count of animal name to determine duplicates
        count = 0
        did_list = list()        
        mydid_list = list()
        myd = myDict()
        # to return animal obj, count of name
        queryset = Animal.objects.values('name').annotate(count = Count('name'))
        for i in queryset:
            animal_name = i["name"]                     
            if i["count"] <= 1:               
                animal = Animal.objects.get(name = animal_name)
                singular_id = str(animal.id)              
                myd.add(singular_id, animal_name)
            else:               
                dupe_list = Animal.objects.filter(name = animal_name)
                for dupe in dupe_list:
                    dupe_id = dupe.id                    
                    did_list.append(dupe_id)
                if len(did_list) > 1:
                        myd.add(tuple(did_list), animal_name)
           
        # set namequery to equal dictionary items - list of animal id and value        
        #namequery = tuple(dict.items())
        namequery = tuple(myd.items())      
        super().__init__(*args, **kwargs)       
        self.fields['namelist'].choices = (('', 'Select'),) + namequery
        self.fields['specieslist'].choices = (('', 'Select'),) + tuple(Animal.objects.none())
        self.fields['genderlist'].choices = (('', 'Select'),) + tuple(Animal.objects.none())
        self.helper = FormHelper()        
        self.helper.form_tag = False       
        self.helper.layout = Layout(
            Column(                                     
                   Div('namelist'),
                   Div('specieslist'),                                              
                   Div('genderlist')                    
                  ),
               )  

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/6c872186-a592-4696-b74c-d92e218a2a1cn%40googlegroups.com.