Hello,

I'm trying to figure out the concept of embedding subforms into main forms.
I have main tables, 4 junction tables, and a few look-up tables (not all
look-ups are listed below). If I'm reading it correctly, the junction tables
which relate to the main tables should be in the form of a subform placed
within the main form they relate to? I'm lost on the fact that I believe I
have a subform which appears should be on another subform which should then
be on a form. If this is correct, the form looks extremely busy and not user
friendly, and just plain incorrect. Is it true, based on the relationships,
that the PK and FK on the related tables should be joined between the subform
and main form?

These are the tables I have:

TblIncident
IncidentnumberID (PK)
misc. fields

TblSuspect
SuspectID (PK)
misc. fields

TblOfficer
OfficerBadgeNumberID (PK)
OfficerLastName
OfficerFirstName

TblIncidentOfficer
IncidentOfficerID (PK)
IncidentNumberID (FK)
OfficerBadgeNumberID (FK)

TblIncidentSuspect
IncidentSuspectID (PK)
IncidentNumberID (FK)
SuspectID (FK)

TblIncidentSuspectCharges
IncidentSuspectChargesID (PK)
IncidentSuspectID (FK)
ChargesID (FK)

TblForceUsed
ForceUsedID (PK)
OfficerBadgeNumber (FK)
TypeofForceID (FK)

TblCharges
ChargesID (PK)
Charges

Thanks in advance for any assistance.