How to print off the sub information in a linked table

[Stuart]

I have two tables, one is a table full of material for which i have a rpice
for and the 2nd is a table which is populated with subcompents which are
covered in the first table. I have created a unquie code so that each table
can be linked to show the main part, and the subcompoments for it.
I would like to do a report which would be able to show the main compoment
then below it the subcompments, but ever time i run a query it produces the
main compoment for each sub compoment with the price, makin the final report
multiple times off. is there a way to produce a query and report for this??

 

[Golfinray]

More than likely, your query is not set up correctly. Make sure you have set
a primary key for both tables and then go into tools/relationships and link
your tables. If they don't link properly, chances are you don't have the
primary key you need. Is your unique code the same for each table? If so, you
could probably link those. Also check the kind of join you have on the
tables. You can right click the line between the tables in your query and
change properties if necessary. Once your query works properly, you should be
able to create your form.

 

[Stuart]

Thanks for that but the problem is the code is unquie to the main compoment,
and the sub compoments are linked using the this code. Therefore there could
be multiple items with the same code, thus making primary key ineffective in
that table as it only allows unquie codes!!

 

[ASD]

I have two tables, one is a table full of material for which i have a
rpice
for and the 2nd is a table which is populated with subcompents which are
covered in the first table. I have created a unquie code so that each
table
can be linked to show the main part, and the subcompoments for it.
I would like to do a report which would be able to show the main compoment
then below it the subcompments, but ever time i run a query it produces
the
main compoment for each sub compoment with the price, makin the final
report
multiple times off. is there a way to produce a query and report for
this??