Linking subform to subform

[josephbupe]

Hi,

I have an issue linking a subform (frmPerson_Crimes) to another subform (frmPerson_Crime_Notes).

On the first subform are crimes commited and the second subform shows details of each crime ( all details in one memo field). So the relationship is one crime to one crime note.

The tables are:

tblPerson_Crimes (PK=CrimeCommittedID)
tblPerson_Crime_Notes (PK=CrimeNotesID)

Am failing to link the two subforms using the subform wizard, so that i would just double-click the crime committed to make the frmPerson_Crime_Notes visible.

Please, help !

 

[YNWA]

Not my place for advice being a beginner but do you think it would be better to split tables into...

person table
crime table
crime notes table

1-many on person to crime as 1 person can commit many crimes, then crime table to crime notes table as a crime can have many note entries?