2 Replies Latest reply on Jan 8, 2009 12:48 AM by TomM

    Reports based on relational tables

    TomM

      Title

      Reports based on relational tables

      Post

      Hi there. I'm still quite new to this and I've got stuck on trying to construct a script to produce a report based on relational tables. I'll try to explain...

       

      In simple terms I have 2 tables; AccountManager and Sale.

       

      Each record in Sale is assigned to a single AccountManager.

       

      An AccountManager record has a name and an office (either UK or USA).

       

      I'm wanting to basically perform a find on all Sales that have come from, for example, the UK office. So I need to look at each Sale, look at the associated AccountManager and see if their office matches 'UK'.

       

      How would you go about something like this? I understand that I need to perform a find with multiple Requests, one for each AccountManager who's office is 'UK', but I need to populate these Requests with data (AccountManager::name) from a different table (AccountManager) to the one I wish to perform the search in (Sale).

       

      Might be a really simple solution, but I just cant get my head around it. Can you help?

       

      Thanks,

      Tom.