RElatinship from one to many

  • Thread starter Thread starter Simon Yee
  • Start date Start date
S

Simon Yee

Hi, How Do I make a relationship from one to many.

like

1. Family head to son and daughter?

Thanks
 
Simon,
This question is just too "broad" to be answered in a newsgroup/email
environment. It would probably take a responder several pages to cover the
concept of One to Many Relationships.

Please see "one-to-many relationships" in Help.

Specific questions, with details, are your best bet for a response...
hth
Al Camp
 
Hi, How Do I make a relationship from one to many.

like

1. Family head to son and daughter?

Thanks
Click to expand...

Use a Form for the "one" side of the relationship, with a Subform for
the "many". The "one" side table should have a unique FamilyID (*not*
a name since names are not unique), and the Subform should be based on
a table with a "foreign key" field of the same datatype. The Subform
control would have FamilyID as the Master and Child Link Field
property.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Why do I get this error ?

Relationship must be on the same number of fields with the same data types.

How to solve it ?
 
Why do I get this error ?

Relationship must be on the same number of fields with the same data types.
Click to expand...

By joining two tables using either a different number of fields, or
trying to join two fields of different datatypes - such as joining an
Integer to a Text field.
How to solve it ?
Click to expand...

Join on a single field or several fields, joining fields of the same
datatype.

One possible problem: if you have Lookup fields in your table and try
to join two tables joining by a Lookup field, it won't work as you
expect. The Lookup misfeature CONCEALS the actual content of your
database (usually a Long Integer ID field) - it *looks* like you have
Text but you don't.

What field are you trying to join? WHat field are you joining it to?
What are the datatypes of these fields?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top