One to Many relationship

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Gurney - 30 Jun 2004 18:20 GMT

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

Reply to this Message

John Vinson - 30 Jun 2004 20:55 GMT

>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

Reply to this Message