Database Tables¶
The application uses a split database structure.
The front-end contains user interface components while the back-end contains the primary data tables.
Linked Tables¶
The front-end currently references 15 linked tables.
Examples:
| Table | Purpose |
|---|---|
| tblCadets | Stores Cadet information |
| tblCompanies | Battalion company structure |
| tblOrders | Order records |
| tblRewards | Award and reward records |
Local Tables¶
The front-end contains local tables used for temporary processing.
| Table | Purpose |
|---|---|
| tblDropdownFilters | Filtering support |
| TempOML | Temporary OML calculations |
| TempSortOrder | Sorting and processing |
Backend Location¶
The original linked table location was: E:\All Forms\All Forms_be.accdb
This path is specific to the original installation.
When deploying the application, linked tables must be updated to point to the current back-end location.