2. PHPRunner General questions
  3. Lookup from a Table
This topic is locked

Lookup from a Table

 		1/30/2011 7:21:56 PM
PHPRunner General questions
D
 dclabs author

I'am quite new to PHPRunner and I can't followup the above quote. I kindly want to know how to lookup from another table into my working table camp.

example: I have a main table "TabEmployee" including a department as a combo camp and another table "TabDepartment" with "desc_department" and "cod_deparment" camps how can I lookup the "TabDepartment.desc_department" into "TabEmployee.department" through select from the TabDepartment.desc_department camp.

Please kindly help with a simple code.

Thanks.
Sergey Kornilov admin 2/2/2011

Not sure I understand what "combo camp" is. Could you rephrase your question?
D
 		dclabs author 2/2/2011



Not sure I understand what "combo camp" is. Could you rephrase your question?


Thanks for your concern and interest, I'm sorry for this misunderstanding, I really mean a "combo field" of a different table from which I can select the exact field content into another field of my main table.
TABLE "A" containing 2 differente fields ("Cod1" and "Desc1")

TABLE "B" THE MAIN TABLE with fields "cod1", "desc1" etc.....

I want to insert into TABLE "B" field "desc1" selecting it from TABLE "A" field "desc1" the corrisponding field "cod1" in Table "B".
Hoped to have clearly explained better this time.

Thanks a lot.
romaldus 2/2/2011



Thanks for your concern and interest, I'm sorry for this misunderstanding, I really mean a "combo field" of a different table from which I can select the exact field content into another field of my main table.
TABLE "A" containing 2 differente fields ("Cod1" and "Desc1")

TABLE "B" THE MAIN TABLE with fields "cod1", "desc1" etc.....

I want to insert into TABLE "B" field "desc1" selecting it from TABLE "A" field "desc1" the corrisponding field "cod1" in Table "B".
Hoped to have clearly explained better this time.

Thanks a lot.


it's very easy. you can use autofill feature in PHPrunner <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=56205&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />