Search results

any ideas guys?

Hi John, That is exactly the relationship I want. I have attached the spec for the database and the database, I am open to all constructive comments. Thank You TJ

Hi, Thanks for the reply. I just want to create a relationship between the two fields. I want the database in such a way that I manually enter a unique key in tblDepartment (DepartmentID -field) and from there it automatically gets linked with tblAcademicStaff (DepartmentID field). Basically...

Hi, I have created a datebase in access and have created 10 tables with relationships but I am having a problem creating TWO relationships with just one table. I need help (yes I am a N00B at databases). In my datebase I have an academic staff table and I want to link it to the deparment...