[SOLVED]  Get Value From Lookup Table

This topic is locked

[SOLVED] Get Value From Lookup Table	2/4/2011 2:44:45 AM
PHPRunner General questions
L LarryM author I have the following Situation: The ProductNumber -----Looks up--->ProductName from the ProductsTable and displays it. This works fine. I also want to get the price of the selected Product from the Lookup table (products) as the default price. What is the best way to do this? I'm thinking since I'm already accessing the lookup table for the ProductName, I should somehow be able to get the price from the linked table into the default price field. I'm sure this has been asked before but I haven't been able to find it. Thanks


L	LarryM author 2/4/2011
	Well, I managed to solve my own question so I'll post the answer for the benefit of other newbies like me. I guess I should have read more but ....my first day with phpRunner, and lack of patience prevented me. It's really simple and slick! In the phpRunner Editor, I right click on Product Number that does the product lookup and click properties, same as I did to get the Product Name to display from the products table. Then the magic, click on AutoFill, and simple select the price on the left and right table and Wala! it works! The price just pops in when I add a new record and select the product number.