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.