Skip to content

Dependency Analysis

Module Dependencies

Form_Add Company Principal Project

  • External: Actdatabase, RecSet, RecSetTwo

Form_Enter Principal Project Name

  • External: SalesMultiRecSet, TempRecSet, RecSet, PrinRecSet, NewRecSet, IndRecSet, PillarRecSet, Actdatabase, QryRecSet, SalesRecSet

Form_Opening Dialog

  • External: Actdatabase, RecSet

Form_Principal List

  • External: Actdatabase

Form_Sales Brief List

  • External: SalesMultiRecSet, TempRecSet, RecSet, PrinRecSet, NewRecSet, IndRecSet, PillarRecSet, Actdatabase, QryRecSet, SalesRecSet

Form_SubFrm Edit Company Principal Project

  • External: Actdatabase, RecSet

Form_SubFrm Edit Principal Project Pillars

  • External: Actdatabase
  • External: DBEngine, db, ws, fso

Table Usage

Access

  • Module: basRelink

Application

  • Module: Form_Sales Brief List

CompanyProgrammeYearStatus

  • Query: Qry Principal Project List Main Dashboard

CompanyStatus

  • Query: Qry Company List

DatabaseUsers

  • Module: Form_Opening Dialog

Delivery Locations

  • Query: Qry Company List

Delivery Locations Sales

  • Query: Qry Get Sales Brief Marketing Sourced From

Else

  • Module: basRelink

End

  • Module: Form_Add Company Principal Project
  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List
  • Module: Form_SubFrm Edit Company Principal Project
  • Module: basRelink

Entrepreneur

  • Module: Form_SubFrm Edit Company Principal Project
  • Module: Form_SubFrm Edit Principal Project Pillars
  • Query: Qry Company List
  • Query: Qry Company Needs Replacement List
  • Query: Qry Company Pincipal Project Pillars
  • Query: Qry Count Number Months Billed by Company PP and Project Pillar
  • Query: Qry Principal Project List Main Dashboard

Entrepreneur Company

  • Query: Qry Company List
  • Query: Qry Company Needs Replacement List
  • Query: SubQry Get EP Ready for Allocation Info by Company

Entrepreneur Company Monthly Billings

  • Query: Qry Count Number Months Billed by Company PP and Project Pillar

Entrepreneur Company Principal Projects

  • Form: SubFrm Edit Company Principal Project
  • Query: Qry Company Needs Replacement List
  • Query: Qry Company Pincipal Project Pillars
  • Query: Qry Count Number Months Billed by Company PP and Project Pillar
  • Query: Qry Principal Project List Main Dashboard

Entrepreneur Company Programme Years

  • Form: Add and Edit Company Programme Year
  • Query: Qry Company Needs Replacement List
  • Query: Qry Principal Project List Main Dashboard
  • Query: SubQry Get EP Ready for Allocation Info by Company

Entrepreneurs

  • Query: SubQry Get EP Ready for Allocation Info by Company

Forms

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List

Frm

  • Module: Form_Enter Principal Project Name

If

  • Module: Form_Sales Brief List

NewPPID

  • Module: Form_Sales Brief List

NewRecSet

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List

Principal

  • Module: Form_Principal List
  • Module: Form_Sales Brief List
  • Module: Form_SubFrm Edit Principal Project Pillars
  • Module: Form_SubFrm Principal Project Pillar Sponsor Elements
  • Module: Form_SubFrm Principal Project Pillar Sub Products
  • Module: Form_SubFrm Total Billed To Date by Company PP
  • Query: Qry SubFrm Principal Project Pillar Supporting Documents

Principal Project Pillar Commodities

  • Form: SubFrm Principal Project Pillar Commodities

Principal Project Pillar Delivery Location

  • Form: SubFrm Principal Project Pillar Delivery Location

Principal Project Pillar Sourced From

  • Form: SubFrm Principal Project Pillar Sourced From

Principal Project Pillar Sponsor Elements

  • Form: SubFrm Principal Project Pillar Sponsor Elements

Principal Project Pillar Sub Products

  • Form: SubFrm Principal Project Pillar Sub Products

Principal Project Pillars

  • Form: SubFrm Edit Principal Project Pillars
  • Query: Qry Company Needs Replacement List
  • Query: Qry Company Pincipal Project Pillars
  • Query: Qry Principal Project List Main Dashboard
  • Query: Qry SubFrm Principal Project Pillar Supporting Documents

Principal Project Products Sold

  • Form: SubFrm Principal Project Products Sold

Principal Projects

  • Form: Add and Edit Principal Project
  • Query: Qry Company Needs Replacement List
  • Query: Qry Principal Project List Main Dashboard

Principals

  • Form: Add and Edit Principal
  • Query: JB Qry Update Procurement Contact
  • Query: JB Qry Update Transformation Contact
  • Query: Qry Company Needs Replacement List
  • Query: Qry Principal List
  • Query: Qry Principal Project List Main Dashboard

Principals Sales

  • Query: JB Qry Update Procurement Contact
  • Query: JB Qry Update Transformation Contact
  • Query: Qry Sales Briefs Not Through Gateway

Principals Sales Contacts

  • Query: JB Qry Update Procurement Contact
  • Query: JB Qry Update Transformation Contact

Products

  • Query: Qry Get Products Sold by Sales Brief
  • Query: Qry Principal Project List Main Dashboard

Products Sales

  • Query: Qry Get Products Sold by Sales Brief

ProgrammeYearLookup

  • Query: Qry Principal Project List Main Dashboard

Qry

  • Module: Form_Company List
  • Module: Form_Enter Principal Project Name
  • Module: Form_Principal List
  • Module: Form_Sales Brief List
  • Module: Form_SubFrm Edit Company Principal Project

Qry SubFrm Principal Project Pillar Supporting Documents

  • Form: SubFrm Principal Project Pillar Supporting Documents

Qry Sum Total Billed by Company PP and Project Pillar

  • Form: SubFrm Total Billed To Date by Company PP

QryRecSet

  • Module: Form_Sales Brief List

RecSet

  • Module: Form_Add Company Principal Project
  • Module: Form_Enter Principal Project Name
  • Module: Form_SubFrm Edit Company Principal Project

SQL

  • Module: basRelink

Sales

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List
  • Query: Qry Get BBBEE Pillars by Sales Brief
  • Query: Qry Get Sales Brief Marketing Sourced From
  • Query: Qry Sales Briefs Not Through Gateway
  • Query: Qry Sum Total Sponsorship By Sales Brief Pillar
  • Query: Qry Sum Total Sponsorship By Sales Brief

Sales Brief

  • Query: Qry Sales Briefs Not Through Gateway

Sales Brief Selection Marketing

  • Query: Qry Get BBBEE Pillars by Sales Brief

Sales Brief Selection Marketing Products

  • Query: Qry Get Products Sold by Sales Brief
  • Query: Qry Sum Total Sponsorship By Sales Brief Pillar
  • Query: Qry Sum Total Sponsorship By Sales Brief

Sales Brief Selection Marketing Sourced From

  • Query: Qry Get Sales Brief Marketing Sourced From

SalesMultiRecSet

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List

StrCriteria

  • Module: Form_Enter Principal Project Name

SubQry Get EP Ready for Allocation Info by Company

  • Query: Qry Company List

Temp

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List

Temp Principal Project Pillar Extra Information

  • Form: SubFrm Principal Project Pillars

both

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List

dbo_ApplicationVersions

  • Query: Qry Application Versions

the

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List

to

  • Module: Form_Enter Principal Project Name
  • Module: Form_Sales Brief List

your

  • Module: Form_Opening Dialog

zstblODBC

  • Module: basRelink

zstblODBC_db

  • Query: qryLinkODBC

zstblODBC_tables

  • Query: qryLinkODBC