Thanks for your reply, am sorry it seems that i forget to mention my probelm,

however, the problem is i dont know how to create the relationship between
each table

also, i need to see the best way to present all the tables on one form where
i can update all the data?

appreciate any help

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200910/1