Results 1 to 3 of 3
  1. #1
    SoulGame's Avatar
    SoulGame is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jan 2017
    Posts
    14

    Question Make a form with much tables

    Good people, I have to create a form to fill 4 different tables and the only way I have found, to do it, is to add subforms in the form, linking the ID fields to be autoplanted, I attached an image of the form 'shoddy' Which I have performed.


    I wish I could have the free fields in a form to order them for my decision, but being inside a subform I can not. How can I get the same result without subforms?


    Thank you very much.



    Click image for larger version. 

Name:	2017-01-18 11_12_21-Access - Consell_Ensenyament _ Base de datos- C__Users_Usuari_OneDrive - CON.png 
Views:	14 
Size:	92.6 KB 
ID:	27189

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    You can make NON related sub forms. Enter data to each table via the subForm,
    or
    Dont use subforms, instead use a single non bound form,
    fill out the fields, click a save button.
    the save button runs various queries to add the data.

  3. #3
    SoulGame's Avatar
    SoulGame is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jan 2017
    Posts
    14
    If I enter all the data in the same form, I get errors of compatibility. I add a button for add a new item and I have a this problem : ' Can not go to the record identified '
    This problem is caused because in the form together the tables 'students' - 'parents' - 'family' and a family can have several parents and students

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

Similar Threads

  1. how to make these tables the same
    By BigDan in forum Access
    Replies: 8
    Last Post: 08-21-2013, 02:23 PM
  2. Make a form with data across several tables
    By goodguy in forum Access
    Replies: 2
    Last Post: 07-15-2011, 02:27 AM
  3. how to make this kind of tables
    By engmsosman in forum Access
    Replies: 2
    Last Post: 01-12-2011, 10:34 AM
  4. Replies: 2
    Last Post: 09-01-2010, 09:51 PM
  5. Not able to make Form from related Tables
    By a1y1a1y1 in forum Forms
    Replies: 5
    Last Post: 01-02-2010, 12:33 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