Two ?s: Automatic fields and Hiding Duplicates

[Ruby]

Hello, here's what I want to achieve, but am having trouble getting there:

I have created my Tables and the Form that I want my client to use. The
database will be listing people's names, dates of services, and specific info
related to each date of service. I would like a one-page Form to input info
into.

QUESTION #1: I want to be able to input person's name one time so that the
person's name and other demographic info will be brought up automatically.

Example:

ENTRY 1:
ID #: 001
Name: Doe, John A.
DOB: 01/01/1960
DOS: 10/05/2007
Other fields are available to select specific info from related to this DOS

ENTRY 2:
ID #: 001
Name: Doe, John A. (automatically appears when ID # 001 is selected)
DOB: 01/01/1960 (automatically appears when ID # 001 is selected)
DOS: 10/15/2007
Other fields are available to select specific info from related to this DOS

QUESTION #2: I want to be able to print a list of each name with a list of
that person's date of services and their respective details. Is this
possible?

Example:

ID #: 001
Name: Doe, John A.
DOB: 01/01/1960
DOS:
10/05/2007
- details of service (this info is from the other fields mentioned
above)
10/15/2007
- details of service (this info is from the other fields mentioned
above)


Hope someone can help me out. Thank you!!!

 

[Ruby]

EDIT to QUESTION #2: I don't want to print duplicate names... just one name
with the person's respective date of services and details.

Thank you!

 

[Jerry Whittle]

#1. You have two tables (at least). One has information about the person
including their ID# as the primary key. The second table has their service
information. One of its fields is also ID# which will be the foriegn key
field. You join the ID# in the first table with ID# in the second table so
that you can display all the information as needed in forms and reports.

The best way to do this in a form is have a main form based on the Person
and on it a subform based on Service.

If this doesn't make any sense, you might want to set back from the
keyboard. I highly recommend getting some relational database training or
reading "Database Design for Mere Mortals" by Hernandez before proceeding any
further on this database.