Method Community

 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?

 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

 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!

 Hello,

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