[SOLVED] Retrive checkbox from another table

This topic is locked

[SOLVED] Retrive checkbox from another table	1/6/2011 6:01:52 PM
PHPRunner General questions
F fastcooler author Hello, I'm evaluating PHPRunner demo: it is awesome program! I'm trying to perform this action, but with no luck: I created a table for products and a table for registration of these products by customers (I need to trace warranties of bought items). On products table I created a TINYINT field where I need to store if this product is obsolete or not. I would like that, when a customer registers one of these obsolete products, automatically appears a checkbox autofilled with product's table "obsolete" field (so filled or not filled). I don't know how to perform this task. I created a second "obsolete" field in "register" table, but I don't know how to link it to product's table "obsolete" field. Any ideas, please? Thanks in advance. Best Regards Fast

Mark as Solved Mark as not solved

2 replies


Z	Zxenop 1/7/2011
	You don't have to duplicate the field in the registration table, just use the 'Add table' button in the Query tab, choose your registration table, then join both both table (with a drag and drop) by the product id finaly select the obsolete field as an output But if the customers are registering the product from your website, remember you can filter the products with the obsolete field from the query tab


F	fastcooler author 1/7/2011
	You don't have to duplicate the field in the registration table, just use the 'Add table' button in the Query tab, choose your registration table, then join both both table (with a drag and drop) by the product id finaly select the obsolete field as an output But if the customers are registering the product from your website, remember you can filter the products with the obsolete field from the query tab F A N T A S T I C !!! Your suggestion solved completely! Many thanks! Fast

2 replies

Mark as Solved Reply