How to display data from related table in textbox?

sejan
Member Posts: 2
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)?
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)?
0
Comments
-
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,
Seema0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions