Relationships & Lookups in Access

Does anyone know how to establish relationships and lookups within an Access database? I am creating a new db and then creating and populating the tables. I need to be able to link the domain fields to the domain tables.

I found this old thread:
http://www.vbforums.com/showthread.p...hreadid=227413

I was just wondering if anyone has found any new information since then.

I would really like to be able to use the lookup tab options of the field. So I can enter a query statement to create the drop down lists from those domain tables. I am using ADOX right now.

thanks,

Dim rel As Relation
Set rel = dbs.CreateRelation(table.field, table.field)
rel.Attributes = dbRelationDeleteCascade


let me know if this helps

Dim dbs As Database

Look for an example I posted in the VB.NET CodeBank . It's about relations .