I am creating a Security Incident Report database in Access2000.
I have been working on this database for approximately two weeks now and I finally have all the bugs worked out of the forms and tables and relationships, they all work great now. My problem now is that incident reports can have multiple parties involved with them.
I have linked my PartyInfo table to SIR (main table stands for Security Incident Report)and have all the relationships correct. In the party info the Primary key is PartyID which uniquely identifies each party. Also there is a foreign key called ReportID.
When a party member is filled out in the PartyInfo subform (which is a subform of form SIR) the particular record that the parties were involved in is recorded in the ReportID field on the PartyInfo table as well as the SIR table.
I need to have a report so that when I call it up It has all the report details as well as all party members with that ReportID.
I am having trouble with this, as this is the first time I have had to cross reference two keys from two tables that did not have an equal amount of records. Am I going to have to base this off a query? Or am I just going about everything all wrong? and if its the query thing how? I am terrible with queries. (Thats the main reason it took me two weeks and not one)
Thank you for your time,
Neowynds
I have been working on this database for approximately two weeks now and I finally have all the bugs worked out of the forms and tables and relationships, they all work great now. My problem now is that incident reports can have multiple parties involved with them.
I have linked my PartyInfo table to SIR (main table stands for Security Incident Report)and have all the relationships correct. In the party info the Primary key is PartyID which uniquely identifies each party. Also there is a foreign key called ReportID.
When a party member is filled out in the PartyInfo subform (which is a subform of form SIR) the particular record that the parties were involved in is recorded in the ReportID field on the PartyInfo table as well as the SIR table.
I need to have a report so that when I call it up It has all the report details as well as all party members with that ReportID.
I am having trouble with this, as this is the first time I have had to cross reference two keys from two tables that did not have an equal amount of records. Am I going to have to base this off a query? Or am I just going about everything all wrong? and if its the query thing how? I am terrible with queries. (Thats the main reason it took me two weeks and not one)
Thank you for your time,
Neowynds