I have table "Pemilik" and "Tanah" . How I can relate both tables using "PLOT" As common field?
Code:Dim pConn As New ADODB.Connection pConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DBMS.mdb" & ";Jet OLEDB:Database Password=macres" pConn.Open Dim pCommand As New ADODB.Command pCommand.ActiveConnection = pConn pCommand.CommandType = adCmdText pCommand.CommandText = "SELECT Plot,BLOCK,PEMILIK1,PEMILIK2 FROM pemilik" Dim relTable As New MapObjects2.Table Set relTable.Command = pCommand




Reply With Quote