Query!

southindian

suppose if i add a new field in customer table what are the changes that i need to do in nav database. what are the tables where i need to add this new field. can u please guide me.

Savatage

southindian wrote:

suppose if i add a new field in customer table what are the changes that i need to do in nav database. what are the tables where i need to add this new field. can u please guide me.

You seemed to answer you own question in your question.

southindian wrote:

what are the tables where i need to add this new field

southindian wrote:

add a new field in customer table

In customer table (18) insert a new field in the 50000+ range
give it a Field number (50000)
give it a field name (My New Field)
give it a datatype (TEXT) or whatever you are using it for(date, blob, decimal, etc)
give it a length (depending on type)
give it a description of what it;s for & when it was added

You can then add it to a form or page to view

mohana_cse06

May be you mean to ask how to flow the field to other tables like Sales Header etc?