Recent content by glenak

Ok, I see what you mean. I'm very rusty in writing queries in MS Access. Also, just like you said, it seems Access is choosing to display results of the one-to-one relationship via the table view. In which case, is there a way to get it to show results of the one-to-many relationship instead?

Hi, G37Sam;1092796 I did the exact same thing, but it didn't work. In fact, this is the problem I'm trying to get across to you lot. Let me explain further. Using the relationship detailed above, suppose we have three departments: Admin, HR, R&D. And suppose we have 6 employees, three of...

Yes, Brighton, I have two instances of the department table on there

Er ... sorry, mate, but that's not really helpful. The relationship is perfectly legit. Are you saying Access is incapable of handling this sort of thing or you simply don't know, in which case we really shouldn't be having this conversation.

I've been using Access for a while, and even though I consider myself quite good at it, I've become a bit rusty and I'm not really sure how to do certain things. Anyway, here's the scenario I'm having problems with. Two tables, one "Employee", the other "Department". I want to have two...