DevForce Community Forum : Adding a new coloum

DevForce Community Forum : Adding a new coloum http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Adding a new coloum Tue, 14 Apr 2026 23:20:12 -700 Sun, 24 Feb 2008 21:10:47 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=695 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Adding a new coloum : Public ReadOnly Property Name()... http://www.ideablade.com/forum/forum_posts.asp?TID=695&PID=2593#2593 Author: johnkym
Subject: 695
Posted: 24-Feb-2008 at 9:10pm

Public ReadOnly Property Name() As String

Get

If Me.KnownAs= Nothing Then

Return Me.FirstName & ", " & T1_T2.Surname

Else

Return Me.KnownAs & ", " & T1_T2.Surname

End If

End Get

End Property

T1_T2 is the relationship between T1 and T2

Thanks Me...]]> Sun, 24 Feb 2008 21:10:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=695&PID=2593#2593 Adding a new coloum : I would like to join to tables... http://www.ideablade.com/forum/forum_posts.asp?TID=695&PID=2592#2592 Author: johnkym
Subject: 695
Posted: 24-Feb-2008 at 8:03pm

I would like to join to tables well not really i just wish to get data from one table and then insert a new colum into another for exaple

T1=

ID Firstname Knownas SurnameID

========================

1 Alfred John 2

2 Kym 2

3 Gannon 3

4 Leane 3

5 Anthony 4

SurnameID Surname

=================

2 Hill

3 Hill

4 Zacker

T1 new =

ID Firstname SurnameID Name KnownAs

===============================================

1 John 2 John, Hill John

2 Kym 2 Kym, Hill

3 Gannon 3 Gannon, Hill

4 Leane 3 Leanne, Hill

5 Anthony 4 Anthony, Zacker

]]> Sun, 24 Feb 2008 20:03:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=695&PID=2592#2592