If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Table Values in a Form
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. |
#2
|
|||
|
|||
Multiple Table Values in a Form
BigJay@OPG wrote:
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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|