Rich,
You can have a report where it looks up the correct information to display, but the selection criteria is only going to be based on the product samples table where I am assuming you have the associated product id but not the product name. PRINT REPORTA WHERE PRODUCT_ID IN (SELECT PRODUCT_ID FROM PRODUCT_TBL WHERE PRODUCT_NAME = 'CANS') Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Rich Sikes Sent: Thursday, November 11, 2010 7:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - 7.6 Report "Where Builder" I'm having trouble running a report using the "Where Builder". I have two tables, one contains a product id and product name, the other contains various data for product samples. I use a db lookup combo box to select a product name when entering new sample info. The data is there when I run a report (complete) from the data table but I can't seem to select a specific product. I'm missing something? Thanks! Rich Sikes HV Steel
