Intranet Shared Tables

Use this form to choose the _all tables that you want to share; that is, the tables that should reside only at the master site for this intranet. All other sites on this intranet will have SQL views into the master site's table, and they can add, update, and delete records through the views. For more information, see Setting Up Multi-Site Shared Tables.

In order to make changes on this form, you must be logged into the selected intranet's master site. From other sites, you can view, but not change, the shared tables configuration - as long as the master site is set up to replicate the Site Admin category to the other sites.

Displaying Records

First, you must select an existing intranet. If a master site has been declared, the system displays the master site name and a list of the _all tables that may be shared. Not every _all table is listed here; some are not available for sharing.

If no master site has been declared for that intranet, the rest of the form is blank and you cannot continue.

Selecting Tables

Use either of these methods to select the tables to share:

When you have selected the tables you want, select Actions > Save to save your selections.

Processing

CAUTION: During processing, the selected tables are removed from all sites on the intranet except the master site. Rebuilding the tables at the sites is difficult and time-consuming - so be very sure that you have everything set the way you want it before clicking the Process button.

After you have saved the records, click Process to perform the processing. The Processing Step area will keep you informed of the progress.


Related Topics

Setting Up a Master Site and Shared Tables

Unsharing Multi-Site Shared Tables

Intranets