best way to administrate characteristics for items, customer

Rallnus
Rallnus Member Posts: 79
edited 2011-10-26 in NAV/Navision Classic Client
Hi,

from my point of view there are 3 different ways to administrate chacteristics for items, customers, vendors..

- extend the standard tables with new fields
- use dimensions
- create a new table to handle these characteristics

TableID No. characteristic value
27 4711 color red

What's your favorite?
Rallnus (Yamaha FJ1200 - '89 / 25th anniversary was great!)

Answers

  • kriki
    kriki Member, Moderator Posts: 9,135
    Depends on what you need to do with it.

    If it is a field that is used in a lot of places, best put it in the table.
    If it is a dimension for analytical purposes, best use dimensions.
    If it is a field that is only there because sometimes a user wants to take a look at it, use an extra table (the picture-field should have been like this).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories