Hello,  sorry the subject is not more helpful.

I have two tables, Table a and Table b.

I want a load of fields from Table a plus one from Table b.

Table a contains Time Slips.  Each Time Slip is associated with a Task; the
Tasks are in Table b.  The link is an integer field.

Table b contains not only Tasks, but also Parent Tasks.  So, in an
engineering office a Parent Task might be 'Design'.  The actual (child)
Tasks could be 'Foundations', 'Superstructure', 'Site Investigation' etc.
There is a field ParentID which contains 0 for Parents and the autoinc field
of the Parent for all Tasks.  Hope this makes sense.  This structure is
needed to use DevExpresses Quantum TreeList.

For each Time Slip I need to recover the name of the Task from Table b
(easy) but also the name of the Parent Task.  This is of course another
record in Table b linked to the Task by an integer field.

How can I achieve this?

Thanks.

Rob.

Robert


Have you asked twice or has my system downloaded twice or have Tim's ng's gone weird?

Roy Lambert

Roy

This is wierd.

I sent a new post and when I later checked it was not there.

I sent a second post and immediately checked in OE Express and noted a new
message had been added.  I could not see it.

I then went down a list of the subjects and could see both messages have
been added (on my system) as replies to another message with the same title.

So, yes, I have posted twice and I can see you have replied to the other
message.

Thanks for your help.

Rob.

ps  Are you UK based?



"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:79692DF9-6970-488B-A51F-C56D357171D7@news.elevatesoft.com...
> Robert
>
>
> Have you asked twice or has my system downloaded twice or have Tim's ng's
> gone weird?
>
> Roy Lambert
>

Robert

>ps Are you UK based?

Yup - up in the Highlands

Roy

"Robert Rowlands" <rob@notathome.com> wrote on Wed, 17 May 2006 15:49:53 +0100

>Roy
>
>This is wierd.
>
>I sent a new post and when I later checked it was not there.
>
>I sent a second post and immediately checked in OE Express and noted a new
>message had been added. I could not see it.
>
>I then went down a list of the subjects and could see both messages have
>been added (on my system) as replies to another message with the same title.
>
>So, yes, I have posted twice and I can see you have replied to the other
>message.
>
>Thanks for your help.
>
>Rob.
>


Rob


Roy  ( Oh! Rob Roy!) should have told you to stop using that old Outlook Express!  There is a good newsreader called TMaN that you should try!

Cheers

Jeff

--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Jeff


The reason I wanted to know if Robert had posted twice was that if not I was going to send a bug report to the author of TMaN <vbg>


Roy Lambert