Relationship Will Not Delete

  • Thread starter Thread starter ILoveAccess via AccessMonster.com
  • Start date Start date
I

ILoveAccess via AccessMonster.com

I created 3 tables with the following fields:

tblSports
SportID (primary key, autonumber)

tblPlayers
PlayerID (primary key, autonumber)
PlayerNo (number)

tblTeams
TeamNo (number)

Then I created 3 forms from these 3 tables:

frmSports (main form)
frmPlayers (subform of frmSports, linked by SportID and PlayerNo)
frmTeams (subform of frmPlayers, linked by PlayerNo and TeamNo)

My issue is, I corrected the linking of frmTeams in the relationships
window and the form property fields to:

frmTeams (subform of frmPlayers, linked by PlayerID and TeamNo)

but the actual linking won't change. The design views look fine, but
not the normal views. frmTeams is still linking to PlayerNo, which is linked
to SportID. So, it's like frmTeams is actually relating to SportID instead
of PlayerID.

Please Help!!
 
but the actual linking won't change. The design views look fine, but
not the normal views. frmTeams is still linking to PlayerNo, which is linked
to SportID. So, it's like frmTeams is actually relating to SportID instead
of PlayerID.
Click to expand...

Check the Master Link Field and Child Link Field properties of the
subform.

John W. Vinson[MVP]
 
Back
Top