Self Join Table Form Development

[grizzly98]

I have a table with a field that relies on another field in the same table. Very much like the Employee/Boss table design that is used for self join examples. I have developed the table and query but do not know how to make the form that would support the table design.



The field in the table are:

strID (Primary Key)
strName
strBoss

I think it will require a two form approach, one to create the employee and one to assign the boss. But I want the boss to be a combo box with only employees that have been created. Please help. I thank you for your assistance.

Phil

[June7]

Sounds like cascading (dependent) comboboxes.

Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics section.