Hi wafa ahmad,
Perhaps this KB article will be helpful for you:
Defining relationships between tables in a Microsoft Access database
http://support.microsoft.com/?id=304466
To learn more about database design, head on over to the Access Junkie's web
site, where you will find a supermarket of links:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Database
Design101
Good Luck,
Tom Wickerath, Microsoft Access MVP
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
> i can t understand realy how the relationships between tables in access
> database work ? please i need more advanced courses or some tips to helping
> me to figure out how its going .and also if that relationships its should be
> exicting in database office or one i work with tables i had to mad that
> relationships....thank you a lot