I need insert the sama value in two tables, how?

Karvalho
Member Posts: 6
I everybody,
I have two tables table1 and table2, and when I insert a value in field field1 in table1 I want that value was automaticly inserted in field10in table2.
I think that's possibly but I don't know how do that. Somoene can help me?
Obs.: table1.field1 is primarykey and table2.field10 isn´t, that's metter?
Thank's in advance.
AC <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
I have two tables table1 and table2, and when I insert a value in field field1 in table1 I want that value was automaticly inserted in field10in table2.
I think that's possibly but I don't know how do that. Somoene can help me?
Obs.: table1.field1 is primarykey and table2.field10 isn´t, that's metter?
Thank's in advance.
AC <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" />
0
Comments
-
Hi,
you have many options to realize it.
1. Use a Flowfield.
If you classify Field 10 in Table2 as Flowfield, the Value is automatically the same.
2. Use the Triggers.
Field1 in Table is PrimaryKey, so use the RENAME or INSERT Triggers of the Table do modify the value in Field10.
Example:
INSERT TRIGGER
Table2.GET(...);
Table2.Field10 := Field1;
Table2.Modify;
Good Luck
Stefan
<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote0
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