Results 1 to 5 of 5
  1. #1
    akhon is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jan 2019
    Posts
    2

    Need Help To create Table Design


    I have created a 3 table name:- Perf, student and subject. now i have created a datasheet for pref table and created a form in which i have kept field from student and sub-form of pref now problem is the record of pref are same for every student if changed the the value in pref sub-form of one student it get changed every student. in have also attached the database file.
    OR

    in form1 the subject Performance remain same for every student if i changed the value of one student it get changed the value of other student also.
    plss look at the database i have attached and tell me what i have done wrong..... and if possible pls make it correct.I have also upload screenshot

    Click image for larger version. 

Name:	Untitled.jpg 
Views:	21 
Size:	58.7 KB 
ID:	37030Database.zip

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Every table should have a primary key.

    General facts:
    Student studies Subject
    StudentSubjectPerformance/Marks

    Click image for larger version. 

Name:	studentSubjectPerformance.PNG 
Views:	21 
Size:	71.5 KB 
ID:	37033

    I'm not sure where Reading and Writing fit in your description.

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    akhon-davegri-v01.zip
    It's a many-to-many setup between students and subjects.
    See attached for your DB configured so.

  4. #4
    akhon is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jan 2019
    Posts
    2
    Thanks You Guyz...
    this solved my problem
    admin Lock this thread as solved

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    There is a Mark Thread Solved button at the top of the page that you can use to mark the thread solved.

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

Similar Threads

  1. Replies: 3
    Last Post: 11-17-2015, 04:21 PM
  2. Replies: 1
    Last Post: 05-20-2013, 01:45 PM
  3. Replies: 3
    Last Post: 12-02-2012, 12:59 AM
  4. Table Design -- want to avoid a design that creates blank fields
    By snowboarder234 in forum Database Design
    Replies: 4
    Last Post: 10-08-2012, 10:13 AM
  5. Create/Use/Design report templates
    By accessn00b2 in forum Reports
    Replies: 7
    Last Post: 09-11-2012, 11:28 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