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.