Results 1 to 4 of 4
  1. #1
    maxtor is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2021
    Posts
    2

    Problem with create form with two tables

    Dear all,



    I would like tocreate a matrix of courses taken by a list of people.

    I have two tables,one with names of people, second with list of courses.

    I would like tocreate form like on graph but I don't have idea how it should looks table tothem.

    First idea wascreate table like this:
    Click image for larger version. 

Name:	table.png 
Views:	13 
Size:	5.3 KB 
ID:	45869

    But I don't know howi can create form like on below:
    Click image for larger version. 

Name:	form.png 
Views:	13 
Size:	8.2 KB 
ID:	45870

    Thanks for anysuggestions,

  2. #2
    mike60smart is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    760
    Hi Maxtor

    Can you upload a zipped copy of your database?

  3. #3
    maxtor is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2021
    Posts
    2
    Hi,

    Thanks for your replay,
    Here you are, in appendix copy of database.
    Attached Files Attached Files

  4. #4
    mike60smart is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    760
    Hi

    I changed the relationships so that Referential Integrity was enforced.

    I also changed the fieldnames where you were using:- Name_ to Coursename and Firstname

    Look now at the Relationship Diagram and also how the subform is constructed.
    Attached Files Attached Files

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

Similar Threads

  1. Create a form from three tables
    By Shamli in forum Access
    Replies: 10
    Last Post: 07-23-2018, 05:15 PM
  2. Replies: 1
    Last Post: 08-29-2016, 08:04 PM
  3. Create a form from 2 tables
    By paologucci in forum Access
    Replies: 1
    Last Post: 03-21-2016, 06:18 AM
  4. Multiple tables to create one Form??
    By Gravity101 in forum Forms
    Replies: 2
    Last Post: 06-02-2011, 06:37 AM
  5. Create a form using 3 tables
    By Mrdudecool in forum Forms
    Replies: 1
    Last Post: 01-20-2011, 01:43 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