Method Community

 

Linking Three Tables

Last post 07-02-2015 11:20 AM by Method_Audisho. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-25-2015 3:28 PM

    Linking Three Tables

    Hi Method!

    We currently are developing a commission screen in Method. The process is done by linking the Activity Table (Work Orders) to a Commission Table. In our current report right now, the cost of the total items is displayed. However we want to be able to display each item per work order. So I need to some how need to be able to link the Commission Table to the ActiviyJobItems Table so I can display the Items per Work Order Number. Sorry if this isn't the clearest.

    Thanks!

  • 06-25-2015 3:49 PM In reply to

    Re: Linking Three Tables

    Hi jsautel,

    I’m not sure I understand what you’ve built and what you’re trying to add or change. Is this a screen or a report? Do you think you could include a screenshot of what you have and do your best to explain what you’re trying to add and or change about the image?

    Thanks,

    Audisho

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 07-02-2015 10:29 AM In reply to

    Re: Linking Three Tables

    Audisho!

    I looked around the Forum, and actually found a scenario very similar to mine. Thanks for all the help that you provide at Method:CRM.

    Thanks,

    James

  • 07-02-2015 11:20 AM In reply to

    Re: Linking Three Tables

    Hi James,

    Glad to hear you figured it out and we are always happy to help! Big Smile

    Cheers,

    Audisho

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (4 items)