your going to have to create a separate search action which get the
distinct manager id and name
then your going to have to change the output to make the pulldown get
its data from this new search action you did prior
this is custom, and can't be done in search builder
On Sep 16, 2008, at 3:24 PM, Tom Ferguson wrote:
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
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
