Hello all,
I have a Form who has two fields namely 'ID' and 'Name'.
The table, which is the datasource of the Form, already has values corresponding to these fields.
In the form when I select the value in ID field, the corresponding Name value should automatically get populated in the Name field.
Will creating an autolookup help ?
Should I write any code ? If yes, where ?
Thanks a lot !!
*This post is locked for comments
You said that "the table, which is the datasource of the Form, already has values corresponding to these fields". So why would you populate them if they're already there. It seems that you forgot to tell us something.
I would assume that you have two tables - one used as form DS (T1) and another containing the data (T2). You want select an ID from T2 and copy both ID and name from T2 to T1. Please confirm my assumption. If it's correct, why didn't you said that by yourself? You didn't say even that you have two tables.
Hi Raghav,
I suggest you add the code on the modifiedfield() method on the table.
Below is a sample:
public void modifiedField(FieldId _fieldId)
{
super(_fieldId);
switch(_fieldId)
{
case fieldNum(MyTable,ID):
//query to get name
this.Name = 'ABC';//Load value from query here
break;
}
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (