Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to link a field in a form to list/selection
marson
Member Posts: 9
Hi,
I have created a table name EQUIPMENTS with the following sample fields.
ID, TYPE, BRAND, CUSTODIAN, LOCATION, DESCRIPTION
Then i created a form for entering the values that includes all the fields above.
What i wanted to do is to be able to link the field CUSTODIAN to the CUSTOMER LIST so that i don't have to type in the values.
As for the BRAND I am planning to create a table where I can input all the brands and then link to this field for SELECTION.
Please see attached illustration.
Hope you can help me guys. Thank you very much and more power.
I have created a table name EQUIPMENTS with the following sample fields.
ID, TYPE, BRAND, CUSTODIAN, LOCATION, DESCRIPTION
Then i created a form for entering the values that includes all the fields above.
What i wanted to do is to be able to link the field CUSTODIAN to the CUSTOMER LIST so that i don't have to type in the values.
As for the BRAND I am planning to create a table where I can input all the brands and then link to this field for SELECTION.
Please see attached illustration.
Hope you can help me guys. Thank you very much and more power.
0
Comments
On your Custodian field you need to create a Table Relation to the Customer table, returning the No. field.
You can find the Table Relation property if you look at the properties of your Custodian field.
You will then see a lookup arrow on your field on your form as NAV will (as if by magic!) use the DefaultLookupForm that is set on the Customer table to present you with the Customer List.
Hope that helps.
Thank you very much, really appreciate the hep.
I was able to get it work though your suggestion.
Thanks again.
Ade
I created two new tables:
1. Equipment Table
- Equipment ID
- Name
- Serial
2. Equipment Log
- Equipment ID - Defined to be related with "Equipment Table"."Equipment ID"
- Date Reported
- Problem
When i try to click on the arrow up, I can't see the list of my Equipments from Equipment Table.
Am I missing something?
Regards,
You need to create a List form for the Equipment table. You then need to set this Form as the DefaultLookupFormID on the Equipment table. Then when a lookup is based on this relation it will display that lookup form.
This is all covered in the C/Side development guides and is pretty basic stuff. Have you had any training at all?