Hi. Plese, i have some problem with ado and vb. I'm trying to create a relationship between two tables using the method .CreateRelation (with DAO). Plese anyone know to create this, and acess with vb and ado?


tanks.

The CreateRelation method returns a Relation object which must be appended to the DAO.Relations collection with the DAO.Relations.Append method.

Try this:

set r = DB.CreateRelation( name, table, foreigntable, attributes)
DAO.Relations.Append r

~ Shaun