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.
( tables reletionships in sql server 2000)
(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 !)
(form query )
SELECT dbo_Project.*, dbo_Customer.customername, dbo_Department.departmentname, dbo_Employee.lastname
FROM dbo_Project, dbo_Customer, dbo_Department, dbo_Employee;