I have a data model to record arrests for instance, as well as one to record Weapons recovered.
For each of these I have set them up to allow for Multiple Observations so if 4 people are arrested, we create one observation which then allows for the addition of 4 records to the one observation.
As part of the attributes that get listed either before or after the “Records” (ie only get listed once) I have an attribute that is a numerical attribute and is “No of Suspects Arrested”. The idea behind this is that I can create a Summary Query and get a report on how many people are arrested within a selected time frame.
I ran a query today to pull off the arrest stats for this year to date, and what I found is that it is taking that stats/ figure and adding to each of the individual record, so if we fill in an observation where there have been 4 people arrested by the names of Joe, James, Jack and Julie, then what it is doing is creating four observations one each for Joe, James, Jack and Julie and allocates the number of 4 suspects to EACH of their records. So if I create a Summary query and ask how many arrests were made, instead of giving me the correct answer of 4, it gives me 16 (4 listed to Joe’s record, 4 listed James, 4 listed to Jack and 4 listed to Julie). This obviously is creating incorrect records – the 4 should be linked to the incident and not to each of the individual records linked to the incident. Below are screengrabs to help explain what I am meaning:
Here you can see I have the No of Suspects ARRESTED as an Enter Once Only attribute and then the Records below that where each of the individuals (Joe, James, Jack and Julies ) information is then listed.
When I pull of a query on how many arrests, it should only list 4, but instead it now lists 4 to each of the listed records so suddenly there are 16 people arrested in this single incident and not 4. In my query, I have tried to play with different filters such as Observation Filter as opposed to Incident Filter, but it makes no changes at all and still gives the same result. As you see in the query above, it has done the same with all our incidents where more than 1 person has been arrested – so instead of stats of 10 people arrested, a summary query will give me a total of 34, which is a little incorrect 
Do you know if this is an error in how I have set up the Data Model and if so, how do I need to set it up to only count the 4 from the 1 incident and not make it 4 to the power of 4 or 3 to the power of 3 etc for each added record.
Please advise if this is a data model creation error and if so, how to correct it?