Method:Classic General Q&A

Re: Linking Three Tables

Method_Audisho — Thu, 02 Jul 2015 16:20:47 GMT

Hi James,

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

Cheers,

Audisho

Re: Linking Three Tables

jsautel — Thu, 02 Jul 2015 15:29:41 GMT

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

Re: Linking Three Tables

Method_Audisho — Thu, 25 Jun 2015 20:49:07 GMT

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

Linking Three Tables

jsautel — Thu, 25 Jun 2015 20:28:58 GMT

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!