VB question

Okay, so I am new to this forum.  I am working with Rational ClearQuest for work and it utilizes Basic scripts.  I have some programming experience but no VB. I have been googling for most help but this one I am stuck on.  Hopefully someone can help.
 
Scenario:
 
Two Tables within one SQL database
 
Project with a column called Defect_Lead
 
Defect wtih a column called Lead.   **Note there is also a referenced field(column) called "Project"   No scripted was needed to get this one to work, but I think because it was the name name of the other table.
 
In the Defect script under the field Lead I need to write a VB script that will take the data from the Project tab column Defect_Lead and display and add it to the column in the Defect table.
 
Some background,  here is what I have written so far.
This script is written in the Defect table.
 
Sub lead_DefaultValue(fieldname)
 fieldname As String
record type name is Defect
field name is Lead
 
 If GetFieldValue("Project").GetValue() != " " then
 
REM  Need to pull the value that was set in Defect_Lead field(column) in the Project Table
REM  Need to than Take that value from Defect_Lead and populate the Lead field in the Defect table
 

 End if
 

Any help would be greatly appreciated!

From the looks of the code you posted you are talking about Visual Basic (VB) and not VisualBasic Scripting (VBS)  they are completely different. 

While there are some here that can probably help, you might get more help if you go to  google groups and search on Visual Basic MSDN or the like. 

HI to all
 
 
who can help me about Vbscrit in Corel I want to make a scrip that can Generate  the numbers but the Script in the Corel Just repet the same thins *number*
 
 
Sub alban()
    '
    ' Recorded 9/17/2006
    '
    ' Description:
    '
    '
    Dim dup1 As ShapeRange
    Set dup1 = ActivePage.Shapes.All.Duplicate()
    dup1.Move 1.181102, 0#
    ' Recording of this command is not supported
    Dim dup2 As ShapeRange
    Set dup2 = dup1.Duplicate()
    dup2.Move 1.181102, 0#
    ' Recording of this command is not supported
End Sub

As I said to the OP, this isn't VBscript, but may be VB.  

I suspect that the second code may be technically VBScript but since it is being hosted in an application and being generated by a macro recorder (from all appearances) then it would be hard for anyone that has not coded macros in that specific app to help with.

True.