Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Unanswered: can't add new records

    I've made a query from 3 tables. There are also relations among this tables. There is no problem to add records in the query. But when I make a form from this query I can't make changes or add records via the form. In the options of the form, adding and changing is allowed.

    Has anyone a suggestion?
    ddev

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    In order to add you need to have the a means of separately identfying each tables primary key.

    So i'm guessing your query doesn't have the primary key for each table in it.

  3. #3
    Join Date
    Nov 2005
    Posts
    2
    Quote Originally Posted by healdem
    In order to add you need to have the a means of separately identfying each tables primary key.

    So i'm guessing your query doesn't have the primary key for each table in it.
    yes I did so. are you interested to see the database?

Posting Permissions

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