Create a Direct DBMS action
Your basic query is:
select
u.[ID], u.[Name], u.[Type], u.BossID, b.[Name] as BossName
from
[User] u
join [User] b on u.BossID = b.ID
This should result in a 2D array of every user (including bosses) with their
immediate bosses name output as "BossName". Add where/order by clauses as
necessary.
Hope this helps.
On Tue, Sep 16, 2008 at 4:28 PM, Ben Johansen <[EMAIL PROTECTED]> wrote:
> 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
>
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
