1 Reply Latest reply on Feb 16, 2012 9:50 AM by philmodjunk

    Relational Question

    mgxdigital

      Title

      Relational Question

      Post

      Hello, i have 2 databases: Products and Orders. In products, i have 2 options (sheet or roll). 

      I'm wanting to add a layout on orders that pulls in only the sheet products. I added the product table occurance to the orders database and related them via a field that pulls a 1 if hte item is a sheet (product side) and a boolean 1 (on the order side). When i make a layout and tell the layout setup to pull the records from my newly related products, it pulls all the items from products (roll and sheet) and not just the sheet items like i wanted. What am i doing wrong?

        • 1. Re: Relational Question
          philmodjunk

          You selected the New Products Table Occurrence in Layout Setup | Show Records from?

          If so, there's nothing in place to limit the records shown by the 1 or any other value. A relationship works from two table occurrences so this would work if your layout were based on orders and you placed a portal to the new products occurrence on your layout.

          If you want to base your layout on an occurrence of products, you don't need the new relationship to make this work. You can perform a find to limit the found set to only records of a specified type and this can be set to happen automatically when you first access the layout if you use the OnLayoutLoad script trigger.