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
NAV 2013 R2. TableRelation to a compound key.
delaghetto
Member Posts: 89
Hi!
I'm trying to create a new field "product subgroup" in the Item table.
So in NAV we have Item Categories, and then we have Product groups, that are related with Item category code. The main key of Product groups is "Item Category Code,Code"
Now I create a new table called "subgroup", and I create the field "product group code".
The problem is that I can create the tablerelation to the product group's "code" field, but not to the key "Item Category Code,Code"
Does this mean I also have to create the "Item category" field in my "subgroup" table? or is there any workaround?
The idea is that when I take an item and fill in the Item Category and the Product Group, I only want to get the subgroups that belong to the selected Item category and product group.
I'm trying to create a new field "product subgroup" in the Item table.
So in NAV we have Item Categories, and then we have Product groups, that are related with Item category code. The main key of Product groups is "Item Category Code,Code"
Now I create a new table called "subgroup", and I create the field "product group code".
The problem is that I can create the tablerelation to the product group's "code" field, but not to the key "Item Category Code,Code"
Does this mean I also have to create the "Item category" field in my "subgroup" table? or is there any workaround?
The idea is that when I take an item and fill in the Item Category and the Product Group, I only want to get the subgroups that belong to the selected Item category and product group.
0
Comments
Peter