If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS Access 2008 Help
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 |
#2
|
|||
|
|||
MS Access 2008 Help
On Fri, 4 Apr 2008 12:20:01 -0700, sbas
wrote: 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... -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|