if it was in two separate table I could do that, but it's in the same table...
> -----Original Message----- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 16, 2008 05:18 > To: [email protected] > Subject: Re: Witango-Talk: Should be simple... > > you are going to have to make a JOIN between the 2 tables in > the Search builder > > On Sep 16, 2008, at 3:12 PM, Tom Ferguson wrote: > > > 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 > > > > > > Ben Johansen > http://www.webspinr.com > [EMAIL PROTECTED] > Phone: 360-597-3372 > Mobile: 360-600-7775 > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
