Method:Classic General Q&A

Re: creating a relationship between tables

Method_Russell — Fri, 16 May 2014 15:05:12 GMT

Hi Guy,

The HTML editor on this forum can be a little tricky. I fixed your embedded image, just had to change the URL from imgur.com/GnsQctL to i.imgur.com/GnsQctL.png.

Regarding your issue, I see what you mean. Instead of adding a linked field, can you add a new field? You can add a dropdown to an existing table, and select the CustomerEquipment table, and Name for the text field. Then you should be able to add the field to your screens.

Please let me know if you have any questions about this.

-Russell

Re: creating a relationship between tables

guy — Fri, 16 May 2014 01:09:20 GMT

Yes we do have pro and fieldservice. this is my screenshot of the dropdown box.

Re: creating a relationship between tables

Method_Russell — Thu, 15 May 2014 13:50:10 GMT

Hi Guy,

Can you confirm that you have the Field Services app installed in your Method account?

Can you also post or link to a screenshot of the linked field options you have in the Activity table? (you can use a free image hosting site such as imgur.com) For example, this is what I have:

-Russell

Re: creating a relationship between tables

guy — Thu, 15 May 2014 00:31:45 GMT

Yes we do have Method CRM Pro.

I did what you said went to Customize > Tables/Fields > Activity. Select "Add a Linked Field", but there is no Link to CustomerEquipment in the drop down box.

Also went to field service Customize > Tables/Fields > Activity. Select "Add a Linked Field", but there is no Link to CustomerEquipment in the drop down box under the field service.

Re: creating a relationship between tables

Method_Russell — Wed, 14 May 2014 20:09:03 GMT

Hi Guy,

CustomerEquipment is a table from the Field Services app (available with Method CRM Pro only), do you have this app installed? If you have a Pro account, you can install the Field Services app through Customize > My Account. Please see http://www.methodintegration.com/method/kb.aspx?folder=methodcrm&article=Field-Services-Overview&id=222 for more details.

If you have it installed, I'll walk you through the process. Please edit the Activity table by going to Customize > Tables/Fields > Activity. Select "Add a Linked Field", Link Using CustomerEquipment, and then select the linked field you would like to display (for example Name). Then to add the field to a screen, you would drag the new field onto a section while editing the screen.

If you have questions about any of this please let me know.

-Russell

creating a relationship between tables

guy — Wed, 14 May 2014 01:19:54 GMT

Trying to create a relationship between customer equipment table and activity table. I have tried doing what was posted in the forum by anonymous. But the customer equipment is not in the drop-down box.