Forms on multiple tables with yes/no entries

A

Arri

I'm new to Access and am having a terrible time "getting it to work". I have
two tables: a DataBank of names and an Affilitation table with yes/no fields
for "friend", "family", "busienss" etc. I would like to have them on one
data-entry form, but each time I combine them, the form refuses to present
any data. If I do NOT combine the tables on one form, they work fine.
 
J

John Vinson

I'm new to Access and am having a terrible time "getting it to work". I have
two tables: a DataBank of names and an Affilitation table with yes/no fields
for "friend", "family", "busienss" etc. I would like to have them on one
data-entry form, but each time I combine them, the form refuses to present
any data. If I do NOT combine the tables on one form, they work fine.
Click to expand...

You have a many (people) to many (affliations) relationship.

The proper way to store this uses THREE tables, not one:

People
PersonID
LastName
FirstName
(other bio data)

Affiliations
Affiliation <e.g. "Friend"> <Text, Primary Key>

PersonAffiliations
PersonID <link to People>
Affliation <link to Affiliations>

If a person has multiple affiliations, they will have multiple records
in this table. A continuous Subform is handy for entering this
information.

John W. Vinson[MVP]
 
A

Arri

thank you, thank you, thank you, thank you, thank you. . . . .

It never crossed my mind.
 
Top