'Need to take two fields from one model and use it as foreign key for a new model using django

Model 1

class Users(models.Model):

    employee_name = models.CharField(max_length=210)
    dob=models.DateField(max_length=8) 
    email=models.EmailField(max_length=254,default=None) 
    pancard=models.CharField(max_length=100,default=None)
    aadhar=models.CharField(max_length=100,default=None)
    personal_email_id=models.EmailField(max_length=254,default=None)
    phone = PhoneField(blank=True)
    emergency_contact_no=models.IntegerField(default=None)
    name=models.CharField(max_length=100,null=True)
    relation=models.CharField(max_length=25,default=None)
    blood_group=models.CharField(max_length=25,choices=BLOOD_GROUP_CHOICES,null=True)
    joining_role=models.CharField(max_length=250,choices=JOINING_ROLES_CHOICES,null=True)
    billable_and_non_billable=models.CharField(max_length=250,choices=BILLABLE_and_NON_BILLABLE_CHOICES,default='Billable')
    joining_date=models.DateField(max_length=15,null=True)
    relieving_date=models.DateField(max_length=15,null=True)
    
    def __str__(self):
        return self.employee_name

Model 2

class Consolidated(models.Model):
    
    emp_name=models.ManyToManyField(Users,related_name="employee_name+")
    proj_name=models.ManyToManyField(Project)
    custom_name=models.ManyToManyField(Client)
    Cons_date=models.ManyToManyField(Add_Timelog)
    bill_no_bill=models.ManyToManyField(Users,related_name="billable_and_non_billable+")
    hour_spent = models.ManyToManyField(Add_Timelog,related_name="hour_spent")
    
    def __str__(self):
       return str(self.emp_name)

I need to take the value updated on the "employee_name" and "billable_and_non_billable" field in the "User" model to "emp_name" and "bill_no_bill" field in "Consolidated" model. Will it be possible to take two fields as foreign key from one model to another. I'm new this django kindly help me if there is any possible ways.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source