Can't create a One to Many relationship

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables and I can't make a 1 to many relationship.
Everytime I create a new relationship, access doesn't give the option for
One to Many. I have tried to use enforce ref entegrity and it doesn't change
anything. Table 1 has an AutoNo. for its Primary Key. Table 2 has a number
for the Foreign Key.

What am I missing?
 
I have 2 tables and I can't make a 1 to many relationship.
Everytime I create a new relationship, access doesn't give the option for
One to Many. I have tried to use enforce ref entegrity and it doesn't change
anything. Table 1 has an AutoNo. for its Primary Key. Table 2 has a number
for the Foreign Key.

What am I missing?
Click to expand...

Is the referential integrity button greyed out? Do you get only one to
one relationships, or only indefinite relationships? If it's only
giving you one to one, that means that the foreign key field has a
unique Index (which you *don't* want).

The indexes might be messed up. Try opening the "one" side table;
remove the Primary Key; open the Indexes menu (the icon looks like
lightning hitting a datasheet) and delete all indexes. Compact the
database, then reestablish the primary key and re-index any fields
that need indexing.

John W. Vinson[MVP]
 
Back
Top