Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add Records To A Table (Access 2002)

    I developed a form that uses two tables as the "Record Source"; the form will not update the table I want. How does Access update a table when you develop a form that uses a query that uses multiple tables / queries?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add Records To A Table (Access 2002)

    That depends on the way you related the two tables. There should be a unique index (preferably the primary key) on the join field on the "one" side of the join between the tables. Otherwise, the query will not be updatable.

    It might be better to use a main form (based on one table) and a subform (based on the other table).

Posting Permissions

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