Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   How to store data many row in one table (http://www.go4expert.com/forums/store-data-row-table-t26131/)

dododo 24Jun2011 21:43

How to store data many row in one table
 
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

dododo 24Jun2011 21:44

Re: How to store data many row in one table
 
here is image file: ww.postimage.org/image/2pee9ckzo/

alssadi 25Jun2011 15:44

Re: How to store data many row in one table
 
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

dododo 25Jun2011 21:26

Re: How to store data many row in one table
 
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.

alssadi 29Jun2011 22:12

Re: How to store data many row in one table
 
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.

alssadi 29Jun2011 22:19

Re: How to store data many row in one table
 
oops im sorry i have just noticed that you post it on MS access database :)

alssadi 29Jun2011 23:15

Re: How to store data many row in one table
 
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


All times are GMT +5.5. The time now is 19:07.