Reflexive Relationship

Question

Reflexive Relationship

Dinesh Asanka

SSChampion

Points: 11058
More actions
August 28, 2005 at 11:41 pm

#68252

How can I create a Reflexive Relationship in MS Access not in MS access project. I got a document where I can create this relationship in MS access project.

My Blog: http://dineshasanka.spaces.live.com/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47794 More actions · Answer 1

From the dim dark annals of my brain, I think you need to add the table to the relationships page twice. Then you can link the relevant fields.

It's been ages since I've worked with Access, so that could be wrong

--------------------
Colt 45 - the original point and click interface

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 2

thankx for the update, I have done that way, But I think there should be another way of doing it

My Blog: http://dineshasanka.spaces.live.com/

Phil Parkin SSC Guru Points: 246695 More actions · Answer 3

There is - use the SQL pane and write the query yourself. Is that what you mean?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 4

Currently in there is relationship pane in which you can't do this type of releationships

My Blog: http://dineshasanka.spaces.live.com/

Phil Parkin SSC Guru Points: 246695 More actions · Answer 5

By "reflexive", do you mean a self-join? If so, I agree with Phill Cart's response - just add the table again and Access will create an alias for it.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.