In general you should be able to add fields without causing a problem to your existing application. You may need to set the fields to allow nulls as your application may not initially put any values in these fields. You will need to modify your search and data entry screens if you want them to display the new fields.

I've seen some applications that expect the fields to be in a certain order (a bad practice, IMHO). If you think your application does this you'll be best off adding the fields to the end of the record rather than inserting them in the middle of the record.

>Will it harm the application if I add extra fields to the main table? Do I have to create a new data entry screen. Will I have to create new search screens. Note, the search screens do not modify the data in the main table, they just display it.