MS Access 2008 Help

  • Thread starter Thread starter sbas
  • Start date Start date
S

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
 
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.
Click to expand...

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.
Click to expand...

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
Click to expand...

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