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

    Relationship not working



      Relationship not working


      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 :-


      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