I want to populate data from one reference field to custom table fields ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2021 09:52 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2021 01:59 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2021 09:26 PM
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