3 Replies Latest reply on Jan 21, 2011 1:10 AM by Kaps_1

    Relationship not working

    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