Relationship

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • column.column@gmail.com

    Relationship


    Hello,

    I need to create simple relationship between two tables fields. 1'st
    table contains ID that is index and unique. 2'nd table's field ID2
    should contain values only from 1'st table field ID records and no
    others. I have tried all three join types, but this doesn't helped -
    it is still possible to enter value to 1.ID that is not from 2.ID.
    Would you help me to solve this problem?
    MS Accsess 2007

    Thank you
Working...