Print Page | Close Window

Adding a new coloum

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=695
Printed Date: 02-Apr-2025 at 8:49pm


Topic: Adding a new coloum
Posted By: johnkym
Subject: Adding a new coloum
Date 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
 
T2
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
 


Replies:
Posted By: johnkym
Date 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...


Print Page | Close Window