Howdy, Stranger!
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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Asset # - changing them
rj5570
Member Posts: 157
right now we have a prefix like MU- or C20- and then our asset number.
i really want to blow those out of there. I was thinking of importing the table into access, remove the prefix and then load the table back into the database.
my question is, will this mess up any linkage from other tables? it looks to me that this wont work, so does anyone else have any other suggestions in how i can remove the prefix.
i really want to blow those out of there. I was thinking of importing the table into access, remove the prefix and then load the table back into the database.
my question is, will this mess up any linkage from other tables? it looks to me that this wont work, so does anyone else have any other suggestions in how i can remove the prefix.
- So it Goes.
0
Comments
Triggers must run to apply your renaming in other tables.
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
im not really sure how to do that.......to write a code unit that will populate ALL fields and tables