Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Gloucestershire
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Access 2007 - entering new data

    This is such an obvious question that there must surely be an obvious answer but I can't find it.

    I am new to Access 2007, but am familiar with relational databases. I have set up a database that, cut to the bone, has the following three tables:

    People
    Pserial (autonumber, primary key)
    FirstName
    LastName

    Clubs
    Cindex (autonumber, primary key)
    ClubName

    Role
    RoleID (autonumber, primary key)
    Pserial (foreign key)
    Cindex (foreign key)
    Role
    Comment

    What I now need is a data entry form for someone who knows nothing about database formats or keys. They enter the new data about a person, including Club and Role and the software makes the necessary additions to the tables. Club name and role can be selected from drop down lists of existing options.

    Can this be done with existing form facilities, or will I have to do some programming?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    This is a relatively simple form (for entering each Person) with a subform for the Roles that person has.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Gloucestershire
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by MarkLiquorman View Post
    This is a relatively simple form (for entering each Person) with a subform for the Roles that person has.
    Is there meant to be an attachment or link?

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Here is a demo of a similar situation.

    I have used a little bit of programming, just to be sure that with a new person you don't try to enter data into the subform before the person has been entered.

    The subform has a hidden copy of the PersonID field, and that is entered automatically using the Link fields between the form and subform.

    The combo box on the subform uses a hidden first column to enter the ID field for the Interest (which has the same role as the clubs in your question).
    Attached Files Attached Files
    Regards
    John



  5. The Following User Says Thank You to johnhutchison For This Useful Post:

    OB.. (2011-08-01)

Posting Permissions

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