Lookup Fields

[Dean]

    LOOKUP_PEOPLE = (
    ('person1', 'person1'),
    ('person2', 'person2'),
    ('person3', 'person3'),
    )

    role_for_who = models.CharField('Role for', max_length=50, choices=LOOKUP_PEOPLE)

Thanks in advance for any help. I almost had it - I wish - but don't think django liked starting with an empty database.

When defining the models.py, rather than use a handtyped LOOKUP_PEOPLE (as above) I would like LOOKUP_PEOPLE to provide the choices from a list of forenames. How do I do that, when the forenames are in the same 'class People'?
(I understand I won't see these in the models.py file).

Thanks again.

[Daniel Roseman]

Sounds like you want a ForeignKey to "self".
--
DR.

[Dean]

Spot on DR - thanks - for pointing me in the right direction :-)