Transffernig data.

[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

 

[Allen Browne]

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.

 

[Steve Schapel]

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

 

[Sailor]

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