displayFormat (non-SQL programmer)

[Guitarzan]

Gretings,

I am combining data from two separate tables that join together via a common
ID. Table A has fewer records than Table B.

In the query, Table A is duplicating records in order to match the length of
records retrieved from Table B.

My question is, How can I keep Table A from duplicating its records in the
query? (I am not an SQL programmer, please help by providing steps using the
Query Design window.)

Thanks for your help!

Rick

 

[KARL DEWEY]

How can I keep Table A from duplicating its records in the query?
Ordinarily you can not. In a report you can hide the duplicates.

What is the maximum records in Table B for a record in Table A?

 

[Guitarzan]

Very small. Around 10 records in Table A and Table B has 33.

 

[Michael Conroy]

Rick, the basis of a relationship database program is to be able to get the
duplication in the one to many relationship you are describing. Normally,
this duplication is not a problem because you have the option of using groups
in a report to show the duplication once in a group header and all the
related records under it. Additionally you can filter a form by the
duplicated field which can be displayed once in a combo box in the header and
show all the related records in the detail. I hope this helps.

 

[Guitarzan]

Thank you Michael. The dilemma I have is that the end result appears in a
pivot chart instead of a report or form to create an interactive experience
where the end user can click and drag from a list of metrics to build their
chart.

Would you know how the "Hide Duplicates" would work within the pivot chart
created in the macro?