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