Transffernig data.

  • Thread starter Thread starter Sailor
  • Start date Start date
S

Sailor

I have created a form that updates a database for trouble calls. In this
trouble call db I have created 4 different tables respective to its
departments. If someone submits a trouble call to the incorrect department,
the supervisor of that dept in-charge of his/her trouble calls can transfer
the trouble call to the correct department. I want to be able to do this
from my form. Does anyone have any suggestions?

Thanks,

Sailor
 
Instead of using 4 tables, use one table for all the calls, with an extra
field to indicate what the Department is.

Then changing the call to a different department is just a matter of
selecting a different department in the combo box of departments.
 
Sailor,

The best suggestion, I believe, is to not have a separate table for
each department. There would only be very rare and special
circumstances where such a design would be a good idea, and I don't
think it applies in your case. Instead, there should just be one
table, with a *field* to identify the department.

- Steve Schapel, Microsoft Access MVP
 
I thought about this in the beginning, but becuase of certain cercumstances
I have to have separate tables. Is there a way to do this otherwise?

Thanks,

Sailor
 
Back
Top