Hi,
My query is thus,
I have two database tables linked together by a single field called 'ID'. In the design view in the details section I have placed a few fields from the first table(table1) and a field from the second table(table2). However, since there can be many second tables for each first table (one-to-many relationship), the ID's that I placed in the details section are repeated more than once.
i.e
ID magoo
== =====
356 yes
356 no
356 maybe
356 yes
21 no
21 no
21 maybe
How can I get it so that just one ID of whichever number is displayed?
ie (like this)
ID
==
356
21
...
...and so on
I also have a bar chart set up that is based on some of the values displayed in the table. I have total values displayed at the top of each bar on the chart.
when there isnt a field from table2 in the details section, the values on the bars in the chart would be:
4, 7, 6, 3, 5
but when i do place a field from table2 in the details section, the values on the bars in the chart would be:
9, 16, 12,9,11.
Cheers,
J