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...