How to display data from related table in textbox?

sejan

Hello everybody.

I'm developing simple CRM system in Navision Attain 3.10. I hope that someone can help me to do following task.

I have a Form with data from the table Companies in my database. It looks like that.

CompanyID | Name | Address | City | Phone no. |
*****************************************************
0001 | Intercars | Warynski st. 23 | Warsaw | 3244324 |


On this Form, I would like to display in the textbox a name of a representative person for each company. The data for representatives is stored in another table named Representatives. I set relationship between table Companies and Representatives. In table Representatives there is a foreign key (CompanyID) from table Companies. How to display in a textbox a data from Representatives table, which has a relationship with the table Companies(linked with Form)?

seema

Hi Sejan,

You can create a global variable of text type and on event onaftergetcurrrecord of that form you can fetch the value of contact person into that global variable from another table on basis of compnay id. And sourceexpression of that textbox must be this global variable.

I hope this will help you.

Regards,
Seema