Form With Data From Two Tables And Is Editable...?

I have two tables:

Marathons and People

I need all the data from Marathons and the address data from People.

I have created a query:

*Marathons, address 1, address 2 et cetera

I have created a form for this data - however, I need the user to be able to
edit it.
Do queries in their nature allow this? Is the Lookup function related to
this? Should I put all the address data straight into the Marathon table -
but then how will it be updated?

Please note that whilst I am beggining to understand code, I still find it
hard to get my head round, so if it is the only option, please explain in
full.

Many Thanks
Camilla

1 Comment

  1. Re: Form With Data From Two Tables And Is Editable...? by BruceM via AccessMonstercom

    BruceM via AccessMonstercom 2009-10-23

    If the querycannot be edited, a form based on the query cannot be edited.
    Without knowing more about your database structure it is not possible to be
    specific, but here are some reasons a query is read-only:
    http://allenbrowne.com/ser-61.html

    You should have separate tables for Marathons and People. If People may be
    in several Marathons, and you want to track that information, you would want
    a third table to serve as a junction table between the two.

    tblMarathon
    MarathonID (prkmary key, or PK)
    Location
    MarathonDate
    etc.

    tblPeople
    PersonID (PK)
    FirstName
    LastName
    Address1
    etc.

    tblMarPeople
    MarPeopleID (PK)
    MarathonID (foreign key, or FK)
    PeopleID (FK)

    Create a relationship between the two MarathonID fields and the two PeopleID
    fields. Build a form based on tblMarathon, with a subform based on
    tblMarPeople. On the subform is a combo box bound to PeopleID, with a Row
    Source from tblPeople (you would be storing the PK).

    Confused87 wrote:
    I have two tables:

    Marathons and People

    I need all the data from Marathons and the address data from People.

    I have created a query:

    *Marathons, address 1, address 2 et cetera

    I have created a form for this data - however, I need the user to be able to
    edit it.
    Do queries in their nature allow this? Is the Lookup function related to
    this? Should I put all the address data straight into the Marathon table -
    but then how will it be updated?

    Please note that whilst I am beggining to understand code, I still find it
    hard to get my head round, so if it is the only option, please explain in
    full.

    Many Thanks
    Camilla

    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200910/1