AnsweredAssumed Answered

Relationship not working

Question asked by Kaps_1 on Jan 20, 2011
Latest reply on Jan 21, 2011 by Kaps_1

Title

Relationship not working

Post

I have two tables :-

1) Projects- containing the name and description of the posts

2) Project _Details - details of the projects.

The attached document contains a number of screenshots :-

http://www.4shared.com/file/ky8mTtt0/screen_shots.html

i) The first screenshot shows the relationship between the two tables

2) The second screenshot shows the identifier project_id being the key between the tables

3) The third screenshot shows how project_details_id is set up - which always seems to be stuck on the value one.

4) The last screenshot shows that there are no related records from the projects to project_details - which seems strange as I have defined a relationship.

Can somebody explain why ? thanks

kaps

Outcomes