Displaying one-to-many relationship results in a indexed table.

[Jose Antonio]

I'm working with two tables, one is an indexed table that
doesn't allow case repetition, and the other table is a
non-indexed table that links case-to-agreements and
contains repeated cases as they relate to more than one
agreement. My objective is to have the results of the
relationship between cases and agreements displyed in a
third table, indexed to not allow case repetition. I'm
aware that the establishment of a one-to-many relationship
between first and second tables is required and I set it
but I can't force the query to display its results in a
table structured with an index that doesn't allow case
repetition.

Any help will be appreciated.
Thanks.

 

[John Vinson]

My objective is to have the results of the
relationship between cases and agreements displyed in a
third table, indexed to not allow case repetition.

I'm not sure I understand. Why do you want to store the case and
agreement data redundantly? And in particular, if one case may have
many agreements, what does it mean to say "indexed to not allow case
repetition"? If you have eight agreements for a given case, what do
you want this table to contain?