how can we access data of subsites or interrelate subsite

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 template Timesheet and bugtracking. I am creating project , Client
in Timesheet template then i want to use same project and client details in
bugtracking template.
Help me....thanks
 
Hi,

If by Template you mean tables, you would simply have a link between the
primary key of one table and a created key called a foreign key in the second
table.

eg:

tblClient
ClientID autonum
ClientName text
etc

tblProject
ProjectID autonum
ClientID num (maps to ClientID in table tblClient)
etc

tblBugTracking
BugTrackingID autonum
ClientID num (maps to ClientID in table tblClient)
ProjectID num (maps to ProjectID in table tblProject)
etc

Hope this helps.

Damian.
 
Back
Top