Populate Record From Template Values On Field Update

This topic is locked

Populate Record From Template Values On Field Update	3/1/2013 12:45:49 PM
PHPRunner General questions
S seedavidwork author I have two similar tables called bidscope and scope. Scope is a template of all the items I might sell with default values stored for each field (description, cost_sf, fabtime, fieldtime). bidscope is a table of items sold on a particular job with specifics for that job. I have field 'scope_type.bidscope' where I select a 'scope_id' from 'scope' (and display the scope_name). I want the template information from the selected record in table scope to populate the similar fields in bidscope as soon as I update the 'scope_type' field in the bidscope table. Ideally this would happen only when I update that field so I can make modifications to the default set in bidscope from scope as long as I don't change the field scope_type again. Thanks for any suggestions.


	Sergey Kornilov admin 3/1/2013
	It looks like you are looking for an 'Autofill' function. There is an option to apply autofill on the Edit page as well. See 'Autofill' section at http://xlinesoft.com/phprunner/docs/lookup_wizard.htm for more info.