Is there a question?

(note: your example has "Description" coming from Project ... contrary to
what you described)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"f123 via AccessMonster.com" u50920@uwe wrote in message
news:9e39c0dd4167e@uwe...
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 \
.