Victor - You could also create a one-table view on Table 2, using an alias name for POItemID as `ItemID` and then the sub-reports feature will link on this column name.
Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Victor Timmons Sent: Wednesday, November 09, 2005 1:31 PM To: RBG7-L Mailing List Subject: [RBG7-L] - SV: Sub Reports Yes you understood just fine. I was kind of hoping I wouldn't have to do that. Thats ok. Thank you On 9 Nov 2005 at 20:21, Gunnar Ekblad wrote: > Victor > If I understand your question, create a view linking to the 2 columns > And then run the report from the view > > Gunnar Ekblad > > > -----Ursprungligt meddelande----- > Från: [email protected] [mailto:[EMAIL PROTECTED] För Victor Timmons > Skickat: den 9 november 2005 20:12 > Till: RBG7-L Mailing List > Ämne: [RBG7-L] - Sub Reports > > This is my first attempt at a subreport so forgive me if this has been > asked before > > I have a Report with 2 tables > Table 1 has a column called "ItemID" > Table 2 has a column called "POItemID" > > Is there a way to link those 2 column together. > > Victor Timmons > Tiz's Door Sales, Inc > 425-258-2391 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
