Lists

[lee_morgan]

Hey Guys,

Need a little help again . Fairly low level stuff I'm afraid! Basically I have a form that I am designing, the form is a log of a persons past pregnancies and dates etc and any problems experienced. However i have encountered a problem. As we know one person can have many pregnancies I'm having difficulty in being able to input all the dates of their pregancies into one field. Any ideas??

Basically I want the form to look sort of like this:

Date of Pregnancy/s: 12/05/99
13/04/00
16/09/02

babies weight: 40kg
56Kg
60Kg

 

[Crilen007]

You will have one table with people


tblPerson
PersonID (PK, Autonumber)
PersonFirstName (text)
PersonLastName (text)
PersonAge (Number)

Then another table with their dates

tblPregnancy
PregnancyID (PK, Autonumber)
PersonID (FK, Number)
ProblemID (FK, Number)
PregnancyDate (date/time)
Weight (number)

and one more table

tblProblem
ProblemID (PK, Autonumber)
Problem (text)


Create your form based on tblPerson

then add a subform (you will see this button in the toolbox)

Add, the subform based on tblPregnancy.

It will ask what fields to link on, choose PersonID in both fields.

Now they are linked.

When you add a person, you can add as many pregnancies as you want.

Now for the problem listing.

In the subform, add a listbox, and base it off tblProblem and it will ask what you want to link it to, choose ProblemID in both fields.

If you have any troubles let me know

 

[lee_morgan]

Will do... thought the solution might have been a subform

Thanks,

Lee

 

[Crilen007]

How did it work out?