如何将上数据表中的不同条目显示为下拉框选项？

Question

您好，这是我的工作名称数据库表https://www.screencast.com/t/tse1qsnJI

这是从employee表中得到的

https://www.screencast.com/t/uMtmowCg

如何在下拉框中显示职务而不是职务id作为选项

https://dpaste.de/SpAe

Answer 1

forms.py

from django.forms import ModelChoiceField

class JobChoiceField(ModelChoiceField):
    def label_from_instance(self, job_model_instance):
        return f'{job_model_instance.job_title}'

class AssignJobForm(forms.Form):
    job_option= JobChoiceField(
        YourModelName.objects.all(), to_field_name="pk",
        widget=forms.Select(attrs={'class': 'pd-10 form-control'})
    )
    # you can remove widget here.
    # you can add more fields as per your requirements.
    # job_option filed will be dropdown list here.

YourModelName=定义职务的模型

作业\u模型\u实例=无所谓。让它保持原样