Referencing columns in join with same name

[iejerry]

How do I reference (qualify) two columns with the same name in vb code? I have a join where I select the Name column from the Job table and the Name column from the Employee table. (This is a vendor "designed" database and can't be changed.) I've always just used something like

txtName.text = Rst!Name

What would I use to complete:
txtJobName.text =
and
txtEmployeeName.text =

Thanks!

 

[MarkSweetland]

Similarly named columns in a JOIN must be referenced directly using either an alias or table name prefix with the column name in the SQL statement or you'll get an ambiguous column name error.

Try:

txtJobName.text = rst!JobTableName.Name
and
txtEmployeeName.text = rst!EmployeeTableName.Name


Mark