Primary key foreign key

[mclueless]

I am working with Vb6 Access.How to establish primary key foreign key relationship between tables in access???

[jamesd0142]

I am working with Vb6 Access.How to establish primary key foreign key relationship between tables in access???

In access...

---primary keys---
open table in design view
right click row and click primary key

---foriegn keys---
Click Tools > Relationships

Add the tables

Drag the filed you need to be a foriegn key to the other table.

[werks]

I am working with Vb6 Access.How to establish primary key foreign key relationship between tables in access???

Click the Tools-->Relationships in MS Access. Select the Table you want to have a relationships and just click the field you want to set to Primary then drag it and drop it to the other table.. Sorry for the explanation, im not really good at it


Kenneth

[werks]

Try this link, it might help you.

http://www.functionx.com/access/Lesson17.htm