I want to populate data from one reference field to custom table fields ?

suresh40
Tera Contributor

HI All,

My requirement is I have a one  reference field(number) that is referring to another custom table , We have to display custom table records present table  field values .

My output is :

If i have select the number in reference field reaming data has to be populate itself.

 

Thanks,

Suresh.

6 REPLIES 6

-O-
Kilo Patron
Kilo Patron

Since you have a reference field, all you should do is to customize the form to include fields from the referenced table through the reference. Also called dot-walking. In theory all data in a relational database should exist only in one place. Copying it all over the place can only lead to inconsistency, where at some point the copied data gets out of sync with the original data. It also wastes space as no matter where you need it (reports, forms, code, etc.) just by "dot-walking" the reference you can get to the original data.

I'm assuming this is for a form and not a Catalog Item.

Gaurav Shirsat
Mega Sage

Hello

can you please tell, what records your 'u_test_items' and the table where you want to populate is keeping?

If you are getting Undefined as Populated that means your request from client to server is reaching but script include is not taking the appropriate record ID.

 

Please Mark Correct and Helpful
Thanks and Regards
Gaurav Shirsat