One to Many relationship

Does anyone know if it is possible to create a subform on
a form such that the ONE TO MANY relationship checks on
two sets of related fields.eg where you have families
with children and the father is the related link and
there is more than one father named for example John, but
the wife of each John has a different name

On Wed, 30 Jun 2004 10:20:19 -0700, "Richard Gurney"
wrote:

Does anyone know if it is possible to create a subform on
a form such that the ONE TO MANY relationship checks on
two sets of related fields.eg where you have families
with children and the father is the related link and
there is more than one father named for example John, but
the wife of each John has a different name

Yes - you can put *up to ten* fields in the Master Link Field and
Child Link Field properties of a subform, separated by semicolons.

I would, however, NOT recommend ever using people's names as linking
fields. There are many people named John (I'm one); there are even
multiple people named John Vinson (I met one in a local garage, I was
waiting to pick up my car and the owner called out "John Vinson's car
is ready" and a tourist passing through said "that was quick, I just
drove in!")

You should have some sort of unique personID and link on it.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public