Results 1 to 3 of 3
  1. #1
    DJOKC is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    1

    Update case number field in multiple Tables using one form

    Hi everyone,



    I created a Database with 10 tables, Case number is PK in Table one and all other tables are related by Case Number but the case number is not PK in the other 9 tables. Is there a way to populate Case number in all 10 tables using one field on a single form? I am a beginner and do not know much. Any help will be highly appreciated.

    Thanks

  2. #2
    always404 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    19
    Why do you need to do this?

    Your other 9 tables can have the case number as a selectable foreign key.

    What exactly is happening the the form that will contain this field?

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    1. Make a Main Form with your 'Table One' as its RecordSource
    2. Make nine Subforms, using each of the related Tables as their RecordSources
    3. Use the Case Number in the Link Master Field/Link Child Field Properties.


    When you use this scenario, creating a Record in a Subform will cause the Access Gnomes to insert the CaseNumber into the Subform Record.

    With nine related Tables, I'd probably use a Tabbed Control, placing each Subform on a separate Page.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-28-2012, 07:23 PM
  2. Replies: 3
    Last Post: 10-25-2012, 11:21 AM
  3. Replies: 10
    Last Post: 07-12-2011, 11:09 PM
  4. Replies: 4
    Last Post: 04-18-2011, 07:18 AM
  5. Update Multiple tables from one form
    By KenK in forum Forms
    Replies: 0
    Last Post: 10-30-2009, 08:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums