505
Dear All,
How to get Project Name and Customer Name both coming from ProjTable Datasource I added to ProjOnAccTrans Form. ProjID coming from ProjonAccTrans. There is a outerjoin link between these tables.
Case:
When create new record , while enter projid , project and Customer name should be shown.
IO know I have to write cod ein modified method of ProjonAccTrans DS. But what ?
Please se ebelow pic
*This post is locked for comments
nope. currently i added display methods in form to show project name .But i need searchable form field. "project Name " field was not added to projonAcctrans Table.
My question is How can write code like:
1. add a control " proj Name" in form.
2. in modified method of Proj ID control add code like :
ProjName form control = projTable.name (this.projid);
in form level
Can you be more clear ? have you added projectName in ProjAccOnTrans table or its unbound form control on your form? you have to tell us more information i.e. either both form controls are bound or unbound to datasource etc..
Share
Report
All responses (
Answers (
for example like this:
Public void getValues()
{
ProjTable projTable;
ProjOnAccTrans projOnAccTrans;
;
projTable = projTable::find(projOnAccTarns.ProjId);
projOnAccTrans.ProjectName = projTable.Name;
}
and call this method in your form Control modified() method after super().
You can do this by following:
1. Write a method on form in which you can make relation between your table and projTable and initialize fields from ProjTable.
2. call this method in you form control Modified() after super().
I want to write code in modified methof of projid form control where i will fetch value of projid and get name of proj and put it in Proj Name form control . Does ay one know how to code this on form level and not on Data source level or Table level.
I would say you need to write code in ProjOnAccTrans table method "initFromProjtable()" . It populates the fields on projOnAccTrans table from ProjTable by ProjId automatically.
for example, like this:
this.ProjectName == projTable.Name; // for getting project name
Note: I am assuming you have already added ProjectName field to ProjOnAccTrans table.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
