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

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

    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

    Re: Interpretation needed

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


    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