many of you were kind enough to suffer along with me on my first foxpro project last month. well, now that it's implemented it's easy to see where improvement is needed, however other departments want to use the same application. not anticipating this i now need to make changes to the application. my questions are as follows:

1) since each department could use the same tables, what would be the best way to restrict access by department?, ie. should i add a field to the table as a departmental identifier such as ADMIN, FINANCE, HR, and base access on the department or should i create a separate table for each department?

2) anytime i make changes to the application (for example form mods) do i need to totally recreate and redistribute the application or do i just install the new form?

3) what is the best way to apply revision control?

thanks in advance for your assistance.