AnsweredAssumed Answered

Confused by simple Lookup

Question asked by darkenney on May 2, 2012
Latest reply on May 3, 2012 by darkenney


Confused by simple Lookup


Should be easy. My first table (products) has 7 fields: productID, colorID1, colorID2, colorID3, colorName1, colorName2, colorName3.

Second table (color_list) has two fields: colorID, colorName. When I enter a color ID in the colorID1 field of the products table, I would like colorName1 field to be populated with the correct name from looking into the color_list table.

I recall this being done with a straight forward Lookup in very old FileMaker. With the new relationship model, I am flummoxed.