Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 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 up a field to a form,by pressing the upper arrow
klinspatrick
Member Posts: 58
Hi,
i have a field named category in the table "New vendor for supplier", and i want it to link to other table\form by pressing the upper arrow, but when i press the upper arrow, it shows nothings and not open any form,
i have already set the "TableRelation" to other table named "Category belongs to vendor". it strange that after set the "TableRelation", the value field show it displays "Category belongs to Vendor", while i have learn or refer other field such as "country code", it can link to the table by pressing the upper arrow to the "countries" form,
the different between the "TableRelation" properties is the value shows Country and "Category belongs to Vendor", there is more " ".
i try to remove the " ", and save, it prompts "You cannot enter 'Category belongs to Vendor' in TableNo. The cursor is in front of the invalid character."
do you know anythings i haven't to do? and wrongly to do?
i have a field named category in the table "New vendor for supplier", and i want it to link to other table\form by pressing the upper arrow, but when i press the upper arrow, it shows nothings and not open any form,
i have already set the "TableRelation" to other table named "Category belongs to vendor". it strange that after set the "TableRelation", the value field show it displays "Category belongs to Vendor", while i have learn or refer other field such as "country code", it can link to the table by pressing the upper arrow to the "countries" form,
the different between the "TableRelation" properties is the value shows Country and "Category belongs to Vendor", there is more " ".
i try to remove the " ", and save, it prompts "You cannot enter 'Category belongs to Vendor' in TableNo. The cursor is in front of the invalid character."
do you know anythings i haven't to do? and wrongly to do?
0
Comments
well if you are trying to access any other table from via look up (upper arrow) all you have to do is to set the table relation & also make sure that the filed you are trying to set in a table relation must be included in the primary key of that relation
If you new table “Category belongs to vendor” only have one field in the primary key then the table relation can be either “Category belongs to vendor” or “Category belongs to vendor”.”Primary Key”.
If you have more than one field in the primary key then the table relation must be “Category belongs to vendor”.”Linked Field”
Regards
Claus
http://www.AcumenConsulting.co.nz
after i set the LookformID, it can link.
thanks.