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 )


Code:
SELECT dbo_Project.*, dbo_Customer.customername, dbo_Department.departmentname, dbo_Employee.lastname
FROM dbo_Project, dbo_Customer, dbo_Department, dbo_Employee;