Solved SQL queries update impact over existing forms (1 Viewer)

[Alt]

Several guys are forced to update several queries (mostly for new fields) and I wonder if we must create forms again OR if there's a way to update existing forms.

 

[June7]

Edit design of forms and reports and code.

Why are new fields added?

 

[Alt]

Some add several new fields into the SQL server and also add those fields into existing SQL queries.

It's becoming a pain to always revise forms when this occur.

 

[June7]

Why do fields have to be added? If this is a recurring periodic event then something is wrong with data structure.

 

[Gasman]

Several guys are forced to update several queries (mostly for new fields) and I wonder if we must create forms again OR if there's a way to update existing forms.

Just add the new fields to the form ?
Plus of course any other associated code required for them?

 

[Pat Hartman]

As the others have said. If this is a one time problem, just change the queries and the forms and move on. If this is a repeating group that you keep adding to and this is a recurring problem, Then you should fix the problem by getting rid of the repeating group and properly normalizing the schema.