how can we access data of subsites or interrelate subsite

S

Share Neera

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
 
D

Damian S

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.
 
Top