How to store data many row in one table

dododo's Avatar, Join Date: Jun 2011
Newbie Member
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
0
dododo's Avatar, Join Date: Jun 2011
Newbie Member
here is image file: ww.postimage.org/image/2pee9ckzo/
0
alssadi's Avatar
Banned
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 like this
0
dododo's Avatar, Join Date: Jun 2011
Newbie Member
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.
0
alssadi's Avatar
Banned
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.
0
alssadi's Avatar
Banned
oops im sorry i have just noticed that you post it on MS access database
0
alssadi's Avatar
Banned
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 like this