I have two view tables "VTESTS" with column test_id, method_id, test_code & test_name and VMETHOD with column method_id & method in my current database "portal" from a separate database (TD) table "test" and table "method", respectively. Both databases are located on same server (localhost). Each test_name has two records with same test_id but two different method_id and test_code in VTESTS view table look like as below:
test_id, method_id, test_code, test_name (1510, 3, 876, TD and 1510, 1, 600, TD, respectively)
Now I have created a Form portal.test from portal.test table of my portal database which has the fields Method, Test and Code. Now I set Method field in my portal.test form as Lookup from method field of VMETHOD view table by following Phprunner Lookup wizard. Similarly, Test field in my portal.test form has setup as Lookup fld from the test_name of VTESTS view table with dependable dropdown list option of Method field. The Code field in my portal.test form has set as "autofill" with Test field on the form.
Now when I select Method and Test fields on my portal.test form then the Code field should "autofill" with data based on method_id and test_id from VTESTS view table, such as, if I select 3 as Method and TD as ¬Test then Code should be 876 and it should 600 for other case. However, I always get 600 as Code for both cases.
I tried to resolve this issue by following http://www.asprunner.com/forums/topic/21143-get-value-from-another-table-depending-from-main-field/pagehllookupfromsearch1 tips from phprunner forum, but I am not in any luck. Please help me. I am using phprunner7.0 enterprise ver.
I am using phprunner7.0 ver. Sorry for complex writing.