View Single Post
  #1  
Old October 27th, 2009, 04:23 PM posted to microsoft.public.access.tablesdbdesign
f123 via AccessMonster.com
external usenet poster
 
Posts: 10
Default Relationships bwtween more than one table

am working now on one database where i have 5 tables, each record from one
table is related to one another in other table with One to Many Relation

in other words, each record from one table may has many records on the next
table

Example:

Tbl 1 ...Project
Tbl 2....Activity
Tbl 3...Description
....
....and so on

now Project May has Many Activity
the Activity May has Many Description
and the Description may has Many Records

Project
/ \


Activity1
Activity2
/ \ /
\
Description1 Description2 Description1
Description2
/ I \ / I \ /
I \ / I \