class Store_Master(models.Model):
id = models.IntegerField(primary_key=True)
d_code = models.CharField(max_length=50,blank = True,null = True)
showroom =models.CharField(max_length=50,blank = True,null = True)
short_code=models.CharField(max_length=50,blank = True,null = True)
type=models.CharField(max_length=50,blank = True,null = True)
flat_house_no =models.CharField(max_length=50,blank = True,null = True)
street_building_name=models.CharField(max_length=50,blank = True,null = True)
landmark=models.CharField(max_length=50,blank = True,null = True)
pincode=models.CharField(max_length=50,blank = True,null = True)
area=models.CharField(max_length=50,blank = True,null = True)
taluk=models.CharField(max_length=50,blank = True,null = True)
district= models.CharField(max_length=50,blank = True,null = True)
state=models.CharField(max_length=50,blank = True,null = True)
status=models.CharField(max_length=50,blank = True,null = True)
dob=models.CharField(max_length=50,blank = True,null = True)
closed=models.CharField(max_length=50,blank = True,null = True)
def __str__(self):
return self.showroom
class edition(models.Model):
id = models.IntegerField(primary_key=True)
district= models.ForeignKey(Store_Master, on_delete=models.DO_NOTHING)
state = models.CharField(max_length=50, blank=True,null=True)
vk_daily = models.CharField(max_length=50, blank=True,null=True)
vk_dhinam= models.CharField(max_length=50,blank=True,null=True)
def __str__(self):
return self.district
help me to write views.py for this on. in both tables district is present I use that as a foreign key. and I have some limited districts in that district we have more showrooms I need to map that using ForeignKey
my expected output is when I click district the store_master data will appear on table view. please help me to resolve this thanks in advance