+ Reply to Thread
Results 1 to 2 of 2

Field value on form stored in two different tables

  1. #1
    Registered User
    Join Date
    09-13-2017
    Location
    Luxembourg
    MS-Off Ver
    Excel 2007
    Posts
    1

    Field value on form stored in two different tables

    Hi!
    I need some help. I have a database with some forms and tables. on Form1 on Table1 i need to put one field (Field1) whose content has to be stored in the corresponding line in Table1 and copied in a new line of Table2, also copying data from Filed2, Field5 and Field7, plus i need to add two fields (Field9 and Field10) tho fill up the related fields in Table2.

    Is this possible? i'm quite a rookie in access and access vba, so any kind of help (except creating a subform) would be great.
    thank you!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2016
    Posts
    12,102

    Re: Field value on form stored in two different tables

    Sounds to me like you may have a design flaw. Data in a RDBMS should only be stored once. Look at this link on database design.

    http://r937.com/relational.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1