I have added an employee table consisting of employee_id and Employee fields to the calendar database. The sql scripts all have the new field added. The field displays on the calendar views. Now for the problem - how do I display a drop down list of employee names in the add and edit functions? I have set up the 'Edit As - Lookup Wizard' for the field and the 'testing' displayed the employee names. The field displays in the 'add new' page but the drop-down list does not.
Any suggestions? Is there a special way to add a 'join' similar to the one for 'catagories'?
Thanks,
Mary