Multi-division application

[Len]

I have an application that runs for one division. Now I need to extend it to
run on milti-division basis. So, I added to each table division code and at
the start of the application make selection of division. The question is
what the most efficient way will be to transform form and report
recordsources to handle multi-division environment?

Thanks.

 

[John W. Vinson]

I have an application that runs for one division. Now I need to extend it to
run on milti-division basis. So, I added to each table division code and at
the start of the application make selection of division. The question is
what the most efficient way will be to transform form and report
recordsources to handle multi-division environment?

Thanks.

Well, that depends entirely on how you have the database set up and where
those recordsources are defined. If the forms and reports are based on Tables,
then the new field should be included automatically. If, more likely, they are
based on queries (either stored queries that you created or SQL statements in
the form/report's Recordsource property), then you're probably best off going
in and manually correcting the query.

I don't think it's going to be easy to automate this, though if someone has a
clever suggestion I'm all ears!

John W. Vinson [MVP]