Multiple Table Values in a Form

[BigJay@OPG]

I have a table of CLIENTS, INCIDENTS, and PERPS. The issue is I can have
multiple incidents on a client from multiple perps. What I’m trying to do is
to create a record that would tell me what incident(s) was my client involved
in as well as perp(s) who were involved and what incidents that committed.
i.e. John Doe (perp) hit (incident) Jane Doe (client) Joe Blow (perp) slapped
(incident) Jane Doe (client). Because these incidents are related I want
them all in one record. Please tell me how to set this up in a user friendly
form view.

 

[Rick Brandt]

I have a table of CLIENTS, INCIDENTS, and PERPS. The issue is I can
have multiple incidents on a client from multiple perps. What I'm
trying to do is to create a record that would tell me what
incident(s) was my client involved in as well as perp(s) who were
involved and what incidents that committed. i.e. John Doe (perp) hit
(incident) Jane Doe (client) Joe Blow (perp) slapped (incident) Jane
Doe (client). Because these incidents are related I want them all in
one record. Please tell me how to set this up in a user friendly
form view.

Use a form with subforms.