Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add record to query (2000)

    Hi I just started using Access so I don't know it at all. I have 2 tables 1 called Cows and other called Transactions. I made a query from the 2 tables. My problem is the query will not allow me to add records, what am I doing wrong? I looked at the Northwind database and the query Category sales for 1997 will not allow you to add to it. Do I need to change a setting?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Add record to query (2000)

    Can you tell us about the structure of the tables, and the composition of the query.
    When you try to add a record in the query, is the record supposed to go into cows, transactions or both?
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add record to query (2000)

    I changed my primary key to the cow ID instead of a auto number and every thing works great.
    Thanks

Posting Permissions

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