Table relation

awatharam86
Member Posts: 49
Hi Friends,
How if we want to create a new table which primary key same as other table. for example my new table, should show primary key field same as Item table. So whenever Im running my new table, it should show primary key field same as item table automatically. And other records value will get from flowfield from other table basic from primary key value.
Please Help.
Thanks in advance.
How if we want to create a new table which primary key same as other table. for example my new table, should show primary key field same as Item table. So whenever Im running my new table, it should show primary key field same as item table automatically. And other records value will get from flowfield from other table basic from primary key value.
Please Help.
Thanks in advance.
0
Comments
-
You need to create the records in your new table based on the OnInsert triggger of the item table. You can't use a flowfield as primary key."Money is likewise the greatest chance and the greatest scourge of mankind."0
-
ok gotcha.... thank u friend.0
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