Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2010-04-06 : 07:50:08
|
| I have the following columns on my report which is based on table Surgeries:SurgeryID Name DateThe report works fine presently. But now I want to add the drugs used for each surgery. There is a table named Drugs_Used. Here is the table layout for Drug_Used:DrugIDSurgeryIDDrugUsedThe SurgeryID is the foreign key for the Surgery#. So there can be one or more rows in Drug_Used for each surgery. So I want to show my list of surgeries as it it now. But I want to be able to click a button or treeview button or something to display the drugs used. I am not sure if this should be a drilldown or subreport.Thanks,Bob |
|
|
|
|
|
Sub report or drilldown/