Method:Classic General Q&A

Re: Linking two custom tables

Anonymous — Thu, 15 Jul 2010 18:51:43 GMT

Hello,

That’s great news, thanks for letting me know.

Re: Linking two custom tables

savagejim — Thu, 15 Jul 2010 17:55:24 GMT

Amanda,

That worked. Did not realize there were a couple of duplicate records in the first table, which meant I could not set it as a unique field and add it as a drop down in the second table.

Thanks much!

Re: Linking two custom tables

Anonymous — Thu, 15 Jul 2010 16:11:10 GMT

Hi SavageJim,

You need to create an association between the tables before you can use the 'Add a Linked Field' option. So for instance, you have Table A and Table B, you then have to figure out something unique that links the two tables. For example, you can add a dropdown field to Table A, 'Full Name' that contains unique values. You now have created a relationship. At this point you can add a linked field. The following post contains another example, to help you understand how linked field works: http://www.methodintegration.com/cs/forums/p/381/1191.aspx#1191

Linking two custom tables

savagejim — Thu, 15 Jul 2010 06:24:58 GMT

I am trying to link two custom tables. When I go to "Add a Linked Field" from one of the tables, there is nothing in the pull down. I was expecting to see a list of the other table I could link to along with the fields. What am I doing wrong?