I have a table defined as follows: employee = db.define_table('employee', Field('employeeId', 'id', writable=False, label='Employee #'), Field('firstName', length=25, required=True, label='First Name', writable=False), Field('lastName', length=25, required=True, label='Last Name', writable=False), ... Field('departmentId', db.department, label='Department', writable=False), Field('supervisorId', 'reference employee', label='Supervisor', writable= False), format='%(lastName)s, %(firstName)s')
db.employee.dob.requires = IS_NULL_OR(IS_DATE('%m/%d/%Y')) db.employee.seniorityDate.requires = IS_NULL_OR(IS_DATE('%m/%d/%Y')) db.employee.hireDate.requires = IS_NULL_OR(IS_DATE('%m/%d/%Y')) db.employee.originalHireDate.requires = IS_NULL_OR(IS_DATE('%m/%d/%Y')) db.employee.terminationDate.requires = IS_NULL_OR(IS_DATE('%m/%d/%Y')) My supervisorId field displays correctly with the dropdown if it is writable, but when I set writable=False it just displays the value of the supervisorId field, not the assosiated employee first/last name as the format would dictate. departmentId is setup to behave the same way, just referencing a different table and it displays the proper 'name' of the department when writable=False instead of the id field like supervisorId does. Is this a bug? -Jim --