But maybe my brain is just frozen... I have a User Table with different types of users. Some of the users are bosses and some of the users are workers.
User Table ID Name Type (boss or user) BossID The BossID contains the ID of the boss' record. I have a typical taf built from the search builder. In the RecordDetail when I'm displaying the Worker's information, I want to display his boss' name instead of his boss' ID. How do I do that. If the boss' name was in a different table, it would be a snap. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
