Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    15

    Unanswered: Interpretation needed

    I have been working on this issue for at least a day and a half. I think I'm not understanding what the true problem is. Can someone interpret this error for me:

    Cannot add record(s); join key of table 'BSC Assignment' not in recordset

    I get that error when attempting to add a record through the subform. I am using a form with a subform. Here's a diagram:
    Key:
    PK = primary key


    PERS (form)
    |
    BSC-MPA (subform)
    |
    BSC-MPA Combo (qry)
    / \
    BSC Assignment(tbl) MPA(tbl)
    PK is A#... PK is BSC & UIC

    Joins between BSC Assignment and MPA are BSC & UIC.

    If anyone needs additional information just let me know. Any help anyone can give will be greatly appreciated.
    Last edited by dgerler; 03-09-04 at 08:47.

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: Interpretation needed

    When updating records in a join you need all primary keys present in your recordset otherwise there is no way of distinctly updating a record. Make sure that primary keys of BOTH tables are present in your join query.
    In abundance of water only the fool is thirsty. Bob Marley.

  3. #3
    Join Date
    Oct 2003
    Posts
    15

    Re: Interpretation needed

    Originally posted by rami.haddad
    Make sure that primary keys of BOTH tables are present in your join query.

    THANK YOU!

    That turned the light bulb on nice and bright. I am teaching myself from scratch and I have obviously missed an item or two.

    I had half of the key from each table.

    I appreciate your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •