Results 1 to 2 of 2
  1. #1
    henri_007 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Apr 2018
    Posts
    1

    Two tables, one form, PK and FK

    Hello everybody. I have one problem. I have two table. User and Informations ( for example). These two tables are connected with PK and FK. In table Informations I have field userId, which is FK ( PK of IdUser in usertable. )



    Now I want to make one form that can insert data in this two tables at once. Problem is that I can't fill any data in "Informations" table while I don't create new User. Is there any way to fill this two table with one form? To create new user and fill inforations about him, at once?

    Thank you!

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    A one to many relationship is normally represented with a Main form for data from the one side and a sub form, as a control object on the main form, for data from the many side.
    The attached db is a very simple example:
    Attached Files Attached Files
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 17
    Last Post: 04-09-2018, 04:39 PM
  2. Replies: 19
    Last Post: 08-10-2017, 01:49 PM
  3. Replies: 2
    Last Post: 07-15-2014, 10:39 AM
  4. Replies: 14
    Last Post: 01-26-2012, 02:20 AM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 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