Creating relations in MS Access with C#

Friend Run Query like below to add Primary key and Foreign key to make relationship between two tables

if my answer helps you then please check "Do you like this answer check box " :)

OledbConnection con = new OledbConnection("Connection String");
con.Open();

//Adding Primary Key

OledbCommand comm = new OledbCommand("alter table Table1 add constraint pk_id primary key(id)",con);
comm.ExecuteNonQuery();

//Adding Foriegn Key

comm = new OledbCommand("alter table Table2 add constraint fk_id foreign key(id) references Table1(id)",con);

comm.ExecuteNonQuery();

con.Close();