Thanks Steve, I'm a little new to 7.6. I'm trying to do this in the application designer as an action. The where builder in the print reports there only shows one table, not the product table. Maybe I didn't need another table? The info does transfer to a column in the main table though. I did this so they could use the drop down for selecting product names (avoid typo's). Thanks ...
________________________________ From: Steve Vellella <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, November 11, 2010 10:46:18 AM Subject: [RBASE-L] - RE: 7.6 Report "Where Builder" 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
