Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38

    What we enter in table 2 then automatically table 1 data will update

    Hellooo all


    I had problem...
    I have fields in main table like
    Roll no, maths,science,social,english sujects
    This main db data
    And I have one table1 like roll no, maths
    And I have one more table2 like roll no, science....
    If I I enter data in table1 then that data will reflect in main table means change in main table
    Please solve my problem

  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
    Perhaps a table(s) such as

    Student(RollNo,studentName,studentAddress.......)

    Course(CourseID, CourseTitle....)

    and a mapping/junction table/associative entity

    StudentTakesCourse (RollNo,CourseID)

    It would help you and readers if you described what you are trying to accomplish.
    Last edited by orange; 10-20-2017 at 07:04 AM.

  3. #3
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    I have one and only one main table...
    In that I have field like roll no, maths, physics,chemistry
    I have 30 subjects like that
    Based on this single table I created queries, forms,report for hall ticket and memos
    I want one table having fields like roll no, maths
    If I entered roll number and marks in that table then that data will change in main table

  4. #4
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    Actuvally in table2 I'm entering that roll number by using bar code scanner and entering marks of that roll no in concern subject
    I have code for bar code
    My problem is I enter the data in table 2 that data will change in main table

  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
    My best guess is that you have a problem with your data structure. But until you describe exactly what you have and what you need, all readers can do is guess. Please show us a jpg of your tables. You have to separate WHAT you are trying to do from HOW you do it in Access. Once readers clearly understand what, they will offer options/advice for how.

    Good luck.

  6. #6
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    Everything is clear here
    I have only one table that having roll number and 30 subjects
    I designed memos halltickets...
    Every thing perfectly working
    Just my plan is I want read student roll number by using bar code then after I'll enter student marks
    Mean user does not know which student marks it's belongs tooo, and every answer sheet contain bar code instead of roll number
    And I'll take input as roll no through bar code scanner in table2 and I'll enter marks
    Then what I entered in table2 that data will change in table1
    How to link these two tables
    What I entered in table 2 that will change in table1

  7. #7
    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
    ??Perhaps you could take 1 subject and lead us through your intended process and show us the steps. I don't understand your post.
    Everything is clear here
    --I'm sure it's clear to you, but we know nothing of you, your environment, your desired output...

  8. #8
    Join Date
    Apr 2017
    Posts
    1,673
    You don't need a second table - you need a form instead, with a field to read in the bar code and then navigating to right student row without displaying any personal info.

  9. #9
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    Yaaa I tried with form
    I created field roll no in form
    But all roll no's that are table are displayed
    Actually in that field I need to enter roll number through bar code scanner, and I need to enter marks in subject fields
    Means in the form subject, and roll no appear empty in that I need to write then that reflects on main table

  10. #10
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    Anybody guide me
    How to dooo

  11. #11
    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

  12. #12
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    It's my plan
    I need one table or form
    If I entered roll no and subject marks that will change in main table I need code from all of u

  13. #13
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    This flow chart of my plan

  14. #14
    TskcAccessdev is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    38
    Click image for larger version. 

Name:	1508511446335763033872.jpg 
Views:	5 
Size:	99.8 KB 
ID:	30885 this is my flow chart means plan

  15. #15
    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
    If you want help, you're going to have to provide more info.

    Update: I just saw your attached photo after I submitted my post.

    It sounds like you are trying to "hide the identity of the students" and use only a roll-no to present/store marks for each subject/course.
    That would indicate that somewhere in your set up you will need a table/file to relate rollNo to person/student.


    To me you are working in spreadsheet mode, and Access tables are quite different.

    The form and process really depends on how you intend to enter data.

    If you have a form with this sort of shape for data entry

    Code:
    RollNo  Maths  Physics  CA  Social  History Geography
    You'll have to process it to put data into normalized Access tables (similar to those I mentioned in post #2.

    Good luck.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-12-2016, 06:11 AM
  2. Replies: 2
    Last Post: 04-15-2015, 10:05 AM
  3. Replies: 1
    Last Post: 12-14-2014, 03:16 PM
  4. Automatically enter email address from customer table
    By Pure Salt in forum Import/Export Data
    Replies: 3
    Last Post: 07-09-2014, 08:03 AM
  5. Replies: 10
    Last Post: 08-09-2012, 01:07 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