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?