pleezzzz help...

Discussion in 'Databases' started by syida, Jan 13, 2008.

0
  1. #1
    how to create "foreign key " using micr. access.. please a.s.a.p... TQ
     
    syida, Jan 13, 2008 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    In Access 2007 it is under Database Tools -> Relationships - dont have any older versions of access installed to say about previous ones.
     
    AstarothSolutions, Jan 13, 2008 IP
  3. nicangeli

    nicangeli Peon

    Messages:
    828
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I think this is how you do it;

    Create two tables in access, then go to tools > relationships click add to both of the tables, then drag from one primary key, to the field that you want to be the foreign key in the second table.
     
    nicangeli, Jan 14, 2008 IP