Dear All ,
Greetings!
This is my first post on this forum and seeking the solution of a problem. Hope, I would certainly get from the forum.
Say, I have got Two tables. Those are..
1. users
Field in users: user_id(pk)
2. commitment
Field in commitment: user_id(fk for commitment table)
A. My question is: How should I set the relation between users and commitment tables in Phpmyadmin?
But I did the relation in commitment table this way but I am not sure of it.
Code: ( text )
1.
commitment
2.
--------------
3.
foreign key(user_id) references users(user_id);
4.
5.
Is this way that can I show relation between users and commitment ?
Your help would be greately.. praised.
Thank you very much for the help in advance
Samuel
Greetings!
This is my first post on this forum and seeking the solution of a problem. Hope, I would certainly get from the forum.
Say, I have got Two tables. Those are..
1. users
Field in users: user_id(pk)
2. commitment
Field in commitment: user_id(fk for commitment table)
A. My question is: How should I set the relation between users and commitment tables in Phpmyadmin?
But I did the relation in commitment table this way but I am not sure of it.
Code: ( text )
1.
commitment
2.
--------------
3.
foreign key(user_id) references users(user_id);
4.
5.
Is this way that can I show relation between users and commitment ?
Your help would be greately.. praised.
Thank you very much for the help in advance
Samuel