URGENT: ADOX / Relationship

[giacomitti]

How I can create a one-to-one relationship between two tables??? I use this code but I only can create one-to-many relations. I have two tables

Funcionario | Topdata
------------|------------
ID | FUNCIONARIO
NAME | TOPDATA
MAT |
CARD |

and I am using Microsoft.Jet.OLEDB.4.0.


set oKey = new ADOX.Key
set oColumn = new ADOX.Column
With oKey
.Name = "FuncionarioTopdata"
.Type = adKeyForeign
.RelatedTable = "Funcionario"
.Columns.Append "Funcionario"
.Columns("Funcionario").RelatedColumn = "ID"
.UpdateRule = 0
.DeleteRule = 0
End With
oCat.Tables("Topdata").Keys.Append oKey




Thanks
Arnaldo