How to store data many row in one table

Discussion in 'MS Access' started by dododo, Jun 24, 2011.

  1. dododo

    dododo New Member

    Joined:
    Jun 24, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    I want to use access to store and display data many rows as the file i attached so please see attachment file.


    postimage.org/image/2pee9ckzo

    *PerpetratorName field can input more than one. How to do store data and display data in control use Ms. Access. What control to use to enter many data? Please help or attach this code in access for me. Thanks so much
     
  2. dododo

    dododo New Member

    Joined:
    Jun 24, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    here is image file: ww.postimage.org/image/2pee9ckzo/
     
  3. alssadi

    alssadi Banned

    Joined:
    Dec 11, 2010
    Messages:
    41
    Likes Received:
    3
    Trophy Points:
    0
    Occupation:
    Creative director & web developer
    Location:
    Dubai
    Home Page:
    http://uaeinfographics.blogspot.com/
    if you only need to store data and save it , in order to get back to it later
    you need to create a database, sketch up what you need first , the first look of your application design
    is one of the first perspective of an affective program.

    ex of the database table names

    Name_Victim
    Age_Victim
    Sex_Victim
    Perpetrator_Name
    Age_Perpetrator
    Sex_Perpetrator
     
    shabbir likes this.
  4. dododo

    dododo New Member

    Joined:
    Jun 24, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    Thank you so much. I want to create database to store that data.

    I want to create one form that i can enter name of victim and name of perpetrator as the name of perpetrator can 1 or more than 1. What control should i use to enter many line of data and save into table? and how can i display data if name of pepetrator can more than 1 and name of victim only 1.

    Please you make that form and attach to me.
     
  5. alssadi

    alssadi Banned

    Joined:
    Dec 11, 2010
    Messages:
    41
    Likes Received:
    3
    Trophy Points:
    0
    Occupation:
    Creative director & web developer
    Location:
    Dubai
    Home Page:
    http://uaeinfographics.blogspot.com/
    hi there , you most welcome :)
    would you mind please to tell me what kind of database software your using , and do you have any idea background about database engine.
     
  6. alssadi

    alssadi Banned

    Joined:
    Dec 11, 2010
    Messages:
    41
    Likes Received:
    3
    Trophy Points:
    0
    Occupation:
    Creative director & web developer
    Location:
    Dubai
    Home Page:
    http://uaeinfographics.blogspot.com/
    oops im sorry i have just noticed that you post it on MS access database :)
     
  7. alssadi

    alssadi Banned

    Joined:
    Dec 11, 2010
    Messages:
    41
    Likes Received:
    3
    Trophy Points:
    0
    Occupation:
    Creative director & web developer
    Location:
    Dubai
    Home Page:
    http://uaeinfographics.blogspot.com/
    well you will need to create two tables and create a relationship between them

    first table will be :

    Name_Victim
    Age_Victim
    Sex_Victim

    Second table will be :

    Perpetrator_Name
    Age_Perpetrator
    Sex_Perpetrator

    where they have to be connected to a unique ID between both of the tables ( its very important )
    in order to make relationship between both of the table you need to create a unique identifier to both tables ;)

    hope that helps
     
    shabbir likes this.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice