Update data in linked tables, How? (One==>Many relation)

Discussion in 'Microsoft Access Queries' started by Silvio, Jul 26, 2008.

  1. Silvio

    Silvio Guest

    When I split may tables to properly handle one to may relations, I noticed
    than when I link these tables back through a query then I can not update any
    information in any of the fields. Normally I use a form based on this query
    to display the data so users can go in and update fields through use of combo
    box. What's the best way to handle such scenario?

    Thank you,
    Silvio
     
    Silvio, Jul 26, 2008
    #1
    1. Advertisements

  2. Silvio

    Rick Brandt Guest

    Silvio wrote:
    > When I split may tables to properly handle one to may relations, I
    > noticed than when I link these tables back through a query then I can
    > not update any information in any of the fields. Normally I use a
    > form based on this query to display the data so users can go in and
    > update fields through use of combo box. What's the best way to handle
    > such scenario?
    >
    > Thank you,
    > Silvio


    Forms with subforms, each bound to a single table. Even when multi-table
    queries allow updates it is often not a good idea to use them for that.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
    Rick Brandt, Jul 26, 2008
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Shailesh Patel

    Join two table with one to many relation

    Shailesh Patel, Mar 22, 2004, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    318
    MGFoster
    Mar 23, 2004
  2. Guest

    many to many then one to many

    Guest, Apr 26, 2005, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    351
    MGFoster
    Apr 26, 2005
  3. many to one relation

    , Apr 6, 2006, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    141
  4. tbl
    Replies:
    2
    Views:
    422
  5. Pamela Creighton

    link tables many to many one unique field in each table

    Pamela Creighton, Aug 12, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    160
    Duane Hookom
    Aug 12, 2006
Loading...

Share This Page