MS Access 2008 Help

[sbas]

Hello,
I am trying to create a report on access from Table.
However, I would be using more that one table for creating the report. I
will have a one main table. And then I will have many sub-tables. Each
subtable is different for each ID of the main table. Is there a way to link
the ID of the main table to the ID of the sub-table even if they are
different for each ID. I tried the inserting subform/subreport feature. but
it wont be unique for each ID.
I also tried inserting excel file by inserting object. But I wont be able to
run queries. Need some advice. Thanks

 

[John W. Vinson]

Hello,
I am trying to create a report on access from Table.
However, I would be using more that one table for creating the report. I
will have a one main table. And then I will have many sub-tables. Each
subtable is different for each ID of the main table.

Do you in fact have a DIFFERENT TABLE for each ID!? If so your database design
is simply *wrong*. You don't need a different table for each ID, just a single
related table with the ID as a foreign key.

Is there a way to link
the ID of the main table to the ID of the sub-table even if they are
different for each ID. I tried the inserting subform/subreport feature. but
it wont be unique for each ID.

Sure it will, if you have *one* child table with the ID as a foreign key; set
the Subreport's Master and Child Link Field property to the ID. The subreport
will display only the associated records.

I also tried inserting excel file by inserting object. But I wont be able to
run queries. Need some advice. Thanks

Can't help you there... sorry...