4 Replies Latest reply on Sep 11, 2012 10:01 AM by erickaczmarczyk

    Relationship with two variables

    erickaczmarczyk

      Hi:

       

      I'm looking to setup a better way to display images on a record.

       

      The concept I have in mind is:

       

      One table for inventory, one table for images.

      I will place a portal on the inventory layout for the image related from the image table.

      I want the image to be related based upon either Field01 OR Field02 OR Both

       

      My reason to relate the images instead of inputting them in inventory is to be able to display more than one image per record without having more than one image field.

       

      I have it working on some level, but only when Field01 AND Field02 are matching, I want it to display the image when either are filled out.

       

      Thanks,

       

      -eric