8 Replies Latest reply on Mar 11, 2013 6:22 AM by PaulaS

    one-sided relationship?



      one-sided relationship?


           This seems really basic but I truly don't understand. I have a file with two tables; Product Descriptions and Brand Abbreviations. My Product Descriptions table has a field called "Brand Name" that's linked to the Brand Abbreviations table through the Abbreviations::Brand field. What I want to happen is for the Brand Abbreviation to link to the Description record through the Brand name link.

           Descriptions::Brand Name = Abbreviations::Brand

           The relationship works in that, if I go to a Brand Abbreviations-based layout, I see the Descriptions::Brand Name linked appropriately. However if I go to the descriptions-based layout, the Abbreviations field (from the Brand Abbreviations table) shows nothing.

           Any thoughts how to get the Abbreviation into my Descriptions layout?