AnsweredAssumed Answered

Relational Question

Question asked by mgxdigital on Feb 16, 2012
Latest reply on Feb 16, 2012 by philmodjunk


Relational Question


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?