Hi guys. I got a bounded form that supposed to allow me update/delete and add new records to project table.The form is displaying fileds from more the on table.(project,customer,department and employee tables)(linked to sql server tables). When i load the form i notice the drop down box does not show all values and i can not move trough records and ...I attempted to make the query in query design view but i do not know how to collect all the requried fileds.Furthermore, it is strange that i do not see the reletionships between query tables in query design view! I be happy if some expert teaches me how to fix this query.Thanks.

http://i5.photobucket.com/albums/y18...ormonload2.jpg
(form picture)


http://i5.photobucket.com/albums/y18...etionship4.jpg ( tables reletionships in sql server 2000)


http://i5.photobucket.com/albums/y18...tionships3.jpg

(table reletionships in access 2000 . I do not know why it does not show the reletionshops since i already defined the reletionships in sql server enterprize manger !)



http://i5.photobucket.com/albums/y18...etionship1.jpg

(form query )