Relationships & Lookups in Access

[Shurijo]

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,

[pauleliott]

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


let me know if this helps

[pauleliott]

Dim dbs As Database

[Pirate]

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